this will almost certainly be best solved with an EXISTS type of query, but as others have said you will need to provide better inputs for us to help you...

1) use ola.hallengren.com's maintenance suite. free, documented and awesome

2) track what gets fragmented and adjust fill factors appropriately to avoid too much fragmentation between index maintenance interval

Solving the problem at the source - I like it!!

I cannot count the number of times I have seen customers implement partitioning (an ADVANCED and COMPLEX feature) only to have it not help or like you are seeing make...

John Burris (2/3/2012)

---

I have a 2 node active passive cluster. They are dell 810 with 4 6core procs, 128 gigs ram and 10TBs of San storage. A week...

Tempdb12 (2/1/2012)

---

I have a really wired issue doing on. One of the Stored Procedure takes about 5 mins to execute the first time in the morning(for the first user who...

Hey Bram - do your customer a favor and hire a professional performance tuning consultant to find and fix the cause(s) of bad performance at this client. You can...

vijay82 (1/31/2012)

---

Hi,

We got a isuue that user is facing a performance problem.?

i have checked and don't find any issue in the errorlog and no blockings. i have checked the index...

madhu-686862 (2/17/2009)

---

Thank you

We have Raid 10 SAN storage drives.

Disk lay out as below:

D:datafiles

E:Secondary data files

F:log files

Z:Backup Drive

and the instance is clustered.

I did not understand why Iam getting high disk...

You must absolutely NOT do this if you expect any type of performance and concurrency:

AND SubId = COALESCE(@SubId,SubId)

AND CustId = COALESCE(@CustId,CustId)

AND Reference = COALESCE(@Reference,Reference)

AND CustOrderNo = COALESCE(@CustOrderNo,CustOrderNo)

This...

They totally ROCK, but you MUST get enterprise-grade ones. I think FusionIO rules that roost right now, and for good reason. I have been recommending those to clients...

Altogether now: PAUL WHITE ROCKS!!!! :hehe:

ananda.murugesan (1/27/2012)

---

ok, please confirm as below configuration

So will decide to change disk configuration for before implementation SQL server 2008 in OLTP environment

Total five HD 300x5 15K RPM SAS, and get...

You cannot...

Split your string into a temporary table (NOT table variable) and then join to that for your output query. Problem solved.