Browse by Tags

All Tags » SQL (RSS)
Sorry, but there are no more tags available to filter with.

SQL Server reference KB article on rollups by steve schofield

I was looking for a sql server 2005 rollup. Here is a KB article that has all of them. http://support.microsoft.com/kb/937137
Filed under:

SQL 2005 - What version are you running? by steve schofield

I had to work on deploying SQL 2005 service pack 2. I tend to look at the version numbers so I can make sure the upgrade is consistent. Well, SQL 2005 was a bit interesting. http://support.microsoft.com/kb/936305/en-us http://blogs.msdn.com/psssql/archive...
Filed under:

Perfmon reference articles by steve schofield

I'm working on some perfmon issues related to sql server. Here are a few links with articles covering which perfmon counters and values should be used. If you are in a position where you have to troubleshoot these types of things, this is a must read...
Filed under:

Change schema name on Tables and Stored procedures in SQL Server 2005 by steve schofield

I was trying to change the 'schema' name on an object from 'username' to 'dbo' in SQL Server 2005. The script generates code you have to copy, paste and run on the database. Thanks to the DBA gurus on the sql-sqlsvr-sprocs@sqladvice.com list that provided...
Filed under:
More Posts