Likely the information comes from two different places and is calculated differently.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

We know. We're sorry. The search is one of our weak areas and we've tried a few things, but honestly we need to get someone devoted...

Probably not. I'll remind Andy.

Don't be too excited, we're all slammed between work, the site and the magazine. Actually Frank, maybe you want to build one?

Steve...

We'll add it to the list. 😀

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I spoke with NGSSoftware about this also and we never could conclusively figure it completely out.

sorry

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

We tend to only test on IE, hey, we're a Microsoft site!! :D.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

If cost is really a factor, you might look at MySQL. Especially for non-mission critical functions, it runs on many platforms and provides basic functions.

I'd advocate SQL Server because it...

you can connect. When you add the login, you can add them from a different domain.

The recommended procedure, however, is to create a local group on the machine, add...

CPU is a tough one. Profiler is a good start. Also, you might try checking to see if the app changed.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I've tried different products (Embarkadero, FMS, Visio, etc.) none worked well. IF you come up with a way,let us know!!!

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Hell if you can configure SQL to use < 2MB, I'd hire you!!!!

I agree with most of the comments above. I'd like to see the certs matter,...

I have to admit that I tend to use single character, sometimes 2 char aliases, but they have some bearing to the tables. For example, I might use

select *

...

Anytime, and please continue the thread if you have more questions. IF you get it working, please drop the print script in our library. I'm sure someone else will appreciate...

The new Ken Henderson book on internals points out nicely that page splits cause nonclustered indexes to move because there is no "key" in the nonclustered index that points to...

Interesting. This could easily get confusing to read. Are you looking for a query that reports all jobs that "potentially" will run between some time frame?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL...