I agree that you should go down the path you like and you will succeed. However, it depends on what you look for. If you look for just having a...

IMHO, if you use the company time to write the script then the script belongs to the company. But if the script has nothing to do with the company trade...

Great article about APPLY. Thanks

Hi Paul,

Thank you very much. Great idea!

I have not tried that yet but I will. Thanks

Thank you Jeff,

We use Enterprise version of SQL 2008.

Thank you Jeff for your response.

Sorry for misstating, in fact the server service runs under built-in local system account instead of local admin. My question is: Is there any way...

Jeff,

I love your script.

Thanks

Hai

I don't think that you have to switch to Simple mode. The part of the T-log that got truncated is the part that is committed regardless of whether the database...

Charley,

I don't think that switching to bulk-logged will solve your problem. We experienced similar situation, not as bad as your but close, we had the T-log grew to 100GIGs after...

Hello Jim,

From your suggestion I can tell that not only you have extensive experience dealing with databases but also with people. The windows for maintenance is quite wide, from 6:00PM...

IMHO the more freedom, the better for a developer to experiments his codes, his setup etc..

A developer needs to organize his/her work, keeps track of changes and structures documentation. ...

Hello,

I got the same error when I tried to deploy a tutorial SSAS project named Analysis services Tutorial. The error was: 'Either the user, Domain\userID does not have access...