Like Jonathan said, stress your server with a test scenario and choose the scenario that you would consider worst case.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Is it just me or does the refresh after posting not work anymore.

I'm pretty sure it worked this morning.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Just tried it, the page is still there, but a link would be nice.

And other thing, sometimes the classification of articles into the different categories isn't clear.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

http://www.tpc.org

http://www.sql-server-performance.com/ultimate_sql_server.asp

Don't know much about hardware, but you should spent this box more RAM.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you post some sample data with an explanation of what your list should look like?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Maybe you can query HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation. There you should find the information you need to do your calculation.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

No popup seems to work.

Try sending an email with the functionality in the profile section. Doesn't work anymore

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes there is a workaround

CREATE TABLE MyTable

(

a INT,

b BIT

)



INSERT INTO MyTable VALUES (1, 1)

INSERT INTO MyTable VALUES (2, 1)

INSERT INTO MyTable VALUES (3, 1)



SELECT

MAX(a), CAST(b AS...

it's the only popup in the set of buttons

Frank

http://www.insidesql.de

http://www.familienzirkus.de

No, after running the usual things like DBCC CHECKDB, UPDATEUSAGE.....I have no idea.

I know that EM uses an undocumented DBCC command

DBCC SHOWFILESTATS

to show its graphic when set to Taskpad view.

But...

Just came across this one. It might help

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

Frank

http://www.insidesql.de

http://www.familienzirkus.de

This one might also be of interest to you

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

Frank

http://www.insidesql.de

http://www.familienzirkus.de

this one goes to you, Jeremy!

was just typing when I heard your mail coming in...

Frank

http://www.insidesql.de

http://www.familienzirkus.de