MSSQLTips

to make it so you don't have to comment/uncomment lines of code, here is a tid bit I put in to run the script for either 2k or 2k5 if (@@microsoftversion / power(2, 24) >= 9) begin -- SQL 2005 command SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH (FILLFACTOR = ' +...

Excellent note. One question: how can I find documentation on the function LOGINPROPERTY in the Server Management Studio (SQL 2005)? LOGINPROPERTY doesn't exist in the help index. Have a good day.

This script offers a big advantage over simply using the maintenance plan GUI to setup transaction log backups: in SQL Server 2005, if you edit a transaction log backup task, all of your settings in that task will clear, and if it encounters a failure, the entire task fails, whereas this script skips...

Fantastic tip and well-written article. Relatively new to SQL Server 2005, 2am and I found myself wondering why a table wouldn't load in a web app that needed to be up by 6am. The tip was perfect. Thanks!

However, the use of SCOPE_IDENTITY() requires an addition SQL statement execution. While this may not seem like a lot of time, it can add up if you are doing a few million insertions. To me, the use of the OUTPUT clause seems much simpler than setting up and executing an additional SQL statement. It...

The really great news is that there is a new way to get the Identity value returned if you are using SQL Server 2005 . . . check out the OUT variables that you can use during an INSERT statement. You can return the ID column or anything else (even the whole bloody record ;-).

Though the post is nice but the example that was taken here can be easily handles using a self join on the employer table and using curser Can anyone please explain me why should we use CTE in place of CURSORS or SELF JOIN for the given example

Difference between " Select DISTINCT TOP 10 column_name from tbl " and " Select DISTINCT column_name from tbl " . And how many roqws it will execute and how much each query will take. SQL 2005