Viewing 15 posts - 46 through 60 (of 153 total)
GilaMonster (9/10/2014)
From the looks of that code, it should take single-row locks on the two tables (locking the inserted rows) and hold them until the end...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 10, 2014 at 8:43 pm
robert rogers-466427 (9/8/2014)
I need your opinion. I just start a new job and most the Sql Server environments only have 3 San drives.
Being that I only have...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 8, 2014 at 10:04 pm
Sri8143 (8/11/2014)
There are multiple temp tables with different suffix in the tempdb which i cant drop or delete it as it is from a different session which is not active...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 11, 2014 at 8:26 pm
Tara-1044200 (8/11/2014)
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 11, 2014 at 8:22 pm
Mike Aguilar (8/11/2014)
But when I schedule it in an SSIS job I get "The specified @job_name ('Main_Job') does...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 11, 2014 at 8:16 pm
Silverfox (7/22/2014)
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
July 24, 2014 at 1:30 am
Welsh Corgi (6/19/2014)
I performed a rebuild of Indexes on all tables in a Database.
The Database grew in size from 406 GB to .9 TB.
I shank...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 23, 2014 at 6:14 pm
homebrew01 (6/17/2014)
Fill-factor values 0 and...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 18, 2014 at 1:39 pm
I will add my comment too.
"No"
We perform shrinks all the time and stop them half way no issues. (The other side is it's not good to perform shrinks...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 17, 2014 at 4:46 pm
Hi Although I might not help with answers, I do have more questions 🙂
Rebuilt Indexes and it caused excessive Growth.
The Database went from 389 GB to 690 GB.
So for...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 17, 2014 at 4:29 pm
Hi I saw your post and wondering have you resolved it and what was your resolution?
If you have not have you checked trying to re install system drivers?
More specifically...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
April 16, 2014 at 4:33 pm
GilaMonster (4/16/2014)
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
April 16, 2014 at 4:26 pm
GilaMonster (4/16/2014)
Maxdop query hint overrides the server Maxdop setting.
If resource governor is enabled and a Maxdop is set via resource governor, then that is the max value allowed. A...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
April 16, 2014 at 3:21 pm
I do a lot of restores in my Dev and QA environments. They both have a wealth of little connection greedy web services running against them so I had...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
December 4, 2013 at 11:22 am
Jeff Moden (11/30/2013)
Set it to "single user" then immediately to "multi-user" and then immediately execute the restore command. Of course, these 3 things should be in a script.
Good one...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
December 1, 2013 at 5:47 pm
Viewing 15 posts - 46 through 60 (of 153 total)