Viewing 15 posts - 21,541 through 21,555 (of 22,224 total)
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
SQL Noob (11/14/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 14, 2007 at 10:00 am
SQL Noob (11/14/2007)
we have very few FK's where i...
"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 14, 2007 at 8:49 am
Personally, I'd say yes, add the constraints.
Everything Michael Earl said is true. You can simply rely on the fact that the application has the integrity covered. However, as a DBA,...
"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 14, 2007 at 6:48 am
Well, let's say you have 30 different fields, all customizable by the user. This particular user only uses 5 of the fields, the other 25 lie fallow. When you insert...
"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 14, 2007 at 5:50 am
Congratulations. Wonderful achievement.
"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 14, 2007 at 5:39 am
Foreign keys do not directly help performance. They are simply constraints on the data.
What you're saying is, that the developers are not like the rest of us humans. They make...
"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 14, 2007 at 5:37 am
Except if there are gaps (which there usually are) and you really need exactly every nth record from some particular order. Then you still have to do some kind 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
November 13, 2007 at 7:01 am
That's right there with my take on it, but I tried supplying the ID field in case the table didn't have one, or there were gaps or whatever. "Every 'X'"...
"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 12, 2007 at 12:22 pm
I think it's a fine idea.
I'd still want to be able to comment on any article from a vendor. That would tend to keep the playing field level and honest....
"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 12, 2007 at 10:22 am
Slightly off topic...
We had the planet argument in our house too. My daughter was just adamant that there were nine planets and Pluto was one of them. She was ripped...
"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 12, 2007 at 6:44 am
Viewing 15 posts - 21,541 through 21,555 (of 22,224 total)