Showing posts from March, 2010

A few maximum limitations for SQL Server 2005

Every now and then i see a question pop up that asks what is the max this or that in sql server? Well here are some maximum values: Bytes per short string column 8,000     Bytes per GROUP BY, ORDE…

How to move database physical files?

If you want to move database physical files to a new location , you can use the "ALTER DATABASE" statements to bring the database offline , MOVE the files…

Stress Testing tools for SQL Server

http://www.microsoft.com/downloads/details.aspx?familyid=9a8b005b-84e4-4f24-8d65-cb53442d9e19&displaylang=en   http://blogs.msdn.com/psssql/archive/2008/12/19/using-sqliosim-to-diagnose…
Subscribe Our Newsletter