Browse by Tags

How fast you can obtain information about missing indexes? Its easy and quick!
23 November 09 12:49 AM | ssqa.net | with no comments

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...

Filed under: sql server, index, dba, indexes, best practice, execution plan, feature, dmv, missing index

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
08 May 08 09:35 AM | ssqa.net | 2 comment(s)

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...

Filed under: sql server, indexes, memory, cpu, cache, huge, dbcc shrinkfile, monitoring, databases, operating system

TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 08:10 AM | ssqa.net | 1 comment(s)

How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...

Filed under: sql server, database, tsql, table, change, indexes, setup, collation, installation, constraint, bcp