In my industry now, there is a much different emphasis. If you forget your badge in most places, you are denied entry, period. Entry requires the badge and...

Koen Verbeeck (9/22/2013)

---

Jan Van der Eecken (9/20/2013)

---

I don't think I'm the lone non-US citizen who doesn't quite understand what the Filibuster is all about. The way...

andrew gothard (9/19/2013)

---

Stefan Krzywicki (9/18/2013)

---

GilaMonster (9/18/2013)

---

If you mean the SELECT * INTO, unfortunately that's...

I might point out that your desired output is ambiguous. you have a 111/Blue group twice in your suggested output. What are your criteria for having 2 in...

In order to bridge the gap between Mr. Hugo's excellent comments and other comments about multiple columns, I've seen systems that used a type specific column in their normalized settings...

I wonder, Could you add a section to do something similar with an XML output? Standard in 2008 SSMS and 2012 SSMS is 2 MB of output text in...

The Dixie Flatline (6/14/2013)

---

Brandie Tarvin (6/14/2013)

---

jcrawf02 (6/14/2013)

---

SQLRNNR (6/13/2013)

---

Chad Crawford (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

I will explain...

No, to explain will take too long. I will sum up.

The Doctor is...

suneet.mlvy (5/30/2013)

---

Hi,

I m try to delete some old data to speed up select statement but it takes too much time to delete.

delete from Table_name

where CAST( ReportTime as date)...

eamasalunga (5/20/2013)

---

Hi all,

I've recently encountered this error again today after server restart and I was able to fix it.

What I did was open/modify the message queue and execute the ALTER...

Brandie Tarvin (5/10/2013)

---

I don't think you have a choice in the matter. The problem probably isn't within...

TaylorMade (4/18/2013)

---

I don't dispute the answer, but I don't completely agree, or understand the explanation;

"The total rows count will be 1*2*3=6! The summary of id3 will be 2*1+2*2+2*3=12! "

Yes, the...

QotD's are assumed to be applicable to SQL Server versions still under general support (2008,...

L' Eomot Inversé (4/15/2013)

---

Trick questions are a part of life. If there are too many we could try shooting the people who write them if both (a) we have...

The cursor can easily be replaced by a filtered select statement that includes an output clause into another temp table, which is then used to update the "seen" field. ...

May I be the first to point to BOL for Non-Deterministic?

http://msdn.microsoft.com/en-us/library/ms187928(v=sql.100).aspx

Take a look at the Remarks section. There is a table with superscript "1"'s in it... All of the...