Blogs about: Sql2005
Featured Blog
TRUNCATE Table Vs DELETE Table
TRUNCATE Table Fastest method for deleting all the rows from a table. We can say Truncate Table is similar to Delete Statement without WHERE clause (for.e.g. DELETE FROM EMP) Uses fewer system and tra… more →
Harsh Shah's Weblog
Simple t-sql script for checking integrity and full backups of SQL Server user databases
goodoldaddy wrote 2 weeks ago: I have decided to post some useful t-sql scripts for SQL Server databases as a part of my blog. He … more →
TRUNCATE Table Vs DELETE Table
shahharsh wrote 2 months ago: TRUNCATE Table Fastest method for deleting all the rows from a table. We can say Truncate Table is s … more →
Limiting the maximum memory used by SQL Server 2005
Jason wrote 2 months ago: A great tip for limiting the maximum memory used by SQL Server 2005 when you are hard pressed for re … more →
finally
— 1 comment
yetanotherdayatwork wrote 2 months ago: so in the system is needed a particular key for the security portion (duh). with the key, base64hash … more →
How do I: Install the UDDI services database components on a SQL2005 instance.
Jason wrote 3 months ago: When installing UDDI services database components onto your SQL2005 instance you may receive this er … more →
Difference between Clustered and Non Clustered Index in SQL Server 2005
— 5 comments
shahharsh wrote 6 months ago: Clustered Index Leaf node contains the actual data pages. The data row of the table are sorted and s … more →
How to Truncate Log Files in SQL2005
techbegin wrote 6 months ago: Steps to truncating log files and shrinking your database: 1. Get the physical names of your databas … more →
T-SQL Function to convert Unix Timestamp into MS SQL datetime
horgasz wrote 10 months ago: Okay. Previously we converted datetime type values into unix timestamps. Now here is how to convert … more →
Freetds and windows :)
— 3 comments
horgasz wrote 1 year ago: Well I was trying to set up freetds to work with PHP5 on my Windwos XP development box with Microsof … more →
Adding comments to an XMLA script
ihafidh wrote 1 year ago: So I was trying to run an XMLA script and kept getting errors. Below is the script. You will notice … more →
Generate Sequential Number in SQL Server
— 1 comment
shahharsh wrote 1 year ago: Here is the small example on how to generate sequential number in SQL Server. DECLARE @cnt IN … more →
Download SQL Server Product Samples
shahharsh wrote 1 year ago: SQL Server 2005 Product Samples http://www.codeplex.com/SqlServerSamples/Release/ProjectReleas … more →
Microsoft BI Demos
— 1 comment
shahharsh wrote 1 year ago: You can find quick demos on Microsoft Business Intelligence at the below location. http://www … more →
Executing a BAT file in SSIS
ihafidh wrote 1 year ago: I wanted to execute a batch file in SQL Server Integration Services, and I wanted to utilize two par … more →
SQL Server 2005 Triggers
— 3 comments
scmay wrote 1 year ago: Getting a list of triggers SELECT * FROM sys.triggers select * from sysobjects where xtype =’T … more →
Shrinking SQL2005 log files
mattlog wrote 1 year ago: So when I migrated our SQL2000 server to SQL2005 – which was primarily used as our back-end Go … more →
Difference Between SET and SELECT commands in SQL Server
shahharsh wrote 1 year ago: SET SELECT Can assign the value of an expression to the variable Can assign the value of an expressi … more →
TFS: Installation
rinonu wrote 1 year ago: http://ozgrant.com/2007/07/15/hands-free-tfs-install-part-3-installing-team-foundation-server-unatte … more →
A Pratical use for Dynamic SQL and FOR XML
Coolcoder wrote 1 year ago: SQL Server 2005 or 2008 required for this. I don’t pretend to be a fanboy of dynamic SQL but t … more →
