Here are several things to hold transaction log growth to a minimum that I have done in the past:

1. Only defragment indexes that need it, say more than 30% fragmentation.

2....

DiverKas (10/26/2012)

---

I had a similar requirement, and FTS was the way to go. Only way the performance would get close to being reasonable. A LIKE with % on...

Dung Dinh (10/26/2012)

---

Michael Valentine Jones (10/26/2012)

---

It would be better to have the query do a search for the specific item they are searching for, instead of doing a catch-all search...

It would be better to have the query do a search for the specific item they are searching for, instead of doing a catch-all search on all columns they might...

select FirstDayOfMonth= dateadd(mm,datediff(mm,0,getdate()),0)

select LastDayOfMonth= dateadd(mm,datediff(mm,-1,getdate()),-1)

select FirstDayOfQuarter= dateadd(qq,datediff(qq,0,getdate()),0)

select LastDayOfQuerter= dateadd(qq,datediff(qq,-1,getdate()),-1)

select FirstDayOfYear= dateadd(yy,datediff(yy,0,getdate()),0)

select LastDayOfYear= dateadd(yy,datediff(yy,-1,getdate()),-1)

Often, small tables are used as foreign key lookups.

In that case, I prefer an surrogate integer clustered primary key to minimize the amount of space required in the child tables.

RVO (10/24/2012)

---

A comment to SSCrazy reply.

Why it has to be acceptable for all applications to be down at the same time? What if we move databases slowly, one by one,...

Small text columns over two characters in length should almost aways be varchar instead of char.

The only exception would be when you are absolutely sure that every value will be...

Another thing to consider is available downtime maintenance windows for each application. Unless there is a time slot where it is acceptable for all the applications to be down...

My preferred strategy has always been to make a nightly full backup and transaction log backups every 15 minutes, 24x7. Backup the system databases daily. I usually don’t...

Steve, I think you really need to post some pictures of you in your Rock Star days.

Don't forget evil DBAs!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46783

Specifying the versions would be good because it's hard to tell years later which versions an old question was meant for.

jackimo (10/12/2012)

---

So we host a vendor application that has some pretty serious performance issues. A DBA for the vendor has suggested that we run the following commands every 5...

ericwenger1 (10/12/2012)

...Can anyone give me more ammunition that what I've stated about? My manager told me that at his old

company they shrinked the database on a weekly basis and they...