Viewing 15 posts - 16 through 30 (of 36 total)
This question is as much as holy war as source code formatting 😀 But as long as you're happy with what you've done nobody is likely to complain.
1) When the...
August 6, 2015 at 7:40 pm
Thanks Andrew!
August 5, 2015 at 1:22 am
This sounded intriguing, I've never seen it before and didn't think it was possible. Recompilation of procedures is automatic, so why is it complaining?
I found two related articles because it...
August 3, 2015 at 10:27 pm
1) I need to regularly insert/update the data in the new database on SQL server 2014 from the old (SQL server 2000) until we fully transition to the new server...
July 30, 2015 at 9:38 pm
Out of curiosity, why do you have to restart the agent?
July 30, 2015 at 3:08 am
Best source of information: https://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx
You can delete data from the table, just not truncate it. You can add a column but it doesn't get CDC'd until you create...
July 30, 2015 at 2:58 am
1. It's fine. Though technically if you're only using it to come up with standards, you might set up a service account and give it just the permissions it requires...
July 30, 2015 at 2:40 am
Queues are per-database. msdb uses them for mail handling and so is a good first place to look.
Select * From msdb.sys.service_queues ssq
July 30, 2015 at 2:19 am
Don't delete rows in batches of 50,000. Anything >= 5,000 may exceed the default lock escalation threshold and take a table lock. And you don't need two temporary tables when...
June 16, 2015 at 8:32 pm
For this to happen you either would have gone to a lot of trouble to overwrite your master database with another copy from somewhere else, or someone changed the service...
June 15, 2015 at 11:07 pm
Recommend Olla Hallengren scripts, and modify his MaintenanceSolution to create the standard job and steps you require. To clarify, we modified it to have everything in one job and...
June 15, 2015 at 10:53 pm
Always set it. It's trivial to grab one of the formulas and just do it (and possibly go back and fine tune it later).
If you don't set it properly you'll...
May 24, 2015 at 9:44 pm
TheSQLGuru (3/18/2015)
1) DTA is crap for tuning. Do NOT EVER take it's recommendations for indexing and just slap them into your system.
One good thing that came from it for...
March 19, 2015 at 11:40 pm
Viewing 15 posts - 16 through 30 (of 36 total)