For those who were expecting the third highest salary, here is a select for that

declare @table table(ID int identity(1,1) not null, Name varchar(10), Salary float)

insert into @table values ('A',123.45)

insert into...

Nice editorial and I couldn't agree more that companies should not treat employees like resources or objects. Unfortunately the corporate world has too many companies that treat people like...

Bummer, I only got one of the answers correct. I selected 2 recovery option parameters instead of parmeterization options. Can I get 1/2 a point?:hehe:

Oh well, that's what...

SanDroid (5/18/2011)

---

... Funny True Story: While explaining the need to replace Log Shipping with DB Publishing for some Federated Database servers for a Shipping Application an executive stopped the presentation...

tabinsc (4/20/2011)

---

I haven't proven this correct yet, but I am thinking redundant data in two tables makes sense if you need that data to join the tables properly and avoid...

Right. There are all kinds of edge cases that can be...

The inspiration for this question came from: http://www.sqlservercentral.com/TotalScores

The number of Points (won) - 599 - for me near the top of the Question of the Day Breakdown table does not...

Good question.

More information can be found here:

http://www.mssqltips.com/tip.asp?tip=2309&home

Interesting read and I totally agree that as more and more things get "connected" the need for better security will increase proportionally.

Also, I have the same kind of washer but...

SanDroid (3/24/2011)

---

...

Rich, I have suggested this many times in the past with many differant accounts. The answer has always been that QOTD is not moderated. The question...

I like the idea of a scale system to distinguish the different editions but I'm thinking the scale of the organization rather than the hardware.

A company with 1 business unit...

Thanks! That will save me some...

A while ago I implemented an SQL Server job that uses 7zip to compress backups after they run. I've been getting between 80 and 85 % compression.

When we upgrade I'll...

Great article thanks for sharing!

Some have mentioned that one must still have a local administrator account in order use this technique. Not entirely true because there are boot CD's...

I only got it right because I guessed correctly as to whether the author meant to ask about the number of drives needed for a complete Raid 5 array.

This has...