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, ORDER…
Showing posts from March, 2010
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 TO …
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-sq…