It's because CONCAT converts NULLs to empty strings prior to concatenation; that's its difference/advantage to ordinary concatenation with +.

In the first case, when region is null, it's converted to an...

So, the trick is that in the innermost quoted command, the EXEC sp_helptext, you want single quotes around schema.object. Since it's inside a string, each of those single quotes will...

Understood. I was looking more for the full BackupTypeDescription, particularly to see if it was "File or Filegroup". The Type column in RESTORE FILELISTONLY is the type of file each...

Yeah, that means that the file(s) with IsPresent=0 can't be restored from that backup. Only time I've seen that is when you do a backup and specify particular files or...

Hugo Kornelis (2/10/2016)

---

The comments on the Register site show an incredible lack of understanding of SQL and its internals. But hey, this is the internet, you don't need to udnerstand...

Also of note, this seems to be the exact same problem that has been worked on in another thread, starting here: http://www.sqlservercentral.com/Forums/Topic1759368-3412-2.aspx#bm1759448

Cheers!

Is the version of SSMS you're using older than the instance you're connected to?

I know people have run into this issue a few times. In that case, configuring it...

CASE is an expression; it evaluates to some value or another. It is not a control-of-flow statement.

For what you're wanting you should use IF to determine what DELETE statement to...

I haven't worked with full text search much, but as I recall it doesn't support that sort of suffix search. It supports a prefix search, like you're already doing, but...

To back up what Orlando said, here are some performance metrics from my machine using the test harness from above (just modified to have datetimes today, and with the procedures...

Yeah, the VARBINARY with default length of 1 threw me off for a moment, since I expected some tricky "None of the above" answer. After seeing the answers, though, it...

While it's quite cool that there are CASTs that still allow seeks, in this case you would still want to look into avoiding the CAST.

As discussed at http://dba.stackexchange.com/questions/34047/cast-to-date-is-sargable-but-is-it-a-good-idea, there are...

When I run the WITH ROLLUP version of my query (the one Luis posted) against your sample data with those dates, I get the following:

| PayRate | Name |...

That just means...

[off-topic-rant]

On that note, SQL Fiddle has been having some...