raulggonzalez (1/17/2014)

---

PHYData DBA (1/17/2014)

---

raulggonzalez (1/17/2014)

---

Connection settings are the default, I tried from my 2012 SSMS and using 2008R2 SSMS in a remote desktop, (default connection settings) and both return values...

raulggonzalez (1/17/2014)

---

Connection settings are the default, I tried from my 2012 SSMS and using 2008R2 SSMS in a remote desktop, (default connection settings) and both return values for offline databases.

Well,...

raulggonzalez (1/17/2014)

---

Thomas Abraham (1/17/2014)

---

raulggonzalez (1/17/2014)

---

Thanks for the question, but I have to disagree with one of the answers.

I have a number of offline databases in one of my servers and...

Nice easy question, but the explanation does not mention that you will get a NULL value if you can't find the database name provided for any reason. This includes...

Great question. So interesting how almost half the people that answered got it wrong.

I got one word for you:

Chocolatey

seriously Google it

Great Question for a Monday. I do have to say that I had to research if Open Tran count was part of any version of sys.dm_exec_sessions contained Tran count...

Jeff Moden (1/9/2011)

---

...

Jeff - Great article. I never liked STR() in any language. Hope that it just gets deprecated since there are many better ways to do what it does.

I would...

Just another instance of Google being the worst combination of Creepy Uncle and Big Brother possible.

Should be expected considering who and what they are really about.

http://www.usatoday.com/story/tech/2013/11/18/google-reaches-privacy-settlement-with-states/3628593/

patrickmcginnis59 10839 (12/10/2013)

---

PHYData DBA (12/10/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its not the language,...

Steph Locke (12/10/2013)

---

Here's my non-technical view of RBAR vs Set

Each process/request requires sending a request to the software/hardware/person which then has to understand the request, convert it into their understanding,...

Chris Harshman (12/10/2013)

---

PHYData DBA (12/9/2013)

---

Jeff Moden (12/9/2013)

---

Consider a daily data file import, 60k rows. The data is loaded, of course, row by agonizing row, into a temp table. The mighty...

patrickmcginnis59 10839 (12/9/2013)

---

Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its not the language, then cursors should be...

peter-757102 (12/9/2013)

---

The whole deal with all this is to simplify resource management and improve concurrency to make things scale up nicely. To get those results it helps to think of...