Viewing 15 posts - 7,591 through 7,605 (of 49,571 total)
The problem is that SQL 2000 has been out of support for years and there's a fair number of database consultants who won't work on SQL 2000 databases any longer,...
October 7, 2014 at 11:52 am
Sean Lange (10/7/2014)
The upside is the end of the list should be approaching fast. 😀
He's up to 2007. 🙁
October 7, 2014 at 11:47 am
ramana3327 (10/7/2014)
It is giving that the path doesn't exist msg.
You've double-checked that there are no spelling mistakes in the script, the server you're running the trace against has a local...
October 7, 2014 at 8:11 am
er.mayankshukla (10/7/2014)
I had this doubt that why CTE should begin with semicolon or Go.
It shouldn't.
If the CTE is not the first statement in the batch, then the previous statement needs...
October 7, 2014 at 7:54 am
Alan.B (10/6/2014)
So it is whatever the default is - is what it is set at. I will tell you exactly tomorrow.
Which means it'll be cost threshold of 5 and maxdop...
October 7, 2014 at 2:26 am
Koen Verbeeck (10/7/2014)
SQL Server will just use implicit conversions everywhere, which may impact execution plans and the use of indexes.
However, since the column will be going to varchar, the implicit...
October 7, 2014 at 2:23 am
Or, if they're different traces, rather than rollover files, by using INSERT INTO instead of SELECT ... INTO
October 6, 2014 at 1:38 pm
What do you mean by 'unable'?
October 6, 2014 at 9:18 am
Actual plan please, not estimated. The text plans are near useless because they're missing everything except the operator. Plus they're a pain to read.
October 6, 2014 at 9:06 am
Text plan? You have a SQL 2000 server here?
October 6, 2014 at 7:21 am
why don't small indexes (especially PKs) get the same treatment?
In short, because there's no point in doing so.
There's no reason to rebuild small indexes. They won't benefit and the queries...
October 6, 2014 at 7:05 am
HanShi (10/6/2014)
October 6, 2014 at 6:56 am
Copy the file to machine B, then use the SQL function fn_trace_gettable
October 6, 2014 at 6:48 am
Index definitions and execution plan please.
October 6, 2014 at 6:05 am
Viewing 15 posts - 7,591 through 7,605 (of 49,571 total)