Further on Chris's reply, this is a high level representation of what goes on behind the scene when a query is executed, it can be good, bad or ugly but...

Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

😎

Luis Cazares (8/14/2015)

---

Ed Wagner (8/14/2015)

---

crookj (8/14/2015)

---

BL0B_EATER (8/14/2015)

---

Ed Wagner (8/14/2015)

---

SQLRNNR (8/13/2015)

---

Ed Wagner (8/13/2015)

---

DonlSimpson (8/12/2015)

---

SQLRNNR (8/12/2015)

---

Luis Cazares (8/12/2015)

---

WayneS (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Ed Wagner (8/12/2015)

---

SQLRNNR (8/12/2015)

---

whereisSQL? (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Eirikur Eiriksson (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Steve Jones...

kevin.ellis86 (8/14/2015)

---

These results look like how to create the tables which I don't need help with. Suppose these two tables had no relationship between them built yet and I wanted...

drew.allen (8/14/2015)

---

Alan.B (8/13/2015)

---

drew.allen (8/13/2015)

---

Alan.B (8/13/2015)

---

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the...

odeddror (8/14/2015)

---

All I want is to count actual column count per all tables (and schema too)

row count is sometime can be misleading (nulls, 0's or ' ' spaces)

Your sproc...

He he, if I had a penny for every mis-spelling of my name...

Here is a simple profiling procedure I've used for years, nothing fancy but often quite helpful.

😎

NOTE: By the nature of the profiling, it can and will place considerable stress on...

Alan.B (8/13/2015)

---

drew.allen (8/13/2015)

---

Alan.B (8/13/2015)

---

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text()...

kevin.ellis86 (8/13/2015)

---

So any transaction before 2012-07-19 would have an ID of 9368 and anything after would have an ID of 9369. Again sorry if this doesn't format correctly. Thanks for...

busraker (8/13/2015)

---

The upgrades are incremental from the vendor. They don't recreate the database, only add / alter objects. The only risk would be if the vendor introduced an...

WayneS (8/13/2015)

---

Lynn Pettis (8/13/2015)

---

WayneS (8/13/2015)

---

Why is it SQLServerCentral gets so many Oracle questions on it?

Do you think it would be beneficial to create an Oracle thread? (Would it actually work?)

Or...

SQLRNNR (8/13/2015)

---

No this is the bottom...

Luis Cazares (8/13/2015)

---

Eirikur Eiriksson (8/13/2015)

---

Grant Fritchey (8/13/2015)

---

I'm sure that a large part of this is English as a second language. But lordy, can the...

Grant Fritchey (8/13/2015)

---

I'm sure that a large part of this is English as a second language. But lordy, can the questions be worded more...