A toasty -19F, here in LaCrosse, Wisconsin, this morning.

If an XML Primary Index and an XML Secondary Index have different index structures (see Qo

D from July 22) doesn't that imply that they are separate index types?

LaCrosse, Wisconsin... on Wisconsin's West Coast

I had something very similar to this. After upgrading an instance from SQL 2K to 2K5, I tried to change the startup accounts. After 2 reboots of the...

JohnG -

If you cast the -1 to Decimal(38,19), you won't get the error on 123.45

Great question.

Check out this link: http://www.simple-talk.com/sql/performance/execution-plan-basics/

It talks about the output of the Parser being passed to the Algebrizer.

see the "Remarks" section under the "TOP (Transact-SQL)" heading in BOL.

The category of the question was "SQL Server 2005"

D is not completely correct, either.  If I/O is not the problem, changing the parm may help, but the server might already be doing the best that it can.

I don't think that there is a totally correct answer to choose from.  According to BOL, increasing the value of the option might help in certain situations.

"The index create memory...

Check out the section entitled "Starting and Stopping Services" in BOL

From BOL - Server Enhancements (SSAS)

Multi-Instance Support

Up to 50 instances of the Analysis Services service from Microsoft SQL Server 2005 Enterprise Edition can be installed on one...

Doesn't it depend on which edition of SQL 2005 that you are using?

The question says that you want to "ensure" that point in time will work.  With bulk-logged, you can't "ensure" that it will work, because of the caveat.

"As you get older, work becomes more fun and fun becomes more work."

From my friend Paul....

"You can't drink all day if you don't start in the morning."

... and my favorite...