Viewing 15 posts - 8,926 through 8,940 (of 22,219 total)
GilaMonster (2/12/2014)
Benki Chendu (2/12/2014)
GilaMonster (2/12/2014)
Benki Chendu (2/12/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
February 12, 2014 at 6:14 pm
Assuming there's more to this query than in the plan you posted, to get improved sort performance, the best mechanism is eliminating the sort entirely from the plan. This is...
"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
February 12, 2014 at 9:13 am
Personally, if it's on the forums, I skip it. If I can't understand what's being asked, even to guess at it, I'm not about to go through the pain 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
February 12, 2014 at 9:04 am
Here's an article[/url] I wrote on doing backups that includes new material from SQL Server 2014. It covers all the basics. This is an older article[/url] I wrote on 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
February 12, 2014 at 9:00 am
Personally I wouldn't sweat the hot spot aspects of identity columns. That used to be a pretty major problem back in the day (say, SQL Server 7 and earlier), but...
"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
February 12, 2014 at 8:56 am
It's possible the query is being run from more than one database.
The real problem is, this is an imprecise mechanism for identifying long running queries. It's completely dependent on 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
February 12, 2014 at 8:44 am
A NULL for the Object name would just imply that you're seeing ad hoc or prepared queries that don't have an object because they're not being called by a stored...
"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
February 12, 2014 at 6:12 am
pmadhavapeddi22 (2/12/2014)
I have re written the query by joining the de norm table in from clause, but the no of
reads and cpu are high with the new query. Old query...
"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
February 12, 2014 at 6:02 am
Another vote for the Enterprise Policy Management Framework. That really made Policy Based Management take off and be useful in our organization.
"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
February 12, 2014 at 3:56 am
I just got in touch with Jorge Segara who wrote the book. He should be by here shortly to get you an answer.
"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
February 11, 2014 at 5:47 pm
I explain how to do the multi-server execution on scripts in this article[/url] (it's focused on backups, but should work for you). Phil Factor talks about some other aspects 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
February 11, 2014 at 5:42 pm
That's not something I've seen before. And that's pretty straight forward code. Any chance the databases are marked as offline or something along those lines? Have they recently failed DBCC...
"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
February 11, 2014 at 5:39 pm
Back when I was doing 2005 upgrades, I ran it against lots of production systems with no issues. Does it add to the load on the server? Absolutely. But 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
February 11, 2014 at 5:36 pm
SQLRNNR (2/11/2014)
Jeff Moden (2/11/2014)
pmadhavapeddi22 (2/11/2014)
Sorry for the late reply,
continuation of the above topic...
As you asked, the below is one of the update statements we are using in stored procedure
Update...
"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
February 11, 2014 at 5:32 pm
Sean Lange (2/11/2014)
jcrawf02 (2/11/2014)
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of a shirtless Grant...
"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
February 11, 2014 at 9:52 am
Viewing 15 posts - 8,926 through 8,940 (of 22,219 total)