GilaMonster (10/10/2013)

---

Always. I really don't like SQL and the OS fighting over memory (which they will...

inevercheckthis2002 (10/9/2013)

---

With sincere apologies the thread hijacking... I'm trying my best to gain...

inevercheckthis2002 (10/9/2013)

---

Which are you looking for? RAID...

dwain.c (10/7/2013)

---

Kurt W. Zimmerman (10/7/2013)

---

A simple way to debug dynamic SQL is to simply print it out. Then copy/paste the output into a New Query window and see where...

Don't get me wrong, Dynamic SQL has it's place along with Cursors. However I have seen dynamic SQL used in places where it was not truly needed. Case...

Does your instance of SQL Server have xp_cmdshell enabled? If so you can capture the result of the DOS command "DIR" into a table variable containing the date and...

I am not clear with what the criteria you are using for deleting. Maybe an example could help.

Kurt

Stubby Bunny (10/7/2013)

---

Hi Kurt,

Thanks for the info, I dont mind using cursors to do things as such. Until i found this forum (WAY BETTER and more expertise) I...

Stubby Bunny (10/7/2013)

---

All,

Ok if you are saying a cursor is the best way to do this i'm on board, I know how to do them all quite well just getting...

When I am asked to look into a SQL Server performance issue I want to know more about the SQL Server box, hardware resources (Memory, CPUs, Disks), how is TEMPDB...

Grant Fritchey (10/7/2013)

---

Kurt W. Zimmerman (10/7/2013)

---

Grant Fritchey (10/7/2013)

---

Don't manually restore the database.

Create a script that restores the database and make the procedures you need part of the script (after the...

A simple way to debug dynamic SQL is to simply print it out. Then copy/paste the output into a New Query window and see where your errors are. ...

Grant Fritchey (10/7/2013)

---

Don't manually restore the database.

Create a script that restores the database and make the procedures you need part of the script (after the restore of course). You can...

aleksandar.ivanovski (10/7/2013)

---

Thank you all for the answers.

I did created indexes on all FK fileds and run the following query:

Select (s-thing from 5-6 tables)

from Table_Containing_FK A

Left outer join B

on A.id1 =...

Well it sounds like you've been "around the block a few times" on these types of issues.

I've taken over the responsibility of 20+ SQL Server boxes and have...