Viewing 5 posts - 916 through 920 (of 920 total)
quote:
Sorry for butting in!If you are dealing with last value on IDENTITY columns I would suggest using:
IDENT_CURRENT( <table_name> )
According to my book...
September 18, 2003 at 6:45 am
quote:
The values are just the number of the day of an year. I have got year in one column, and just...
September 18, 2003 at 6:23 am
Yes, I've seen this sort of thing before. If you can't find some trick to make the SP find a different plan (just for fun, try WHERE WS.strProj =...
September 3, 2003 at 9:31 pm
Try a MAXDOP 1 query hint. Or increase the cost threshold for parallelism. The query analyzer sees the SP execution time, but not that of the raw query,...
September 2, 2003 at 1:49 pm
Replace(objTable.Script, "CREATE TABLE [", "CREATE TABLE [" & objTable.Owner & "].[")
--Jonathan
September 2, 2003 at 12:58 pm
Viewing 5 posts - 916 through 920 (of 920 total)