My guess is that this is actually a symptom of something else, likely a poor IO subsystem. Have you done a waitstats and file IO stall analysis? Also,...

Partitioning is a very advanced/complex subject. You REALLY need to have experience/training to both setup/manage them properly as well as write proper queries that might take advantage of partition...

Given your questions and that you are taking over for a previous DBA it sounds like you are in need of a system and performance review from a professional. ...

I have numerous standing clients and EVERY ONE OF THEM is in desparate need of at least one SQL Server DBA. I routinely get calls/linkedin messages from a bevy...

1) sp_whoisactive

2) glenn allan berry has great diagnostic collection script

3) brent ozar has a good 'blitz' script

best is to change channel_cd to be NOT NULL with a default of ''. Then remove all those horrid ISNULL(.., '') things from your query. And if channel_cd...

Agreed - and OP, please be sure you set your SSMS scripting options to include everything related...

ChrisTaylor (8/11/2011)

---

a method i've always used and works for me is this:

with t (rn, col1, col2) as

(

select

rn= row_number() over (partition by col1, col2, etc order by col1, col2, etc),

col1, col2,...

Most people don't understand that a seek isn't always more efficient than a scan, and can in fact be unbelievably LESS efficient. If you are hitting (or the optimizer...

alen teplitsky (8/9/2011)

---

probably just me but i try to avoid temp tables as much as i can only because i don't like the I/O overhead of using them. One developer...

tonyarp05 61903 (8/8/2011)

---

Hello,

Anyone can help me

I have updated one stored procedure without commended out which line need to modify.

Now I want to inform the client which line i have...

Why are we 2 days into futzing around with this question without having seen a create table script yet? Can't do anything useful without that.

OP - please...

Given that you are only using 6 drive letters as it is I see no reason to move to mount points for your standalone servers.

1) The primary if not only reason do break down a complex query into multiple steps with interim storage (using TEMPORARY TABLES, NOT TABLE VARIABLES as discussed in number 2...

micbra (8/4/2011)

---

Thanks for the information TheSQLGuru. Any suggestions/suggested reading on tuning my instances? For example, are there perfmon counters I can look at to see how much BufferPool...