Viewing 15 posts - 52,696 through 52,710 (of 59,070 total)
However, the engine has no obligation to scan the table in index order, as there are no language constructs which impose an ordering on the execution order of a scan....
January 31, 2008 at 9:11 pm
Ian Yates (1/31/2008)
January 31, 2008 at 8:47 pm
ALZDBA (1/31/2008)
There may be some testing needed regarding parallelism,
maybe for now just add a OPTION(MAXDOP 1).
The only remarks I would add to the conclusion...
January 31, 2008 at 8:35 pm
Christian Buettner (1/31/2008)
very interesting article.
Somehow it throws all my beliefs into the trash bin:
1. The update method with variables is not explicitly supported by Microsoft
2. The clustered...
January 31, 2008 at 8:28 pm
According to a recent radio ad by one of the better known railways, freight trains use only 1 gallon of fuel to haul 1 ton (2,000 pounds) 443 miles... we...
January 30, 2008 at 10:48 pm
Yep... thanks for the feedback. I've seen that, too. But only on SELECTs... and only on non-clustered indexes. I've never seen it fail on UPDATEs on CLUSTERED...
January 30, 2008 at 10:41 pm
Heh... don't forget about DBCC SHOWCONTIG WITH TABLERESULTS
January 30, 2008 at 3:58 pm
Didn't you read any of the above? Don't use ISQL... use OSQL or SQLCMD depending on which version of SQL you have.
January 30, 2008 at 6:08 am
bonk (1/29/2008)
I agree with you! But there's nothing to do in this case. I explain: the table with one column for each month already exists and I can't modify...
January 30, 2008 at 5:59 am
It's because ISQL is just a subset of what the server can actually do. Do NOT use ISQL. Use OSQL instead.
January 29, 2008 at 8:03 am
I agree with Matt... recursion is probably not the best way to do things like this...
There are variations on this theme but here's a nice little NON-recursive CTE that...
January 29, 2008 at 7:59 am
It that case... might be OSQL... THAT does have such a set of switches... if memory serves, "-h-1" (no spaces, no quotes) would be the switch you're looking for.
January 28, 2008 at 2:02 pm
I would like to know how can I read a record from a table with 12 columns (each on for each month in a year) end put the value for...
January 28, 2008 at 1:59 pm
Think "Library"... it's easier to find the books if they're all in order... it's just about that simple. There are tools for defragging disks and tools for defragging database...
January 28, 2008 at 1:52 pm
Would you carefully fill in the question marks to meet the Friday/Saturday rules on the following, please... again, not trying to be difficult... trying to get it right...
EmpID Date ...
January 28, 2008 at 7:02 am
Viewing 15 posts - 52,696 through 52,710 (of 59,070 total)