Or if your database is not too large simply use the Maint. wizard and rebuild all indexes. I do this on most of the dbs. under 2 gig a couple...

Microsoft Article # 301292  I had this issue come up all of a sudden when running DBCC Updatestats via Maint. wizard. It worked fine for months then all of a...

Thank you very much. Yes, we use Log Explorer also... never thought about that.. interesting. Most of our dbs are small (under 2 gig) but a few are going to...

Are you sure this is a problem? It the DTS task moving a large amount of rows? Remember, SQL Server by default is setup to take as much memory as...

Thanks, that is good enough. This is simply to keep the table from growing out of control. This is just a minor audit table...

Thats it, case/substring... Thank You Very Much, it is just what I was looking for. Works like a charm.

I was in a Microsoft sponsored seminar and there is a point at which you should run Reporting services and its SQL Svr repository on its own hardware (This was...

I have heard a few say its really not free.... Everyone I have heard says NO you really don't want to put this on an existing SQL Server.... its intensive...

Maybe I should add:

The issues I listed above were a few years ago in SQL2000 SP1.... maybe they don't apply as much anymore.

Now that we have all of our servers...

I was not real scientific.

One purchased application was on a dual CPU 512 MG memory. They were complaining that running crystal rpts was extremely slow. After a server reboot...

 Very interesting. Next week we start migrating from Crystal 8.5 to rel. 10. We are building new servers but choose to stay with Windows 2000.... don't know why.... They are...

We have DEV and Test on seperate servers. The reason is for SQL Server and Windows service packs. If you want to put any of these on and test its...

We have about 20 servers here running SQL Server.... On some I have found that its better to let it dynamically take care of it and others I have capped...

When you say it doesn't meet your needs what do you mean... that is pretty vague! Windows ? Clustering ? Scalability?

1. Actually very simple. Get all users and processes in a database out of it, back it up and restore via GUI restore and change to default location to the...