Viewing 15 posts - 5,551 through 5,565 (of 22,226 total)
I see information about speed and size. I don't see transaction through put, volume or speed, simultaneous users, high availability, disaster recovery, all the things that SQL Server provides.
However,...
"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
September 10, 2015 at 3:03 pm
Got a request for the SQL Server monsters.
I'm working on the first draft of the final chapter of the complete rewrite on the execution plans book (HUZZAH!).
It's on 3rd Party...
"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
September 10, 2015 at 12:13 pm
DSNOSPAM (9/10/2015)
"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
September 10, 2015 at 9:50 am
Why is there a GROUP BY when you're not doing any aggregations that I can see?
"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
September 10, 2015 at 8:47 am
First thing I'd do is replace all this mess with OR clauses:
( COALESCE(VMI.CompanyName,VMI.CompanyName )
That is going to absolutely destroy any chance of good index use. Don't use functions against...
"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
September 10, 2015 at 8:46 am
What Chris is saying is, you can't just reference the parameter value like that unless you change it to a table valued parameter and then do a SELECT or JOIN...
"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
September 10, 2015 at 7:52 am
Let's start from the bottom.
The free stuff, like PASS, can be as deep as you want it to be. It really depends on the class and the instructor. I teach...
"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
September 10, 2015 at 7:42 am
Sean Lange (9/9/2015)
Grant Fritchey (9/9/2015)
Fair warning though, a shocking number of vendors are really horrible at SQL Server.
Gosh Grant the way you say that makes me think you have the...
"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
September 9, 2015 at 11:06 am
It actually sounds like the process takes out locks in the database while the files move. I would classify that as a bug in the application code.
However, I agree. 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
September 9, 2015 at 10:17 am
You really need to take the log backups more frequently. Once an hour at least. That puts you in a situation where you could lose up to an hour 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
September 9, 2015 at 6:05 am
I especially don't understand the "move big folders from the application" part of the problem. That sounds like file manipulation which is not usually something done within the SQL Server...
"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
September 8, 2015 at 4:19 pm
Alvin Ramard (9/8/2015)
Steve Jones - SSC Editor (9/8/2015)
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
"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
September 8, 2015 at 10:26 am
Well, I'm wrong today. Microsoft says that they fixed in the newer version of the documentation. Of course, if you look at the old documentation...
"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
September 8, 2015 at 10:24 am
If you're saying that the application is attempting to pass 3 parameters but the stored procedure only accepts 2, then the fix is with the app. There's nothing you can...
"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
September 8, 2015 at 8:58 am
Thanks. Passed the word on. Gail, if you feel like piling on, please do so.
"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
September 8, 2015 at 8:56 am
Viewing 15 posts - 5,551 through 5,565 (of 22,226 total)