Viewing 15 posts - 14,341 through 14,355 (of 22,227 total)
I agree with Jack.
But to talk about option 2 for a minute (becuase there will be times you have to go that way), simply adding the nullable column will 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
September 21, 2010 at 8:24 am
I guess I don't understand, but that looks like what Craig posted. Could you try to explain it again?
"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
September 21, 2010 at 8:13 am
If you're doing lots of design work, yeah, having a good ERD tool like ERStudio is an excellent force multiplier. You can really get a lot more work done a...
"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
September 21, 2010 at 7:55 am
You need to generate the script. You can use SQL Server Management Studio (SSMS) to generate the script. It's the easiest way. If that doesn't do what you need, 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
September 21, 2010 at 7:22 am
Greg Edwards-268690 (9/21/2010)
jcrawf02 (9/21/2010)
Finally! The perfect database tool! :w00t:http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm
Excel can do anyhing, even word processing! 😛
It's kind of like I can record a macro, so I can repeat anything.
Greg...
"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
September 21, 2010 at 7:16 am
Glad to hear these things are appreciated. The people who put them on and the speakers put a lot work into them.
Did you meet people too?
"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
September 21, 2010 at 7:10 am
Ninja's_RGR'us (9/20/2010)
TheSQLGuru (9/20/2010)
"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
September 20, 2010 at 1:11 pm
Bhuvnesh (9/20/2010)
lallu_jaya (9/20/2010)
Do you suggest Covered index on all the following columns?Do we have covering index in sql 2000 ? :unsure:
Yes, by adding all the columns in the key definition...
"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
September 20, 2010 at 9:33 am
What about making it into a stored procedure and then making the call to that? That would absolutely fix the issue.
"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
September 20, 2010 at 9:09 am
GilaMonster (9/20/2010)
*trumpet crescendo*
... and I think I'll leave things here for a little while.
Edit: And as soon as i decide not to post for a few hours, there's a...
"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
September 20, 2010 at 6:13 am
The Dixie Flatline (9/16/2010)
ALZDBA (9/16/2010)
CirquedeSQLeil (9/16/2010)
BTW - at the pace you guys are on with this thread - 20K should be easy peezy lemon squeezy.21k may be attainable 😎
A single...
"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
September 16, 2010 at 1:18 pm
Another positive vote. I love these things.
"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
September 16, 2010 at 9:12 am
GilaMonster (9/16/2010)
WayneS (9/16/2010)
But Gail, you know that there are so many other people that truly appreciate you. Just ignore the ID 10 T's and help those that appreciate it.
Yeah. Still...
"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
September 16, 2010 at 8:12 am
Tom.Thomson (9/15/2010)
Stefan Krzywicki (9/14/2010)
CirquedeSQLeil (9/14/2010)
Alvin Ramard (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
A) Admit when you are wrong.
B) If...
"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
September 15, 2010 at 12:46 pm
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
The key to arguing with GilaMonster (or anyone for that matter) is:A) Admit when you are wrong.
B) If not A, agree to disagree.
And
C) If you're right, don't...
"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
September 14, 2010 at 12:12 pm
Viewing 15 posts - 14,341 through 14,355 (of 22,227 total)