Viewing 15 posts - 13,456 through 13,470 (of 14,953 total)
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...
June 6, 2008 at 9:12 am
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...
June 6, 2008 at 9:09 am
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.
June 6, 2008 at 9:05 am
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...
June 6, 2008 at 9:00 am
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...
June 6, 2008 at 8:52 am
Have you tried dropping and re-creating them? (With Check, of course.)
June 6, 2008 at 8:43 am
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.)
June 6, 2008 at 8:40 am
Brad (6/6/2008)
June 6, 2008 at 8:35 am
Tao Klerks (6/6/2008)
The asssumption that you can...
June 6, 2008 at 7:50 am
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...
June 6, 2008 at 7:46 am
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...
June 5, 2008 at 3:41 pm
This is a duplicate thread. There are answers on the other copy (same forum).
June 5, 2008 at 3:36 pm
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...
June 5, 2008 at 3:34 pm
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...
June 5, 2008 at 3:23 pm
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.)
June 5, 2008 at 3:14 pm
Viewing 15 posts - 13,456 through 13,470 (of 14,953 total)