I'll take it. Thanks.

Not sure. I was just appointed last night at our PASS meeting.

When the data at your company reflects on the bottom line and helps define your business, then it is the most critical in the world. When it means protecting...

We keep 2 weeks of full and logs. After that it has to be retrieved from tape. We have had frequent requirements to provide point in time proof...

VP (unexpected)

Just made me think of that brand and the commercials

Ho ho ho, Green Giant.

David Burrows (2/12/2010)

GSquared (2/12/2010)

I'm not sure that's the tag you wanted, Wayne.

Dictionary definition: physic noun: ...

Thanks for taking the time to create a QOD.

You have to build it dynamically. Can't remember the cause or the reference but that first use statement will get executed every time.

According to MSDN:

http://msdn.microsoft.com/en-us/library/ms187956.aspx

This is the 2008 article on creating views. It states that the select statement cannot contain the into keyword nor can it contain the option clause.

Please provide table structure. This will help isolate the cause of your fragmentation.

Also, knowing your process for performing the inserts would be helpful. The cause is likely a...

Fah (yeah)

mstjean (2/11/2010)

Whoops. Sorry, forgot to include the code I used to derive my d'oh. When I re-ran it, it still comes up d'oh.

CASE

...

You're welcome.

I would not update maintenance plans, that belong to a 2005 instance, from SSMS 2008. An upgrade to the maintenance plan may be attempted. Otherwise, I use SSMS...