There are a small number of expert database designers who are capable of understanding the significant disadvantages and trade-offs of a denormalized design and using it in selected cases where...

You can use this script with any version of SQL from 7.0 up.

Script to analyze table space usage

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

Most of the applications that I see that make heavy use of cursors were either ported from Oracle to SQL Server or created by developers who only had Oracle experience.

We...

Get Server Database File Information

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

Some other connection might have the database open in single user mode.

You would have to kill that connection before the database can be set offline.

This is really an age old problem with no true solution. People have to be trusted with access to various valuable things, and there are always those that will...

I was a manager at a company that was about to have a layoff. Several managers at my peer level were sent an email that had been put together...

You can check yourself to see if backups were run. All backups are recorded in the msdb database.

This query will get you started:

select

a.name,

bs.*,

bmf.*

from

master.dbo.sysdatabases a

left outer join

msdb.dbo.backupset as bs (nolock)

on...

jim.powers (8/12/2008)

---

Michael Valentine Jones (8/12/2008)

---

Sometimes it is necessary to have different servers because they have different maintenance windows for the applications.

One might have a downtime window of 0100-0600 on Saturday...

Sometimes it is necessary to have different servers because they have different maintenance windows for the applications.

One might have a downtime window of 0100-0600 on Saturday and Sunday, and the...

Abhijit More (8/8/2008)

---

I would say that change the recovery model to SIMPLE, before that take a full backup of your database and as Mike said decrease the time limit for...

helloanam (8/7/2008)

---

I think first and last date of year will always be same irrespective of what year is it. 😉

first date: 01/01/ year

last date: 31/12/ year

therefore, no need to use...

You need to have transaction log backups often to control the size of the transaction log, expecially if you are doing large batch operations, like reindexing, index defrag, or big...

select

a.MyYear,

FirstDayofYear= dateadd(year,(a.MyYear-1900),0),

LastDayofYear= dateadd(year,(a.MyYear-1899),-1)

from

(

-- Test Data

Select MyYear = 2001union all

Select MyYear = 2002union all

Select MyYear = 2003union all

Select MyYear = 2004union all

Select MyYear = 2005

) a

Results:

MyYear FirstDayofYear ...

You should run transaction log backups a lot more often.

I usually set them up to run every 15 minutes, but run them as often as every 5 minutes if there...