Thursday, 28 February 2008

Restrict SQL Server Login –SQL Server 2005

›
There is always a need to restrict the user logins into the SQL Server databases. Many DBA’s face this difficulty, as the restriction of log...
3 comments:
Friday, 22 February 2008

SQL Server TempDB useful tips

›
Moving Temp Database Files Step 1: Move the tempdb files to a new physical location (mostly on disk drive in RAID protection 1, 1 + 0 or 5 )...
3 comments:
Wednesday, 14 November 2007

Scripts to Drop and ReCreate Indexes in SQL Server 2005

›
SQL Server 2005 “GENERATE SCRIPTS” wizard does not have the option to generate the Index scripts alone from the database. The below script c...
248 comments:
Thursday, 7 June 2007

SQL Server 2008 CTP is released

›
Microsoft has released its much-awaited SQL Server 2008 (known popularly as “Katmai”) CTP version that is designed to meet the Data Platform...
2 comments:
Saturday, 2 June 2007

MARS (Multiple Active Result Sets)

›
MARS for (Multiple Active Result Sets) is a new feature supported in SQL Server 2005 Data access that allows multiple requests to interleave...
4 comments:
Monday, 28 May 2007

Online Indexing in SQL Server 2005

›
Online Indexing is a new feature available in SQL Server 2005. In SQL Server 2005, DBAs can create, rebuild, or drop indexes online. The ind...
2 comments:
Thursday, 3 May 2007

Performance tuning using Include columns in SQL Server 2005

›
SQL Server 2005 extends the functionality of non clustered indexes by adding non key columns to the leaf level of the non clustered index us...
8 comments: