Viewing 15 posts - 18,211 through 18,225 (of 22,226 total)
I'm not sure why you'd have an index like that at all, but yeah, if each of those indexes is used independently by your queries, you will see a benefit...
"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 25, 2009 at 9:36 am
Steve Jones - Editor (2/25/2009)
And yet one more example of things "getting worse"
Yeah, I've received one or two of those on my blog recently. It does seem like people are...
"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 25, 2009 at 9:25 am
Chris Morris (2/25/2009)
Grant Fritchey (2/25/2009)
"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 25, 2009 at 9:22 am
I agree with Jack and Barry. Yes, I try to post that way all the time. No, I don't think we need to get into sweating standards like 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
February 25, 2009 at 8:17 am
chrisau168 (2/24/2009)
I am reporting on a general ledger balance table, there are 110 million rows on this table. The reporting on this table to date has been very slow due...
"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 25, 2009 at 5:53 am
You just won't get enough information from an article for stored procedure optimization. What you need is a book. I'd suggest Itzik Ben-Gan's SQL Server 2008 T-SQL Fundamentals or Inside...
"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 25, 2009 at 5:41 am
I'm not sure I understand what you mean by "events." You can raise an error within a stored procedure and this will have to be dealt with by the client...
"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 25, 2009 at 5:36 am
Alvin Ramard (2/24/2009)
hmmmm.....First there was The Thread.
Then came Son of the Thread.
NO!!!!!!
No, no, no, Bride of the Thread was next, then Son of the Thread, then Ghost of the Thread,...
"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 24, 2009 at 4:09 pm
Everyone else has defined it already. You're getting RBAR because of the multi-statement UDF, not to mention that when you cross apply this query, it has no stats, so 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
February 24, 2009 at 4:05 pm
CROSS APPLY works. I've even seen it increase performance. Have you looked at the execution plans? Are those inline or multi-statement UDF'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
February 24, 2009 at 1:09 pm
We use a method similar to GSquared except we have a fourth machine, staging. So we testin QA and then test the deployment in Staging.
Yeah, you could experience data loss...
"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 24, 2009 at 9:18 am
Yeah GSquared has it nailed. Nothing in there should be running slow from a pure code structure stand-point. It's likely some other cause. Have you run a server-side trace 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
February 24, 2009 at 9:14 am
Are you seeing errors in the SQL Server logs? Do you have an error number or severity on the client? There are a lot reasons for a disconnect. Without more...
"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 24, 2009 at 9:09 am
Ninja's_RGR'us (2/24/2009)
For the first time I had to declare e-mail bankruptcy... just delete everything and move on.
can anybody resume the last day's comments in...
"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 24, 2009 at 8:04 am
Like I said, it's not online. It was published in the print magazine SQL Server Standard, which is published by SQL PASS. They don't have the articles on line. Go...
"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 24, 2009 at 6:25 am
Viewing 15 posts - 18,211 through 18,225 (of 22,226 total)