Viewing 15 posts - 18,391 through 18,405 (of 26,489 total)
Francis Yee-483501 (11/13/2009)
" SELECT rows FROM sysindexes WHERE...
November 13, 2009 at 9:47 am
GDI Lord (11/13/2009)
Lynn Pettis (11/12/2009)
November 13, 2009 at 6:44 am
GilaMonster (11/13/2009)
November 13, 2009 at 6:42 am
Any way you do it it has to be logged, there is no way to turn it off. The best thing you can do is to perform the insert...
November 12, 2009 at 9:35 pm
No idea. It is your data, you have decide if the data can be modified or not. If not, then you will have to go with a larger...
November 12, 2009 at 3:51 pm
Here is the problem, you are going from this:
123456789.01
to this:
12345.678901
Unless you are absolutely sure that no values in this column is greater than 99999.99, then what you may need to...
November 12, 2009 at 2:59 pm
Try changing it to DECIMAL(15,6) instead of DECIMAL(11,6).
November 12, 2009 at 2:24 pm
Double post, please reply here.
November 12, 2009 at 2:19 pm
Jeff uses it when creating his million row test tables.
November 12, 2009 at 2:15 pm
Please show your code. A little hard to help when we can't see what you've done.
November 12, 2009 at 1:20 pm
Alvin Ramard (11/12/2009)
CirquedeSQLeil (11/12/2009)
Alvin Ramard (11/12/2009)
CirquedeSQLeil (11/12/2009)
amazing how the thread can make a day go from bad to better. At least one good laugh a day.
At first I thought...
November 12, 2009 at 1:19 pm
I wouldn't. Seems like a general observation that I would actually agree with. 😉
November 12, 2009 at 12:42 pm
Two things.
First, based on the data provided, what is the expected output from the update?
Second, could you please show us what you have done so far to solve your problem?
November 12, 2009 at 11:24 am
jcrawf02 (11/12/2009)
And try changing
WHERE tableA.date BETWEEN @start AND @stopto:
WHERE tableA.date =< @stop AND tableA.date >= @startlooks more cumbersome, but performs better.
Funny, but when I compare the execution plan of...
November 12, 2009 at 11:13 am
Viewing 15 posts - 18,391 through 18,405 (of 26,489 total)