astar (11/21/2008)

---

I am having a huge problem with my stored procedure which is cozing a table locking and I can't figure out how to resolve it.

Here is some additional details:

We...

Even if you don't, as others recommend, have 'control' or even input as to the configuration of the SAN for your SQL Server storage needs, you probably still should create...

Yep, I was correct. This will get even worse if you introduce joins into the mix, because the optimizer may 'guess' 1 row will be returned (quite a common...

1) there are a kajillion configuration changes that could have happend to cause this slowness. Good luck finding out if one or more occurred and which one may be...

1) It is a common MISconception that table variables are memory-resident only. This is false. They will get written to disk in tempdb just like regular temp tables...

Well, you gave us no design docs, table or code scripts, data metrics, etc so we are extremely limited in our ability to help you.

Having said that, I...

Alasdair Thomson (11/18/2008)

---

We do actually run some server maintenance tasks weekly, such as disk clean up, defrag etc, but ironic that the benefits that I get from a defrag were...

Being even more proactive what you should do (and what I advise all my clients to do as a sql server consultant) is to grow your database to the size...

Alasdair Thomson (11/17/2008)

---

If you want to recover this additional space taken, then check the db growth first (otherwise the space you recover may just get re allocated) I usually have...

check out dbcc memorystatus. search online for guideance about this undocumented dbcc command.

1) Yes, you should defrag (and keep defrag'd) OS-level files.

2) I would consider shutting down sql server if possible.

3) Take a look at Disk Keeper. ...

IIRC they purchased it from a company that developed it years ago. I tested the product out some...

jlp3630 (11/11/2008)

---

The queries that I posted are actually the rewritten versions. Over the course of the report creation, this stored procedure (and it's "sibling" stored procedures) is getting called about...

jlp3630 (11/10/2008)

---

Thanks for the advice. Unfortunately, a consultant is not an option because I'm working for a startup company. I was hired on to be the DBA because of my...

Dude, if you are new to perf tuning and are looking to improve stuff that currently takes days to run that could be a pretty tall order. 🙂

Here is...