Viewing 15 posts - 21,526 through 21,540 (of 22,219 total)
Funny, I was just reading about this, you can't use the TOP without an ORDER BY in that situation.
"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
November 20, 2007 at 5:53 am
I guess I'm wrong, but I thought that the TOP operator strictly applied to what was returned to the client, not what was actually processed on the server. It 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
November 20, 2007 at 5:45 am
TOP simply limits the results returned to the client. All processing that has to take place on the server to gather the result set is still done, single table or...
"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
November 19, 2007 at 1:24 pm
The only thing I'm aware of that you can do by default is monitor file growth & shrinkage through Profiler. Maybe if you created a custom counter, but I'm not...
"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
November 19, 2007 at 6:43 am
Looking through the query, it looks like you've got some design issues. You're doing joins between the billing & cancellation tables to a whole slew of other tables that 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
November 19, 2007 at 5:38 am
I don't have a clue. Would the ANTS Profiler from Red Gate work?
"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
November 16, 2007 at 1:10 pm
If just the tools supplied by SQL Server, sp_depends or sys.sql_dependencies, are not enough, you migh also want to consider looking at Red Gate's SQL Dependency Tracker
"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
November 16, 2007 at 11:32 am
In order to really provide an answer, a lot more detail would be needed regarding what the data structure looks like. It could be something as simple as providing an...
"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
November 16, 2007 at 10:59 am
Great. Thanks for the reply.
I should have looked at the INSERT statement. Missed it. That explains things nicely.
"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
November 16, 2007 at 8:05 am
How about something like this? It doesn't provide for a zero based sequence number, but it does put the numbers in the correct order. Indexing could be an issue 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
November 16, 2007 at 7:57 am
The only way to do it is to build it out completely, but I have to agree, are you sure you need a cursor?
Here's an example, ugly though 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
November 16, 2007 at 5:53 am
rose_red1947 (11/14/2007)
I have two fields, first field is with identity values like
1,A
2,B
3,C
4,D
5,E
6,F
7,G
8,H
9,I
10,J
I need to delete values 3,C and 7,G after this i want to rearrange identity values to get...
"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
November 16, 2007 at 5:40 am
Those are settings that the tool the user is accessing the database from must set. They are controlled per connection.
"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
November 16, 2007 at 5:29 am
What do you mean by "data created at the database level"?
Do you mean, is it more or less performant to create a GUID or some other type of primary key...
"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
November 15, 2007 at 5:46 am
Megha Yadav (11/15/2007)
"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
November 15, 2007 at 5:40 am
Viewing 15 posts - 21,526 through 21,540 (of 22,219 total)