Thats a good question! I guess the ideal would be a way to specify the bandwidth - maybe can be done at a router or switch. Lets see if Steve...

You need to build up the update statement as a string and then run with Exec or sp_executesql. SQL won't evaluate the tablename the way you have it now. You...

Professional SQL Server by Rob Viera is pretty good for an overall look at SQL development with some admin mixed in. For VB Francisco Balena has a great one for...

Try using 'with NO_INFOMSGS'. Not sure if all DBCC supports it or not.

Andy

Could you post your code so we can see exactly what you're attempting?

Andy

I agree the 10m NIC isn't a perfect simulation, but for something like a snapshot is better than nothing to gauge the time!

Andy

If you're only concerned with DDL, why not just profile it? Easier than dealing with the log.

Andy

I dont think so. The 2G is allocated by Win, you'd be sharing the same memory. You can use up to 8G with AWE if you have Win2K AS.

Andy

Jon posted a couple articles you might find interesting:

http://www.sqlservercentral.com/columnists/jwiner/returningasubsetofarecordset.asphttp://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp

Andy

Depends on the volume of course, but I'd bet you can get by with the 2m connection. Put a 10m NIC in a box and try it locally.

Andy

Glad we could help. Visit often!

Andy

You're not going to be able to use all 16G for SQL unless you run DataCenter. Win2k AS maxes out at 8G.

Andy

If you only allow access to the table via stored proc you can add a logging line in it.

Andy

Full text searching is made for this. Not very hard to get set up, Jon Winer has a couple articles posted about using it you might find interesting.

Andy

You can retrieve it from sysobjects or use DMO to get it. Why would you want to alter a view in a web page?

Andy