Viewing 15 posts - 18,211 through 18,225 (of 22,219 total)
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
Yeah Steve, give us more stuff!
OK, maybe just for George here for having a bit more wit than others.
"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:22 am
To really answer the question, we'd need to see the query, but tempdb is used when you create temporary tables, either table variables or old fashioned temp tables, when 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
February 24, 2009 at 5:50 am
1) Without an index, I suspect both queries will result in a table scan. You would want an index there. With an index, I've generally found TOP to work 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
February 24, 2009 at 5:48 am
Temporary tables can be dropped automatically as the process that created them leaves scope (the user logs off or breaks the connection). Global temp tables are dropped automatically when all...
"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 5:33 am
Yeah, it sounds like duplicate entries and you don't have a natural key defined on the database. That is one of the problems with using an Identity only PK method....
"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 23, 2009 at 6:43 pm
Bruce W Cassidy (2/23/2009)
GilaMonster (2/23/2009)
Maybe the blatant feminism. MZB's not subtle about that when she...
"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 23, 2009 at 6:32 pm
Bob Hovious (2/23/2009)
She Who Must Be Obeyed
You either read H. Rider Haggard or Rumpole....
Gail, yes the Illuminatus Trilogy is worth reading, although written in the early seventies and geared towards...
"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 23, 2009 at 6:30 pm
Viewing 15 posts - 18,211 through 18,225 (of 22,219 total)