The rule of thumb I use is, if the field is 10 or less characters wide, I use char, for anything bigger, if it will vary in width, I use...

If I'm not mistaken, duration in Profiler is total duration, not per-run duration. (I could be thinking of something else though. My brain is taking a long time...

I don't believe it's possible to uninstall it. If you could, you'd never be able to connect that server to anything else.

I prefer to store Zip codes, SSNs, phone numbers, et al, as text, and without the formatting (no dashes, etc.).

Slightly narrower columns, for one thing. (Over millions of Zip...

I generally use SSIS packages to move data into and out of text files. But my uses for text files generally require that the data be moved into SQL...

Have you tried dropping and re-creating them? (With Check, of course.)

To crush your enemies, to see them driven before you, and to hear the lamentations of their women.

(Sorry, couldn't resist. Playing Age of Conan too much.)

Brad (6/6/2008)

---

Good question, but the answer leaves me a bitter. I assumed Stored Procedures were in use with proper parameter types. (which is what I use). So...

Tao Klerks (6/6/2008)

---

Hmm, I guess I knew where the author was going and got the answer right, but I disagree with the premise of the question.

The asssumption that you can...

Just for some history on this, a major worm recently went around the net using exactly this kind of exploit. Instead of a simple select command, it installed a...

I've found, in my experience with Try/Catch on dynamic SQL, that you either need to have the Try/Catch in the dynamic SQL statement, or you need to modify your code...

This is a duplicate thread. There are answers on the other copy (same forum).

Try this, see if it doesn't speed up the query a bit:

;with

CTE_CreateTime (ConID, Created) as

(select conid, max(createddatetime)

from Ex

group by conid),

CTE_SID (ConID, Created, [SID]) as

(select ex.conid, ex.createddatetime, max([sid])

from Ex

inner join...

Do you already have an installation of SQL 2000 (database engine, not just tools) on that machine? I could be misreading the error, but it looks to me like...

Are you running these maintenance tasks as jobs in SQL Agent?

If so, you can right-click a job and check its history. (Or query it from msdb, I believe.)