I'm guessing the two drives are identical but can you confirm that? If one drive is faster then that would explain...

paul.knibbs (10/25/2012)

---

OK, OK, I admit it: there are probably situations where this would be useful. I suppose I was thinking more about the "delete without WHERE" option, which to me...

Kenneth.Fisher (10/22/2012)

---

Does anyone think I should go ahead and add this as a follow up QOTD? Or do one about reseeding causing a duplicate identity? Or not bother...

john.arnott (10/22/2012)

---

Try predicting the result of the final SELECT in this script:

CREATE TABLE IdentTest

( --Ident INT NOT NULL IDENTITY (1,1)

varfield varchar(100)

)

INSERT INTO IdentTest VALUES ('xyz')

INSERT INTO IdentTest VALUES...

Thanks, Hugo.

What is the use case for the STR function? Namely, when would this be used as opposed to just doing a convert? A round can be used to...

Rod at work (10/17/2012)

---

I've been interested in PowerShell for a while now. I try to read every PowerShell article that comes along, unless it is a very long article,...

L' Eomot Inversé (10/14/2012)

---

I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view...

I wasn't able to convince my boss to set SAN space aside to restore our databases but since drives for a workstation are cheaper I was able to convince him...

JamesMorrison (9/24/2012)

---

What would you suggest for those that cannot do the 'verify backup integrity' due to time constraits?

In my environment we have multiple production database clusters, each with multiple...

I recently talked my boss into getting a drive big enough to restore all of our DBs so we can pull them from tape and do tests on a few...

Any chance the account...

Adam Seniuk (8/16/2012)

---

Also when installing I found it easier to install with default accounts then go back and reconfigure the services with the AD accounts, any one see issues with...

When I started here the same account was used for all servers and services. All new servers get new accounts created though and we're working on changing the account...

You're just posting to get your point back then? 🙂