Viewing 15 posts - 5,551 through 5,565 (of 22,221 total)
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
Jeff Moden (9/4/2015)
Grant Fritchey (9/2/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 8:53 am
BL0B_EATER (9/7/2015)
I was reading the following from BOL ( which is news to me and was wondering it was really true) ... as I find it a slightly odd?...
"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 6:57 am
sqlfriends (9/7/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 6:48 am
Minnu (9/8/2015)
Is there any third party tools or SQL Server tools to compare the DB's and generate automatic scripts to sync.
Is SQL Database manager will help on...
"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:46 am
That's a huge topic. Yes, Visual Studio is your start point. Since you don't know what you're doing yet, an easy way to get going is using Lightswitch. I've used...
"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 7, 2015 at 4:38 am
Viewing 15 posts - 5,551 through 5,565 (of 22,221 total)