SQL 2005, ADO.Net and ArithAbort On/Off
Wednesday, November 26, 2008
by asalvo
I have a stored procedure, that when run from Sql Server Management Studio (SSMS) takes 1 second to run. When invoked from my web application via ADO.Net, it takes > 30 seconds (web application gets a SQL timeout). Running SQL profiler shows that the following commands are executed prior to the execution of the stored procedure:
How to recover your sql server if you can not login
Friday, May 30, 2008
by asalvo
Don't ask
New blog and some interesting Win2k8 tidbits
Thursday, August 23, 2007
by asalvo
While looking for information on how to administer a server core install, I came across a new blog resource. http://blogs.technet.com/daven I was able to get a list of command line commands that can be used to get your server core install off to a good start. When the Core installation is finished, you have a server with an unknown name, with a blank administrator’s password in a workgroup.