The thing is, it depends. In short recompiles are taking up processor time that could be spent elsewhere. But how often and how long is that processor time taken up?...

Suresh Kumar-284278 (5/28/2010)

---

Hi,

Would there be any performance impact deciding Integer or Varchar data type for a primary key?

Also, would it matter more if that column being Indexed (either Clustered...

Sure, that's a fine way to monitor blocking. There are other blocking scripts available in the scripts section of this web site too.

troy2.net (5/27/2010)

---

What i did wrong ?

I searched the google i get article may you guys know exact difference.

if they ask the difference in the sense , What are they...

Fortunately, unlike SQL Server 6.5, every version of SQL Server since version 7 prevents you from dropping the tempdb (trust me on...

In regards to service packs, you are 100% correct.

Each service pack is cumulative. So if you install SP3, you're install SP1 and SP2. This is a quote from Microsoft (located here):

Microsoft SQL Server 2005 Service Pack 3 (SP3)...

For an INNER JOIN they are most likely to always produce identical execution plans and the performance will be the same. As a general practice, because of this, I advocate...

Yep, sorry, completely insufficient data. Couldn't possibly even guess with what you've provided. Please follow Gail's link & post the additional information.

Books Online has a whole topic devoted to the problem. Take a look.

I prefer using the DMV's for this sort of thing now. To monitor connections I'd use sys.dm_exec_connections and sys.dm_exec_requests. You can combine those with other DMV's to get a lot...

Or even just look at the file size.

I would add, that with very few exceptions, it's always best to store any data as the data type it should be. I frequently see problems with people storing dates...

Since it's only been in production for a couple of weeks, I have not heard any news about a possible service pack. I suspect it's at least 6-9 months out.

Yes,...

You can.

There are some design issues associated with GUIDs (Globally Unique IDentifiers) that you might want to know about. They're notoriously poor choices for clustered indexes, just as an example.