Interesting. For me, using sp_help_revlogins did not work going from 2000 to 2008.. But then, I was actually going from 2008 to 2008 R2. Still, it didn't work for me...

Just out of curiosity, I'd love to hear how many VLFs your database has. Run DBCC LOGINFO(0) in the database. The number of rows returned equals the number of VLFs...

You may also want to check the number of virtual log files in your transaction log. If there are many (meaning your transaction log has autogrown many times), restores will...

Temp tables are created and stored in the temdb system database, so look for bottlenecks there. Is tempdb on its own drive and not on the same drive as the...

Still trying to figure out what is causing these. It seems related to mirroring. I've got DDL logging on the server and I see lots of CREATE_EVENT_NOTIFICATION events happening, all...

I choose the "None of the above" option for a reason I haven't seen mentioned yet: snapshots are an Enterprise/Developer edition only feature. Therefore, on lower versions of SQL Server,...

Nevermind.. I think I figured it out.. The constraints are ANDed, so Step 3 was never executing because the precedents from both Step 1 and Step 2 were never true...

I should also add there is nothing in the SQL logs at the same time these errors show up.

alen teplitsky (11/1/2010)

---

i've been through a few and here is my experience

1. separation of duties. no devs can access production. IT can't access the development environment.

...

I've updated the Powershell portion of this routine to collect the total disk free space amount for the drives SQL Server uses. this also requires adding one column to the...

I gotta say, the best perks I ever had was when I worked for a company that made video games. We closed down between Christmas and New Years (and got...

Trey - you in Arizona? I might have interviewed for your company about a year ago. I interviewed for two companies - one next to the Cold Stone building and...

I've done this fairly recently and will be doing it again in a couple weeks. As previously suggested, the upgrade adviser is really handy.

There are two things I would watch...

Ah.. the first error is, as it says, a foreign key violation. Change your entries in the ServersToCheckDiskStats table to have square brackets around the server names.

The second error was...

Try changing the first part of the prodcedure to this:

/* Get a list of the servers to gather data from and their SQL version */

DECLAREServersCursor CURSOR FOR

SELECT'[' + ServerName +...