Good luck with the next step.  In a way, what you are doing is much like leaving the company.  You will be trained by, and you will train,  a new...

If you run SQLCMD via command line, you can set it to run as your user account (or the one you plan to make changes with). I believe the...

The only difference however between 2008 and 2012 is 2012 will produce the query in dynamic sql. Why Microsoft?!

Anyhow, I typically just delete the the dynamic markup, do a...

Like the other posters mentioned, it's not the hardware that is causing your problems (more than likely not at least), its the size of your user base vs the quality...

I'd recommend using the SSIS as a previous poster recommended, allowing you to run each SQL file individually.

I also recommend someone to stop pissing in Celko's cheerios. Damn that...

Hi Mike,

Using the same structure I left in my example, here's a snippet of my stored procedure below:

declare @parameters nvarchar(500) = N'@id int, @totalcount int output'

declare @sql_string nvarchar(max) = ''

declare...

Thanks. I thought about triggers but was concerned about the over head from the possible updates.

Didn't think about the option of a re-calculate flag.