steveb (6/22/2009)

---

Jeff Moden (6/22/2009)

---

jeffrey yao (6/20/2009)

---

Michael Valentine Jones (6/18/2009)

---

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and...

You need to investigate the queue length in more detail on a disk by disk basis. Are the the long queues for reads or writes? Are the long...

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko throw around to try to impress people,...

I attended a public speaking class where the first thing they did was give us five minutes to prepare to give a five minute talk on “How great you are...

We do mainly web based applications, and assign a different Windows account for each web site. The users authenticate to the web site, and the web site account connects...

You should check the growth size setting on your log file to make sure it is not set to a very large value or percent. If it is, set...

Jack Corbett (6/2/2009)

---

I'm not promising that this will scale, but it will give the results you require

DECLARE @table TABLE (date DATETIME)

INSERT INTO @table (

date

)

SELECT

'20090112'

UNION ALL...

select

Hours = datepart(hh,TimeEnd-TimeStart),

Minutes = datepart(mi,TimeEnd-TimeStart),

Seconds =...

Will Summers (5/28/2009)

---

Hmm. I will play around with the backup spanning option. This may help me out a bit. I would have to backup to multiple files...

I always add an index on a foreign key column. If you don't have an index on the foreign key, any join with the selection criteria on the parent...

See the responses posted to this same question on SQLTeam:

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

If your problem is getting backups to fit on DVDs, you can backup to multiple backup files. SQL Server will split the data across multiple backup files that will...

ssb (5/22/2009)

---

Thanks for the reply Michael.

So I will use separate accounts for each of the services across each of the servers. Just out of curiosity besides what you mentioned...

Use a different account as the service account for each SQL Server.

If you use the same account on more than one server, it becomes almost impossible to change the account...

Float stores the data as binary numbers, and this causes problems in applications where there needs to be an exact base 10 representation. Many base 10 fractions have no...