Not...

I wish they know you can actually snap a man in 2 with all your martial arts training.

Not sure they'd do the right thing and post un-dangerous answers... but still...

I'm more curious about why you think you have an issue with this?

My guess is on randomizing data. Let's...

Very simply put. You ask the server to do WAY more work than needed and it hurts performance with a very long list of reasons.

Worst of then all, you'll...

There's a deeper problem here than group by.

If you have duplicate data in the insert it means that the query is not correct or you already have bad data in...

Please don't cross-post. I already answered your questions there :

http://www.sqlservercentral.com/Forums/Topic1110808-150-1.aspx

How could that possibly help? There's an error and dml level, the trigger won't even get raised!

Here's what I use. The only thing you have to do is NOT clean the backup history (manual or by scheduled jobs).

Of course you need to take backups to...

Grant Fritchey (5/18/2011)

---

If you're trying to isolate it for a restore or some other operation, set it to restricted user and use the ROLLBACK IMMEDIATE command. It will immediately cause...

Grant Fritchey (5/18/2011)

---

Ninja's_RGR'us (5/18/2011)

---

Grant Fritchey (5/18/2011)

---

And if the constraint is not valid, the optimizer won't use it for simplification, eliminating tables from joins when it can because it knows the...

Grant Fritchey (5/18/2011)

---

And if the constraint is not valid, the optimizer won't use it for simplification, eliminating tables from joins when it can because it knows the data will be...

Not sure I understand what you are asking. so you want to close all the connections to 1 database? Why not take it offline and bring it right...

Make your rdl report. Once you get it working copy the file in your asp .net project. add the c to the extension so you get rdlc.

Populate the...

Am I misinformed in this? I was always told that reorg was between 10 and 30, not 5 and 30.