tfifield (6/21/2011)

---

My 2 cents. I find it easier to read column aliases with AS - i.e. Column1 AS NewColumnName. However, for some reason, I find table aliases easier...

Are you asking for what the different clauses of the query do? As in "What does SELECT do? And what does FROM do?"

If so, then your best bet...

I prefer Select Into, because in performance tests I've done it's slightly faster, and because it will preserve DDL changes in the source Select between iterations.

E.g.: If you have to...

CREATE TABLE #T (Col1 INT, Col2 INT) ;

INSERT INTO #T

(Col1, Col2)

VALUES (123, 888),

...

Brandie Tarvin (6/21/2011)

---

Is that the part where I make something up and hope it fits with the rest of the data?

@=)

...

Loner (7/11/2008)

---

There are two rooms separating by a wall, one room has three lamps, the one one has three switches, can you tell how to find out which switch is...

Only reply I can give is "read your own statement". Read it as if someone else wrote it, without any internal thoughts that weren't in the words. I'm...

Craig Farrell (6/20/2011)

---

[rant]

AAARRRGGGHHH....

One more person, just one more, who applies for an SSIS position (it's specifically advertised as an SSIS position) who's done nothing more than use it as a...

Jeff Moden (6/21/2011)

---

GSquared (6/21/2011)

---

The fact that xp_CmdShell has been enabled means that any attack vector that bypasses your stored procedure [font="Arial Black"]under an elevated rights situation [/font]has essentially been granted...

Phil Parkin (6/21/2011)

---

No, I read your message correctly. What I disagree with is "...consider doing yourself a favor and omit the readability word...". Yes, it's only in there to make...

Jeff Moden (6/20/2011)

---

GSquared (6/20/2011)

---

How does that compare with xp_CmdShell being run under elevated rights? It's not the same ballpark. It's not the same league. It's not even...

You can get the script for it from Profiler. It'll use sp_trace_create, sp_trace_setevent, and so on. Create the trace in Profiler, then stop it and get the script...

Sure did. Kids, the lesson here is don't post when suffering major sleep deprivation.

Here you go.

DECLARE

@sql VARCHAR(MAX),

@Text VARCHAR(MAX),

...

KerberosLLC (6/21/2011)

---

Understood, provided your UAT environment matches production. It's the only way to do valid UAT testing.

Also, for the...

Mike, on your point about specialization vs Swiss-army-knife devs, yes, more companies would benefit from specialization than are aware of it.

If you turned that post into an editorial, and sent...