I got the question wrong.

If you look at this article it is not described as a system database, but it is a required database that must accompany the...

Shaun McGuile (5/7/2008)

---

janine.rawnsley (5/7/2008)

---

Works fine in SQL2000.. you'd get the start date column twice (once at start, once wherever it naturally sits in the order of columns on the table.....

Cursors remind me of the Army. Give a Private a shovel and tell him to fill in the huge hole one shovel full at a time, when there is...

I can't add much to what has been said, buthere is my 2 Cents worth. Matt is correct. what do you want to spend your time doing, correcting data...

If this is a one time import and with no data manipulation or simple manipulation, then the import wizard is easy.

If there is a recurring import or has some moderate...

Vinu,

The command Gail provided works as long as SQL Server can do an implicit conversion. What is your datatype and what dataype are you wishing to change it to?

Dapetrella,

How often are you performing transactionlog and full backups? Do you perform differentials? If you have a scheduled transaction log backup, you should run it more frequently. If...

GilaMonster (5/5/2008)

---

Q (5/5/2008)

---

• Create many files to maximize disk bandwidth and to reduce contention in allocation structures. As a general guideline, create one data file per CPU. Each...

Can you post the error message?

GilaMonster (5/5/2008)

---

Here's something:

Working with tempdb in SQL Server 2005

An excerpt...

tempdb supports only one data filegroup and one log filegroup. By default, the number of files is set to 1. Multiple...

The QOTD desired result set included January and August....

At least some of you guys thought about it on a Friday morning. I have to admit all I did was look at the question and say yeah you...

Did you create this using the GUI or did you manually create the backup statement?

Jack Corbett (5/2/2008)

---

I just figured you would have a months table with the number of days in the month as each of the months mentioned have 31 days. So...

Yep should have just given them the nuclear option right from the beginning.