CELKO (11/7/2012)

---

This is a silly question and you...

Kingston Dhasian (11/7/2012)

---

CELKO (11/6/2012)

---

Now we have to track down this interview so we can tell them that you cheat. I have gotten two students and one lecturer kicked out of...

If you want to generate a list of values from a column of values, like this, your best bet is to use For XML Path to do the work for...

Jeff Moden (11/6/2012)

---

GSquared (11/6/2012)

---

Lee Crain (11/6/2012)

---

Jeff Moden,

Please clarify this subject for me:

I'm almost certain that I read somewhere that a "SELECT .... INTO #Table" would automatically create the target table,...

Does your data take "leap seconds" and things like that into account? There have been several over the last 42 years. They don't matter to very many people,...

Lee Crain (11/6/2012)

---

Jeff Moden,

Please clarify this subject for me:

I'm almost certain that I read somewhere that a "SELECT .... INTO #Table" would automatically create the target table, then lock the...

Awsome. Glad I could help.

Not sure why you'd connecting triggers and cursors. They're completely different subjects.

But, here's a sample script that should do what you need:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

...

Performance-wise, Int will be better than BigInt, and BigInt will be better than UniqueIdentifier. Less storage, less RAM, less I/O, etc., with the smaller datatypes.

The reasons to use GUIDs...

The last time I used Light Speed was 7 years ago. I replaced it with Red Gate because I found it just generally superior and easier to use. ...

Try replacing this:

EXEC sp_executeSQL @sql, @Due

With:

EXEC sp_executeSQL @sql, N'@Due NVARCHAR(20)', @Due

See if that does what you need.

That's from the missing "list the parameters" piece that I mentioned. Look at the samples, you'll see how it goes.

No, a view is not "recompiled" every time it's called. A view is just a stored Select statement. Queries of a view will store their execution plans as...

I recently got a bunch of those, that were caused by a network issue in the connection to the SAN.

Yep.