Viewing 15 posts - 14,341 through 14,355 (of 22,224 total)
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
Assuming there's no stress on the system, running a procedure to rebuild/reorganize the indexes once a day, based on the level of fragmentation & number of pages, is fine. We've...
"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 11:33 am
ALZDBA (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
The Dixie Flatline (9/14/2010)
There are two types of people in the world. Those who can see what's coming next.And...
And you're obviously one 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
September 14, 2010 at 7:49 am
The Dixie Flatline (9/14/2010)
There are two types of people in the world. Those who can see what's coming next.
And...
We're waiting.
"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 7:35 am
Viewing 15 posts - 14,341 through 14,355 (of 22,224 total)