DesNorton (10/24/2016)

---

I should have been more clear. You pass NULL, NULL as your text filters, and pass in the start-date as a filter. This eliminates the necessity to...

DesNorton (3/6/2016)

---

You could also pass the filter directly to xp_readerrorlog.

See this post ... http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/%5B/quote%5D

While generally a good idea, that would defeat the point of this script. When...

The title and much of this commentary is very misleading, in that this has nothing to do with small numbers, and is not limited to .5 <= x < 1....

Rich Mechaber (1/28/2016)

---

I'm sorry, I must be very dull today, but I don't understand how any rows are inserted by the INSERT statements when the primary key is an IDENTITY(1,1),...

For anybody having trouble following the joins, just focus on the Authors in the individual joins.

First #A has 4 authors: ('Job', 'Job', 'Jim', NULL)

The subquery takes this...

Good question, but I agree the explanation is a little fuzzy.

Just to reiterate:

Although it's never said, the question kindof implies that the transaction behaves differently in...

For those looking for more of an explanation:

While poorly framed, it appears the intent of the question is to determine which queries will perform a SEEK versus a...

raulggonzalez (10/29/2014)

[text()] is a misleading alias in this case... Note that is wrapped with [square brackets]

just run

SELECT

DepartmentName + ';' AS...

begulley (8/25/2014)

---

When looking for a range, is this according to the ascii table? For example:

where FixSubject like '%[' + Char(1) + '-' + Char(11) + ']%'

Does this find...

Thanks for the article! One clarification:

Also notice that “Ça va” is missing. If the column is case sensitive, should that not have been captured? Again this...