Well I tried 😀

Jeff Moden (11/16/2009)

---

All good points (have you got an MS URL that I could read up on or is that info in BOL?). The result is... MAX is a...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\Languages\Language Services\SQL

CodeSense = 0

Jeff Moden (11/15/2009)

---

The second "optimization" isn't really an optimization... it's a realization of how much the use of VARCHAR(MAX) sucks the life out of code. My speculation on that...

You haven't really given us much information to work with, so I'll guess:

In broad terms, SQL Server stores a query plan for the whole stored procedure. That plan will...

You were right! My fear was that the screenshot wouldn't show the path column (or the important bit):

ALTER DATABASE <db_name> SET NEW_BROKER WITH ROLLBACK IMMEDIATE

...will roll back any transactions which prevent the command from completing immediately. In this case, it would also break the connection since...

Alternatively:

Just before you click 'OK' to create the database from the New Database screen, click on the Script button at the top.

That will create a script. Copy and paste...

My approach to DIY, in a...

Ouch. That's a dreadful pun, even if unintentional!

A schema-level CREATE ASSERTION would be extremely useful. I'd probably place that higher up the list than any of the new running-total-type ideas presented (including LAG/LEAD). Failing that,...

Ha. Sure does!

One of the things I like about working with computers is that there is always...

We all love a happy ending. Well done Steve!

SELECT t

FROM @t

WHERE NOT EXISTS

(

SELECT *

FROM @t1

WHERE t IN (r,c)

...

sqlservercentralitgeekry (11/14/2009)

---

Hugo's method depends on unique, consecutive integers, and it will fail in the event that an implementation uses a non-unique order by clause. ROW_NUMBER() solves this problem with...