the query you provided will show you all registry values, not just startup parameters. you would need to add where clause to return startup parameters only.

SELECT value_name,value_data FROM sys.dm_server_registry

WHERE registry_key...

you can use xp_instance_regread to find the startup parameters on 2005 and 2008. the key path would have to chnage for named instances.

DECLARE @startup VARCHAR(255)

DECLARE @arg VARCHAR(10)

DECLARE ...

The last post for the exact same question asked on technet forums has an example of reading from 600MB with SSMS taking 45sec but reading from same table with .Net...

Whats the slow part with RBAR in SSMS? Its not using T-SQL, so without that slowdown I'm wondering why RBAR would be involved here.

Obviously its closed source, so I'm sure...

ASYNC_NETWORK_IO could very much mean that the client is the bottleneck.

http://blogs.msdn.com/b/joesack/archive/2009/01/09/troubleshooting-async-network-io-networkio.aspx

scripting via powershell[/url] is also an option and probably preferable.

haven't tried this myself but you could just try inserting directly into the CMS tables.

msdb.dbo.sysmanagement_shared_registered_servers_internal

msdb.dbo.sysmanagement_shared_server_groups_internal

use caution, usually not a good idea to insert into system tables

Might be the clients ability to consume the data. SSMS uses RBAR to retrieve rows. IF using SSMS turn on client statistics from the query menu. this will show how...

a proper length of time would be over an entire business cycle. There might be some indexes that are only used during year end and if you only look at...

this may work for you. hard to tell without table structure and sample data. read the link in my signature on how to post to get the best help

select left(substring(cast...

if you plan on using pass-though, then DBA, IIS, and AD teams may be involved. all depends on who can do what.

I think you only need to change the web.config integrated security value if you wanted to use pass through authentication (ie use logged in to website is logged into db)....

it is tough to give you an answer without some DDL and sample data. read the link in my sig to get better help.

that being said possibly something like this...

you need to change the application pool identity to your domain user "appuser.xyz.local" and disable Anonymous authentication and enable Windows Auth in the website.

CAST will accomplish what you are looking for.

select cast(cast('Jul 24 2013 8:05AM' as date) as datetime)