Browse by Tags

Help Microsoft BI Development team to Build next version of AdventureWorks databases
06 February 09 01:13 PM | ssqa.net | with no comments

Until SQL Server 2000 you may be familiar with pubs & northwind sample databases that were available along with SQL Server installation and since release of SQL 2005 the scenario has been changed for Sample databases.The version of AdventureWorks...

Filed under: sql server, best practices, download, features, databases, northwind, feedback, msft, samples, pubs, adventureworks

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