Viewing 15 posts - 661 through 675 (of 1,583 total)
Unless you've already done it, you might need to enable the "Data Access" option as well
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 18, 2013 at 1:51 pm
Re: Web Server: a web server can be used for anything and not necessarily SQL-related applications, so the reason I even mentioned this was for you to check to make...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 18, 2013 at 9:48 am
If the web server doesn't serve any other purpose, then there should be no issues with it - good luck!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 17, 2013 at 6:50 pm
It Depends. If the app servers are going to be looking to the SQL Server for a connection you may want to put of a "sitedown" page to let...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 17, 2013 at 9:32 am
I can only offer a simple suggestion: use a text editor capable of handling large files and do a search and replace on the carriage returns, then reimport the files...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 16, 2013 at 9:24 pm
This is a rather long time to see a checkpoint running. Is it possible something BIG happened on that particular day?
Checkpoints occur (by default) all the time and are...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 16, 2013 at 9:22 pm
This will work just fine.
Down for 24+ hours??? Wow...that's a LONG outage!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 16, 2013 at 9:08 pm
Thanks so much guys 🙂
My brain just doesn't think that way...very simplistic and I REALLY APPRECIATE IT!!!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 12, 2013 at 2:01 pm
Thanks for the advice, I will try these and monitor over the upcoming weeks
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 11, 2013 at 9:14 am
As Steve has mentioned, look at the provided article...it could help. I'd also like to ask what is the nature of the table? Does it frequently get inserted/updated or...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 10, 2013 at 9:12 pm
There is a very good write-up on this here
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 10, 2013 at 9:12 am
In this scenario Server B processes it, then passes it back to Server A
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 10, 2013 at 8:51 am
Also check thet "lock pages in memory" has been set at the OS level, if it isn't you could be constantly swapping it all out between RAM and the disk....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 9:19 am
Actually, by default this agent is set up to retry at 1-minute intervals...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 9:17 am
arnipetursson (4/9/2013)
What happens when the agent job restarts?
Do you have the job set to auto restart...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 9:16 am
Viewing 15 posts - 661 through 675 (of 1,583 total)