First question is, are you running read_uncommitted? If so, you might need to reconsider that choice. I don't recommend using that connection setting for most systems anyway.

If the read is...

I've used Idera's Diagnostic Manager and Microsoft's Operations Manager both to moniter servers in disparate locations. They work fine as long as they can connect to the machines. Our situation...

However, joining tables across servers, let alone across oceans, can be very problematic from a performance standpoint. Frequently with linked servers you'll see all the data from the first server...

It really depends. We have systems still being worked on in VB6 that are connecting to SQL Server 2008, so there's not magic requirement that says you must move up....

I'm sorry, but the question is a bit vague. I'm assuming you're tasked with doing this at work and you've never done it before.

First, you need to differentiate between new...

It's very difficult to tell precisely what's occurring when only looking at images. There is a lot of information contained within an execution plan, not simply the graphics. In the...

Tables, foreign keys, you name it and we've got it in source control.

The reason we don't use projects and SSMS is simply because there's no way to automate a build...

You also need to be very careful about versioning and labelling your code so that you always know what state the source is in. Then, you only ever build the...

If the database is from a more recent hotfix or service pack you need to apply that hotfix or service pack to your machine. Once done you should be able...

Absolutely follow BitBucket's advice.

Just don't run the Profiler GUI directly against any of your production systems. Only use the server side trace (TSQL scripts) against production systems.

You have to use source control as the basis upon which to build the database. Don't edit procedures on the database, edit the scripts and then apply these to the...

I'm with Lynn too. It's either stats or parameter sniffing or both.

To get the execution plans, you can query the dynamic management objects to pull it out of cache directly,...

I've seen major applications done both ways and the single, purpose built table style of design just flat out works better. It's easier to maintain the structures, there are fewer...

We've been experiencing the same thing on one database on our server. I've been running in circles trying to find anything wrong on the database side of things. Finally seeing...

RBarryYoung (12/13/2009)

Actually its the word most often said immediately before someone posts...