Viewing 15 posts - 2,131 through 2,145 (of 9,720 total)
ThomasRushton (11/24/2015)
Ed Wagner (11/23/2015)
Brandie Tarvin (11/23/2015)
I have the simplest error-handling method in the universe:Is there an error?
DROP DATABASE <problemDB>;
Done.
I like that. Perhaps a more individualized approach would be to...
November 24, 2015 at 6:18 am
My best advice is to suspend the mirror while doing the shrinks on the primary. There's nothing really you can do for the secondary. Unless you want to break the...
November 23, 2015 at 10:19 am
I have the simplest error-handling method in the universe:
Is there an error?
DROP DATABASE <problemDB>;
Done.
November 23, 2015 at 9:15 am
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?
It's not just you. Though, to be fair, Try...Catch probably caught...
November 23, 2015 at 9:05 am
Any shrink is going to fragment indexes. Your issue seems to be that you want to see results sooner rather than later. Also, mini-shrinks do work on larger databases without...
November 23, 2015 at 9:02 am
Sean Lange (11/23/2015)
Interesting....you posted your response to Luis's suggestion of outer apply just 21 minutes after his post yet you state it took 7 hours.
Good catch, Sean. I didn't even...
November 23, 2015 at 8:32 am
My best suggestion would be to use a Data Flow task to insert various items to evaluate the final row, then used Derived Column tasks to add the final blank...
November 23, 2015 at 8:30 am
I don't know that it will continue where it left off.
But did you verify that SQL Server Agent is set to restart automatically (at the Agent & service level) when...
November 23, 2015 at 8:27 am
Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering at the...
November 23, 2015 at 8:24 am
IP addresses have nothing to do with the drive the files are on and everything to do with the NICs in the servers / assigned to the servers.
That being said,...
November 23, 2015 at 7:16 am
Sorry, I don't provide queries for homework. Please look at what I previously said about breaking down the problem and try it yourself.
November 23, 2015 at 7:13 am
You could write yourself a data dictionary report in SSRS that would pull all dependencies on each object. Then refer to that report every time you go to make a...
November 23, 2015 at 7:12 am
Check the windows events logs for errors and warnings around that time. Also look at the information messages. What is going on at the server / OS level during that...
November 23, 2015 at 7:10 am
Are DB1 & DB2 on the same server? If not, run a hardware check. I can't count the number of network issues we had because a NIC was going bad....
November 23, 2015 at 7:07 am
Jagdev, post a new thread and detail your issue a little more.
People don't tend to respond to older threads.
November 23, 2015 at 7:03 am
Viewing 15 posts - 2,131 through 2,145 (of 9,720 total)