Viewing 15 posts - 14,326 through 14,340 (of 22,211 total)
I guess I don't understand, but that looks like what Craig posted. Could you try to explain it again?
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...
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...
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...
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?
September 21, 2010 at 7:10 am
Ninja's_RGR'us (9/20/2010)
TheSQLGuru (9/20/2010)
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...
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.
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...
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...
September 16, 2010 at 1:18 pm
Another positive vote. I love these things.
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...
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...
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...
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...
September 14, 2010 at 11:33 am
Viewing 15 posts - 14,326 through 14,340 (of 22,211 total)