I've never met a computer yet that had any sort of judgement or wisdom, but we do keep trusting more and more decisions to them.

This has good and bad aspects...

Jan Van der Eecken (11/8/2011)

---

GSquared (11/8/2011)

---

Roy Ernest (11/8/2011)

---

Hey everyone, I am hijacking the thread with an "Off Topic"

I am planning on a presentation for my user group "DBA MythBusters" (Courtesy...

I grew up...

Roy Ernest (11/8/2011)

---

Hey everyone, I am hijacking the thread with an "Off Topic"

I am planning on a presentation for my user group "DBA MythBusters" (Courtesy Paul Randal) His idea is...

L' Eomot Inversé (11/7/2011)

---

Gianluca Sartori (11/7/2011)

---

Totally different topic: this thread asks how to format datetime values in T-SQL.

I think this is a very bad habit to kick and I...

PaulB-TheOneAndOnly (11/5/2011)

---

Most probably something...

Compare the execution plans for the Cross Apply and the join to a list of months.

You guys do realize that selecting into a table variable, and then running a cursor on the table variable, is pretty much what a Static cursor does all by itself,...

Are you setting identity_insert in the same session as the insert statement? That's the scope it's got.

Actually, I have seen cases where simple looking queries would run for days at a time.

Heck, I had a rollback command once that took over a week to finish. ...

The values that aren't in the table, like ProcessID, where do they come from? Or are those static?

Other than that, it looks like:

select *

from dbo.ArrayOfStudentMoveSummary

for XML path('StudentMoveSummary'), type

That would...

Build a table with constants in it.

Move it to a read-only filegroup, so that it avoids locks/blocks/et al, in terms of contention.

Select from it when you need to use a...

Revenant (11/4/2011)

---

GSquared (11/4/2011)

---

. . . Nothing wrong with building your own .NET solutions, but frequent breaks in an SSIS package should be cause for re-examination of how the package...

The problem isn't the concatenation. It's the use of "RETURN".

The Return operator can only return an integer value. It's supposed to be an error code or similar item.

That's...

8-bit cactus