Viewing 15 posts - 1 through 15 (of 42 total)
Thanks for heads up. I've downloaded it, give it a test-drive tomorrow on a sandbox.
January 11, 2021 at 11:57 pm
free_mascot (6/17/2014)
Check the permission for linked server for specific login which you are using to access data.Are you able to execute any other command for that linked server?
When you...
June 17, 2014 at 10:57 am
SQLRNNR (3/27/2014)
That...
March 27, 2014 at 10:48 am
My superior asked me to do this. There is a slight gain in IO performance I guess, and we are trying to squeeze completely everything out of it. It's not...
March 26, 2014 at 4:31 pm
Alright, so I rebuilt the heaps as well, and it's still not very proportionate. Here is an example:
Database 4.5GB
Add 7 additional files of 583MB
After File Addition:
Primary: 97% full
Secondary 7: 1%...
March 26, 2014 at 4:20 pm
So I tried it that way, stuck the command into a cursor, looped through all the user indexes, and it didn't seem to work. Maybe 8% of data was moved...
March 26, 2014 at 2:44 pm
So, basically, add the files, run DBCC DBREINDEX for all indexes, and that's it?
March 26, 2014 at 12:51 pm
The problem with that might be that I won't be able to set the original file smaller than it has the data on there right now. The only way to...
March 26, 2014 at 12:05 pm
Could you please elaborate a little more on how that would work?
March 26, 2014 at 10:57 am
This is not the only database on the server, which is what's weird to me. Mirror failover threshold is set to 10 seconds for all databases, so we know that...
March 17, 2014 at 12:13 pm
The message was "The mirroring connection to "TCP://servername.domain:port" has timed out for database after 10 seconds without response.
March 17, 2014 at 11:55 am
Actually, I figured out how to get around this. The script below tells me all the active jobs that are running.
SELECT j.name, DATEDIFF(second,ja.start_execution_date,GETDATE()) exection_time_seconds FROM msdb..sysjobactivity ja (NOLOCK)
JOIN msdb..sysjobs j...
January 31, 2014 at 1:11 pm
I sorta figured that out on my own. The only thing I'm having issues with figuring out is how to capture correct job id in order to pass the error...
January 17, 2014 at 10:09 am
You are absolutely right, I forgot to mention that I had to enable Mail Notification in SQL Agent Alert properties. Any way of getting around restarting Agent, or is that...
January 13, 2014 at 4:06 pm
Viewing 15 posts - 1 through 15 (of 42 total)