Viewing 15 posts - 1 through 15 (of 26 total)
thanks, probably the best working code dealing with the subject. I replaced the datetime with time(0), just easier on my eyes:
CAST(STUFF(STUFF(REPLACE(STR(run_time, 6), ' ', '0'), 3, 0, ':'), 6, 0,...
March 25, 2012 at 7:38 am
Thank you for posting this, very elegant solution. Too many DBA's are not aware of problems with sysdepends and consequently don't know how to get reliable information about their system.
September 10, 2007 at 7:28 am
just a note about something that may be confusing. the article talkes about linking an ADT to a column - this is not a correct concept. ADT just like "standard"...
September 3, 2007 at 7:16 am
It's a wonderful Idea to do something about the general level of expertise in the DBA world. It's a bit of a problem, because it is one of the...
November 30, 2006 at 9:12 am
This is true, I did not think that this solution was portrayed as "the only one". just that the performance concern is pretty big, and osql option is just as...
September 27, 2006 at 12:52 pm
while it may seem like a nice idea to run a multi instance task right from your Query Analyzer, I wouldn't do it. First of all performance is bound to...
September 27, 2006 at 7:40 am
almost forgot, if already using osql, why involve DTS in the picture? wouldn' it be just as easy to run your query using OSQL and use the output of that...
August 30, 2006 at 2:31 pm
One thing I don't get is how the transaction log backup devices are reinialized. It just seems that log backups would get appended w/o an end. am I missing something?
August 30, 2006 at 2:28 pm
normally I'd agree with you, but fact is that this log is growing, and you can guess what is going on there, but if you really want to know take...
August 9, 2006 at 10:43 am
see what SQLBill wrote about this (above). It seems to me that the best thing (and that's what I wound up doing)...
August 9, 2006 at 9:39 am
Wayne, did you find a solution ? If so, please post it. I seem to be having the same issue.
July 5, 2006 at 3:30 pm
Yes to regional settings
no to nulls
June 9, 2006 at 3:48 pm
I am not sure how collation would be relevant since we are talking about a datetime field, but yes, both servers are SQL 2000 and both DBs are of the...
June 8, 2006 at 10:46 am
I feel a bit not so smart, but even though I looked through it million times, I missed it. sp_text was defined as nvarchar. Now that I changed it to...
March 30, 2006 at 7:34 am
Thank you so much,
eithere set @var='' or set concut_null_yields_null off produces desired results without coalesce. Which makes me wonder what it was doing there in the first place...
Anyhow, thank again....
March 29, 2006 at 1:05 pm