I totally agree. Indexdefrag can be done while users are online. However, it can take a very long time, e.g. a dbcc reindex on 25 GB worth of...

It's likely and possible that the ASPNet account has not been granted access to the Northwind database.  You can add/change your connection string the web.config file in your C# .Net...

I've used almost the same exact setup on a servers with 2 instances with 4 GB on W2K.  MSSQL divides or reserves the memory even if one of the instances isn't used. ...

It looks correct. Though, I haven't had a need to change the default set working set size. As long as the sql server startup account has the right...

Take advantage of their demo.

Some possible issues could be: (1) every table involved in a

query / sp must be delegated to xprime, otherwise, sql server's query

plan...

Angela,

We'll know next week when XPrime allows us to demo onsite. From a

pre-sales standpoint, I'm very impressed by the professionalism of the

XPrime technical and sales team. They have...

Unfortunately BOL is not very clear: I would set min and max memory both to the same value to limit the amount of memory that SQL Server uses when...