Viewing 15 posts - 7,936 through 7,950 (of 22,219 total)
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
SQLRNNR (6/17/2014)
Eirikur Eiriksson (6/17/2014)
Sean Lange (6/17/2014)
SQLRNNR (6/17/2014)
My active threads has been missing most of the day. For...
"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 17, 2014 at 12:21 pm
No special issues associated with it. Each index can have it's own fill factor and it doesn't directly affect other indexes around it. It just affects storage and retrieval 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 17, 2014 at 12:18 pm
Hard to say based on the information at hand. For most databases less than 200gb, I had everything in primary and it all worked well enough.
"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 17, 2014 at 12:17 pm
Gazareth (6/17/2014)
Welsh Corgi (6/17/2014)
I found the following article that state that you should a good backup before you Kill the process.
I think what Russell meant there was make sure 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 17, 2014 at 12:16 pm
It almost has to be incorrect security on the instance. It might incorrect security on the server. But it has to be incorrect security.
"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 17, 2014 at 12:14 pm
Viewing 15 posts - 7,936 through 7,950 (of 22,219 total)