SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

I'm doing a test migration of the SQL server that services our in-house ERP application from its current OS using 2003 R2 32 bit running SQL server 2005 Standard 32 bit to a VM hosted on Xenserver 6.1 ...