Viewing 15 posts - 5,416 through 5,430 (of 22,224 total)
Jeff Moden (10/22/2015)
Grant Fritchey (10/22/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
October 22, 2015 at 7:33 am
m.rajesh.uk (10/21/2015)
HiMy Application stored procedure is not running well. so we cleared cache.
Why? You don't know what the problem is, so instead of troubleshooting, looking at wait statistics and sys.dm_exec_requests...
"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
October 22, 2015 at 4:29 am
It has to be in the contract that negotiate with the company. I have three rates, a friend's rate, an at-home rate, and then a travel rate plus expenses. If...
"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
October 22, 2015 at 4:17 am
Sorry. I don't have something like that at my finger tips. I generally keep everything in source control and do all deployments from there. If you do a search 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
October 22, 2015 at 4:03 am
The fact that the current design consists of a giant table doing nothing but inserts and another giant table where you have to do twenty writes to concerns me quite...
"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
October 21, 2015 at 8:44 am
Not really.
I'm confused by "different environments" though. Are we talking about Development, Testing and Production as "different environments"? Or are we saying, I've got one database on five different...
"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
October 21, 2015 at 8:34 am
Sorry to hear what's going on. It sounds really tough.
Personally, I'd first try making changes to my current position. Explain to them where things are off the tracks and why....
"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
October 21, 2015 at 8:29 am
In addition to what Gail talks about, another thing to consider is a layered approach. Depending on just how responsive and thorough you want your DR process to be, it...
"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
October 21, 2015 at 8:22 am
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get to attend?...
"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
October 21, 2015 at 7:29 am
If I had to deal with something like this, I'd go to extended events. You can capture events like object_altered, object_created and object_deleted to see what was done within 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
October 21, 2015 at 7:22 am
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get to attend? Huh. News to...
"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
October 21, 2015 at 7:09 am
Assuming I'm reading this correctly, we can see the Student to Subject Relationship through the Semester to Subject table? I find that a little confusing. The Student isn't related to...
"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
October 20, 2015 at 6:22 am
Typing this on a train. Apologies for curtness and typos.
You can't say for certain how many 9s you're satisfying until after the fact. but, the way you target a 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
October 15, 2015 at 3:53 am
Stuck next to Steve on a train across the uk. He's a seat hog.
"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
October 15, 2015 at 3:48 am
Brandie Tarvin (10/13/2015)
GilaMonster (10/13/2015)
Put the keyboard down, pet the cat. Priorities!
Now she's hissing at me because I made the mistake of trying to move my other hand to the keyboard....
"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
October 13, 2015 at 8:29 am
Viewing 15 posts - 5,416 through 5,430 (of 22,224 total)