Viewing 15 posts - 19,156 through 19,170 (of 22,219 total)
Regardless...
PLZ give complete differences
Without, at the very least, three or four lines of qualification, that's a pretty lame post on just about any topic.
"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
December 5, 2008 at 11:18 am
There must be increased sunspot activity or something because it sure seems like there's a bunch of these popping up all of a sudden.
"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
December 5, 2008 at 10:40 am
If you want to program the extraction, say using C#, get the SMO (SQL Server Management Objects) loaded into your code and you can generate create procedures for any object...
"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
December 5, 2008 at 10:37 am
And comma delimited IN statements are notorious. Like Gail said, execution plans & structures.
"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
December 5, 2008 at 10:35 am
The last ON clause for Table 3 is the same as the ON clause for Table 2.
Is that the problem?
"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
December 5, 2008 at 10:33 am
No.
But which "checks" are you referring 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
December 5, 2008 at 9:03 am
SQL Server uses late binding. So if I wrote this query:
SELECT * FROM
Dinglefarb
And checked the syntax, it'll pass. But if I execute it, while resolving all the objects involved 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
December 5, 2008 at 8:59 am
Sounds like you have a syntax error within the code that allows it to compile but not execute.
"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
December 5, 2008 at 8:34 am
It's stored in the registry, so you could query that... not a great option.
"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
December 5, 2008 at 8:33 am
I'm not so much worried about the FK's. How do I get the data out of the structure you have defined?
"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
December 5, 2008 at 7:55 am
I ran a test. I saw two StmtCompleted events for a proc that called sp_executesql. What I saw was a preperation statement and an execution statement. I suspect you'll see...
"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
December 5, 2008 at 7:52 am
StmtCompleted is pretty expensive to the system. You'd be better off collecting RPC:Completed and SQL:BatchCompleted. Those two are more or less equal. StmtCompleted are the individual statements within a batch...
"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
December 5, 2008 at 7:35 am
pat (12/5/2008)
Tables:
Person : emp_id, org_id,mgr_id,loc_id
manger : Mgr_id, Name
Location : Loc_id, disc
Organization : org_id, disc
so now the question is :
org_id for all empid belong...
"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
December 5, 2008 at 7:32 am
I agree with everything Michael posted.
The one point I'm not sure about... From your description, does this report even use a WHERE clause when accessing the information for display? Does...
"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
December 5, 2008 at 7:03 am
Speaking generally, it really sounds like you're on the right track using partitioning. Andy Novick (MVP, consultant, nice guy) has presented at PASS and our local users group on using...
"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
December 5, 2008 at 6:59 am
Viewing 15 posts - 19,156 through 19,170 (of 22,219 total)