It executes the preceding batch 8 times, as if you had highlighted it in SSMS and hit Execute eight times.

I'm not sure...

GilaMonster (8/13/2009)

---

Paul White (8/13/2009)

---

No that...

No that is not correct:...

Jeff,

Probably 1118: see http://blogs.msdn.com/psssql/archive/2008/12/17/sql-server-2005-and-2008-trace-flag-1118-t1118-usage.aspx and http://support.microsoft.com/kb/328551. Not everyone knows that it can be used with SQL2K as well.

Paul

edit: Gail's reply wasn't there when I started writing this post! ...

http://technet.microsoft.com/en-us/library/cc966413.aspx

Thanks Lynn! All these years I have used OUTPUT to send rows to a 'real' tbale or a table variable,...

Gail,

I was simply referring to your statement that "Without stats, it estimates 1 row". It is commonly held that SQL Server always estimates one row for table variables -...

Jeff Moden (8/10/2009)

---

In Lowell's example, it also turned a 13 byte string into a 20 byte Varbinary so it's expensive, too. But, I believe that Barry's point was simply...

GilaMonster (8/10/2009)

---

They usually do and the reason is statistics. Temp tables can have column statistics, table variables cannot. The optimiser uses statistics to estimate the number of rows that various...

Lynn Pettis (8/10/2009)

---

So, are you volunteering to be part of a forced peer review group for articles? Then, the more important question, how long will stay with it if...

GilaMonster (8/10/2009)

---

And none of them good I suspect 😛

GSquared (8/10/2009)

---

Have to sort of disagree with you on this one. Temp tables cause statement recompiles in 2005/8, and proc recompiles in 2000, but even those are often/usually better...

TheSQLGuru (8/10/2009)

---

Well, I think (hope) I prefaced my initial stomp on UDFs with that "ancillary data access" statement as the real bugaboo. Perhaps I missed it.

Paul, you bring up...

Hey Barry,

On the other hand, it is relatively slow, only works on strings, and returns varbinary(8000).

If the task is to detect changes in...

GSquared (8/10/2009)

---

gregory.anderson (8/10/2009)

---

Here's a question about one of the items. You mentioned that writing "master.dbo.proc_name" is better than just "proc_name", well, what about writing "master..proc_name"? My company does...