UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

Egads I hate MS SQL servers	by Kickstart	2004-02-10 17:09:18
Index Tuning Wizard	by Hulk	2004-02-10 22:21:44
There's a tool in Profiler (SQL 2000) called the Index Tuning Wizard (under the Tools menu). You need to record the queries and responses using SQL Profiler. They get recorded to a trace file. This trace file is loaded into the Index Tuning Wizard and then it will analyse the tables and queries to see if there are indexes that can improve performance. It's pretty smart, as long as you choose your options with a small amount of care. Typical MS really, read the dialogs carefully, you can always just restore a backup to reverse the changes. Once the optimisation is complete, you should be able to save a script to apply to the production database.
[ Reply ]
Hi some thoughts	by jedidiahstott	2004-02-11 00:54:11

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)