I have found the best way to determine if a very large table should have additional indexes is to see what is running against that table. If there is...

I've used this method quite often. Simple enough.

Kurt

Jeff Moden (10/3/2013)

---

Steve Smith-163358 (10/3/2013)

---

Thank you all very much for your replies, and thank you Jeff for the excellent article that Alan linked to earlier.

I had often read about the...

Although I have not actually tried it I did find an article that might help you out:

http://technet.microsoft.com/en-us/library/ms137656.aspx

Hope this helps.

Kurt

Steve Smith-163358 (10/3/2013)

---

Hi,

thanks again for the replies.

At the moment, the process we have for dropping these tables does indeed run out of hours.

However, I've been tasked with rewriting it for...

If what you are doing occurs every so often, say, once a week, then consider creating a job that runs on the SQL Server Agent off hours. Additionally, if...

I agree, Gail's article has all of the details you need to know about managing transaction logs. Now if you are experiencing...

How often do you back up your transaction log? I have t-log backups that runs on frequencies of from 15 minutes to 1 hour.

Kurt

What is the recovery model of the database? If it is FULL then consider scheduling a transaction log backup to manage the transaction log.

Kurt

Jeff Moden (10/1/2013)

---

Kurt W. Zimmerman (10/1/2013)

---

kevaburg (10/1/2013)

---

Kurt W. Zimmerman (10/1/2013)

---

I think the resolution is more a function of control. As a DBA restrict access to those developers who don't at...

kevaburg (10/1/2013)

---

Kurt W. Zimmerman (10/1/2013)

---

I think the resolution is more a function of control. As a DBA restrict access to those developers who don't at by the rules. Make them...

I think the resolution is more a function of control. As a DBA restrict access to those developers who don't play by the rules. Make them come to the DBA...

I moved a VLD backup from New York to Denver, CO. I backed up the database and FTP'd it to the destination. It took several hours but it...

I've been making it a practice to allocate 2gb of memory to the OS as a general rule. I have seen some random cases where SQL Server will overtake...

I have a tendency to over provision TEMPDB. For a machine that has 16 cores or less I will create 1 file per core. Over 16 cores I...