roger.plowman (8/23/2016)

---

ANSI_WARNINGS are basically concerned with Null values (ignoring the divide by 0 issue which is really a seperate one). I believe the better solution is never allowing Nulls in...

That is because it's in the standard:

SQL-92 section 20.2 <direct select statement: multiple rows> General Rule...

It's new in 2014SP2 -- and not in 2016 (yet).

Ed Wagner (8/15/2016)

---

Nice article, David. Like Jeff pointed out, if people have an irrational fear of xp_cmdshell, what are they going to think about Bash? I don't have...

Sergiy (8/14/2016)

---

There are other aspects which were not mentioned by anyone.

1. The same small query populating a temp table may be reused in several procedures.

In such case its plan will...

Stan Kulp-439977 (8/12/2016)

---

One trick I use is to write stored procedures using temporary tables, then when the stored procedure is finished and working go back through it and turn the...

TomThomson (8/4/2016)

---

Steve Jones - SSC Editor (8/4/2016)

---

You...

david.gugg (7/25/2016)

---

I think this kind of makes sense if you come at it from the Oracle perspective. In Oracle, to select values you have to go against the SYS.DUAL...

Jeff Moden (7/20/2016)

---

Agreed. There's not a "good" official MS reference that explicitly states how such compound operators work with respect to the right-hand expression but... if you make the...

And 0 would rank...

In parameter declaration, @parameter type = defaultvalue, the part after the equals sign is a default, not an assigned, value.

In T-SQL, parameter default values must be...

Carlo Romagnano (6/30/2016)

---

The second option is useless, but it also is correct.

SELECT @p = N'@m varchar(200)="event message", @d datetime=getdate(), @U varchar(10)="Steve" '

I.e. this code returns 1 despite @p...

prathmanu (6/28/2016)

---

Great Post for the starters.I am a newbie in SSIS and BIML ,this post explain how to implement incremental load for single table. But is there any logic in...

D'oh! Need to think before I answer.

OF COURSE it does a full scan. SQL Server already has to do a full scan to rebuild the index. Since that's the expensive...

The given answer doesn't match up with the reference material. The question reads:

From the linked reference:

Stretch Database bills Compute...