1,727 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 7 months
seen yesterday

Jan
26
revised Running a number of .sql files using SQLCMD
added 75 characters in body
Jan
26
answered Running a number of .sql files using SQLCMD
Jan
22
awarded  Yearling
Jan
8
comment Was I right with locking?
NOLOCK on DELETE's is deprecated; why would you want to delete uncommitted data anyway?
Jan
5
comment Four db servers all identical, one is much slower than the others
Double check the network settings, if they're set to auto they may have negotiated down to 100mb.
Dec
24
answered Performance gain by moving a large table from a database and referencing with a synonym
Dec
14
comment Keep transaction log size under control during batch processing
I would disable that and run a manual stats job, I wouldn't think it would cause a log run up like you saw though.
Dec
13
answered How do I run a batch file from a scheduled Job via SQL Server Agent
Dec
13
comment Keep transaction log size under control during batch processing
@QuickJoeSmith, Are you using auto-update on statistics?
Nov
22
comment How can I have SQL Server listening on more than one IP address?
Stop and start SQL service if you haven't. Check the SQL Logs in management studio from the last startup, it will list the IP addresses it is listening on. Also check netstat -an
Nov
22
answered What would I look for in SQL Server to determine if a user connected with Microsoft Access?
Nov
21
answered Linked server to SQL Azure very slow
Nov
21
answered How can I have SQL Server listening on more than one IP address?
Nov
19
comment Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?
In 2008, open the properties window (F4), and click in the whitespace of the design panel, AutoRefresh is under Other
Nov
18
comment Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?
In BIDS, it should be under the top menu Report / Properties / General; at least for 2005, I think they moved it for 2008 but it's in the same general area IIRC. I don't get the "loading" with my instance, even when refreshes take forever.
Nov
18
comment Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?
what version of ssrs, and how are you doing the refresh? with the built-in "refresh every ... seconds"?
Nov
12
answered SQL Rebuild Index, Recovery Model, and db log filesize?
Oct
29
comment Can I Simply Change A Transaction Log From Unrestricted to Restricted?
true; i missed the change to simple part. how about add full backup job.
Oct
27
comment Can I Simply Change A Transaction Log From Unrestricted to Restricted?
and don't forget to add a log backup job.
Oct
21
comment SQL Server 2008 R2 “Ghost Memory”?
The only time I'd be concerned is when my sql server is using LESS than 82%!