1) if you want to really see what is going on, run a STATEMENT COMPLETED profiler while this query is running. But BEWARE doing this on a production box!!

2)...

Confusing Queries (3/23/2012)

---

We did not have proper indexes on production and almost all the queries were using clustered index scan having high physical reads.

Now we have created new indexes specially...

GilaMonster (3/25/2012)

---

Lian (3/24/2012)

---

Now if you were to set it to use 9 gig out of 10 gigs the server administrators are seriously concerned and raise the alarms and...

sqlquest2575 (3/23/2012)

---

Well..SQLGuru..first of all i would like to thank everyone who responded to my question and secondly..i was just trying to get some expert advice and was not trying to...

Divine Flame (3/23/2012)

---

TheSQLGuru (3/23/2012)

---

I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad for your...

GilaMonster (3/23/2012)

---

TheSQLGuru (3/23/2012)

---

There are MANY times where you don't WANT the...

I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad for your IO subsystem AND...

adrienne.lore (3/22/2012)

---

OK... so I guess my concern is more with index fragmentation then, not disk. I was also told that in a thin-provisioned sql environment, this also meant...

From the OP:

>>But it just picks the last one.

Jeff kinda touched on this, but I wanted to reiterate something: there is NO ordering in set based processing unless...

There are MANY times where you don't WANT the engine to...

opc.three (3/22/2012)

---

The SSMS Tools Pack has a built-in feature to help you generate INSERT statements from a table, or even from a specific query...very handy.

SSMS Tools Pack > Generate Insert...

sqlquest2575 (3/21/2012)

---

Hello Friends, I was wondering if you can help me finding a solution....We need to extract data on a daily basis from production database but since this is production...

Go to ola.hallengren.com and use the AWESOME database maintenance stuff found there. Fully documented and incredibly flexible - and FREE!

Devil's Bloody Advocate (3/20/2012)

---

I thought that FusionIO cards sat in the PCI slots on the motherboard and were not...

Since you are looking for options, ApexSQL has source control built into their Edit product. AFAIK they were the first to have that functionality baked into an editor.