I would plan for growth. 

While it is easy to overlook today, what will happen when one of your applications gets so popular that you need to move it to...

Hello,

It looks like you are running build 2039.  IIRC that build (Base SP4) has the AWE bug.  So it probably needs 2040 or later.

Hi, just a reminder to use NOLOCK hints reading the trace or audit tables.

"oops"

jg

isa,

If you need something that will script out your schema and data, there are such products.  Nothing of the sort is built into MS SQL server, however.   I've only tried...

I use the Page Life Expectancy counter for this determination.  300 appears to be the accepted threshold for needing more RAM.  Looking at the Cache hit ratio is sketchy, because...

I came here to say what Amit said. So, seconded on the sysinternals tools. 

Hello,

You might want to check the location of the bad data.  If your corruption exists in a non-clustered index, you are in luck, because you can drop and re-create the...

Shailesh,

Change the sa password on the server.  Then give the developers access only to what they need via a different identity.  Either a trusted connection via domain security or a...

Hi Francis,

My suggestion is:

1. set your recovery model to simple.  

2. take a full backup of your database

3. (optional) Look at why this will solve your problem.

First, the simple recovery...

Ther is apparently some confusion about a covering index.  Indeed, the select list should be covered by such an index.  Usually the first term is the PK or specifically designed...

I think you have to have more than 8 CPUs before you can license SQL based on the Affinity Mask.

But there is another solution to your problem (besides ripping out...

Merge replication will manage identities for you.  Look it up in BOL.  search for "managing identity values".

So which one is more realistic for an average run of the query?   You might force the rowcount estimate using a fast X query hint. 

Try running the query with...

What is the final rowcount estimate for each way?

Hi jacob,

That's what I get for attempting comprehension before the coffee kicks in.