Viewing 15 posts - 7,936 through 7,950 (of 22,224 total)
If you're going to set this up yourself, then I agree, Central Management Server is the way to go. There's plenty of documentation on that in the Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2014 at 5:01 am
Evil Kraig F (6/18/2014)
Grant Fritchey (6/18/2014)
Yeah, one guy offered to pay me, so I sent him my rate. And that was the end of that.
Heh, I don't mark up when...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 8:41 pm
Koen Verbeeck (6/18/2014)
Sean Lange (6/18/2014)
Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 4:18 pm
Sean Lange (6/18/2014)
Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 4:16 pm
Ed Wagner (6/18/2014)
SQLRNNR (6/18/2014)
Ed Wagner (6/18/2014)
Sean Lange (6/18/2014)
Good grief. Maybe they should just disallow any new accounts for the remainder of the world cup. So much spam.
I know what you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 11:59 am
Yeah, just piling on, we scheduled an annual restart for all machines, regardless of patching, etc. but other than that only restarted machines when there was a necessary patch. There's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 10:10 am
SQLRNNR (6/18/2014)
jasona.work (6/18/2014)
GilaMonster (6/17/2014)
"No pressure to work overtime" they say....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 9:14 am
jasona.work (6/18/2014)
Koen Verbeeck (6/18/2014)
jasona.work (6/18/2014)
Figured it was a glitch on our network here...It was a glitch in the matrix, Neo.
That explains the deja-vu when I saw the same person walk...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 6:53 am
Clay Bowen (6/17/2014)
You fail to mention the price of Embarkadero is actually higher than Erwin. I would be looking for something more cost effective.
This is a six year old...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 6:52 am
Like Gail says, the only way to know exactly what a query will return is to run it. Even if the statistics were accurate 30 seconds ago, they may no...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 6:20 am
I have two videos on Youtube on how to do this. This one is on using T-SQL to do the backups and it's the right way to do backups. This...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 6:18 am
I have made very few changes to model over the years. Instead I just script out all the necessary changes I want to make to a database as I set...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 4:33 am
Table variables can work, but understand that they don't have statistics which could affect their use in something like a JOIN. You might be better off using a temporary table....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 4:30 am
There are a ton of mechanisms built into Windows and SQL Server that will let you set all this up on your own. It's just a bunch of work and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 4:25 am
SQL_ME_RICH (6/17/2014)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 18, 2014 at 4:09 am
Viewing 15 posts - 7,936 through 7,950 (of 22,224 total)