Viewing 15 posts - 2,131 through 2,145 (of 9,725 total)
If possible, you should really make your networks local first, then move them across the network (copy) when the backup is completed. It will take less time to make the...
November 27, 2015 at 12:00 pm
Lynn Pettis (11/25/2015)
Help, I can't read and don't know how to attach a file... Sorry, some people are finding it easier to push my buttons today.
Help! I can't...
November 25, 2015 at 11:32 am
So I did a "small" thing (that took more time than effort) for an internal customer this morning.
About 5 minutes ago received an email with "THANK YOU" in 40 pt...
November 25, 2015 at 9:23 am
So far as I know, there is no "expected compression" because it varies by database. Do a free space check on that large DB. A quick way of doing it...
November 25, 2015 at 7:43 am
Your escape characters need escaping. @=)
November 24, 2015 at 11:26 am
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
Viewing 15 posts - 2,131 through 2,145 (of 9,725 total)