Viewing 15 posts - 10,336 through 10,350 (of 22,224 total)
A stall isn't the amount of time it took to write to the disk, rather it's the time spent waiting during the writes to the disk. I wouldn't compare 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 19, 2012 at 11:11 am
I'm not sure this is a schema question. There are technologies within SQL Server that will allow you to track changes, such as Change Data Capture. I'd suggest those before...
"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 19, 2012 at 11:10 am
I'm sure I won't use the appropriate terms, but usually I've seen the break downs something like this:
Junior DBA
DBA
Senior DBA
Data Architect
At my last place of employment they didn't have Data...
"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 19, 2012 at 10:24 am
Threadizens!
Who will be at Connections in Vegas? Steve and I will be. Anyone else?
And then, the week after is the Summit. Oi or is it Oy or do both apply?
"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 19, 2012 at 6:44 am
Microsoft doesn't support backward compatibility like that. However, you can try. You'd have to uninstall SQL Server and the install the older version. You'll want to test a backup 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
October 19, 2012 at 5:56 am
Blocking is a natural consequence of inserting and deleting data and can't be avoided. In order for the ACID properties of the transaction to be maintained, SQL Server must place...
"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 19, 2012 at 3:43 am
The way to get the queries executed on the system with the least amount of impact on that system is to use Extended Events. Just be prepared. You're going 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 19, 2012 at 3:38 am
Abu Dina (10/18/2012)
the most conflicts faced by me is key lookup in most of queries that i get time out
Could this be considred a good hint to add some covering...
"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 18, 2012 at 9:39 am
CptCrusty1 (10/18/2012)
Ok... We interviewed 2 candidates that seemed to have plenty of exp. C1 had 17 years of verifiable exp, checked his references, etc. Candidate 2 had FIVE...
"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 18, 2012 at 8:57 am
Why would you not trust the numbers? They're a good measure for performance. Understand, when you get to really complex queries, those measures actually can cause a performance hit. It'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
October 18, 2012 at 7:34 am
Also, going forward, treat your database code the same way as developers treat application code. Put all your stored procedures (I'd say all your database objects) into source control. That...
"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 18, 2012 at 7:26 am
And there are the Virtual Labs from Microsoft. They can help you learn online too.
"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 18, 2012 at 7:19 am
If you're just learning, the SQL Database on Azure will do a lot of what you need. They have free accounts you can set up. Also, check out Amazon Web...
"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 18, 2012 at 7:15 am
Free ones? Sure, Performance Monitor is built into every Windows OS. It's the foundation for monitoring the server and behavior within SQL Server. Then, if you're running 2008 or better...
"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 18, 2012 at 6:55 am
Do you mean the Recovery Time Objective and Recovery Point Objective? RTO being how long it takes to get back online and RPO being how much data you can afford...
"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 17, 2012 at 8:28 am
Viewing 15 posts - 10,336 through 10,350 (of 22,224 total)