Viewing 15 posts - 151 through 165 (of 392 total)
muthukkumaran Kaliyamoorthy
I hope you enable the auto update statistics.Right?
I disagree. Globally setting autoupdate statistics to on can have a deterimental effect on your system if it decides to update...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
August 1, 2011 at 8:20 am
The answer is no because with each run the data could change and result in different results. It does depend on the data at the time to queries are run,...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 26, 2011 at 1:33 am
sknox
If I asked you how many rows those queries would return BEFORE you ran them, would you be able to tell me without looking at the data?
The answer is no,...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 25, 2011 at 12:32 pm
It is a shame that so many people are more interested in the point that they may or may not have gotten than the lesson from the QOD. It definitely...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 25, 2011 at 9:09 am
Ninja,
Do I have a tendency to post untested code?
As I said earlier I'm not perfect, but I think I have a good track record there
I don't think I was...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 20, 2011 at 2:44 pm
Well, I think this was a useful reminder to us to actually look at the code
I agree. Part of our job would be to review code. This shows what could...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 20, 2011 at 11:18 am
I thought it was a duplicate from a couple days ago and answered it too quickly. Got it wrong of course.
Same here - that's what happens when rushing:hehe:
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 8, 2011 at 6:34 am
Seth,
Run the following against your distributor in the msdb database:
SELECT subsystem, agent_exe, max_worker_threads
FROM syssubsystems
WHERE event_entry_point = 'ReplEvent'
This will tell you the configuration for your various replication agents. My understanding...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 8, 2011 at 5:37 am
Seth
the magic formula for how many of these jobs I can have running at a time? I don't want to have us get more memory only to find out...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 7, 2011 at 10:02 am
I think I've found my problem. My server seems to cap out at 96 continuously-running distribution jobs, once I attempt to set up the 97th it won't initialize the subscription,...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 7, 2011 at 9:57 am
row
I am not sure a DBA boot camp would be useful. The reason being is that you cannot train for all the incidents that can and will occur in a...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 6, 2011 at 12:15 pm
1. Yes - 1974, Ft Jackson SC
2. No - Though the concept is good, IMHO I do not think it is a viable solution.
First, what is the standardized definition...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 6, 2011 at 10:12 am
The database developer really should be a SYSADMIN in the development environment, or at least have permission to VIEW SERVER STATE, ALTER TRACE, and SHOWPLAN permission
Agreed - and in our...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 5, 2011 at 1:36 pm
I am so confused now...
Seems that I am not the only one. How can the answer be one and the explanation be the other???
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 29, 2011 at 6:39 am
Viewing 15 posts - 151 through 165 (of 392 total)