1,847 reputation
1115
bio website
location Rochester, NY
age 53
visits member for 5 years, 5 months
seen Aug 1 at 1:58

Apr
23
answered Row size, indexes and varchar(max)
Apr
15
comment How to reduce the SQL Server transaction log on the fly for production DB?
Not sure what you mean by "commit", but changing to simple will allow you to shrink the log file; if you aren't backing up the logs, FULL recovery is not getting you anything. Your script does what joe is suggesting, but sets it back to full when it's done. I set to simple, shrink, then if you need point-in-time recovery, set back to full and get a regular log backup to disk set up. And if you don't have full backups, get that set up too!
Apr
8
comment SQL Server 2008 Underperforming - extreme slowness after migrating to new server
Is Tempdb on a volume by itself? I would also make the initial size of tempdb large enough the it doesn't need to grow under normal use, autogrow takes time, and causes fragmentation.
Apr
8
answered How best to migrate from old SQL 2000 server to new SQL 2008 server with new name
Apr
4
answered High CPU Usage (95-99%) for mssql on the server
Apr
4
answered Is it possible to use a windows 7 professorial/ultimate as a cheap server?
Mar
27
answered How can I know that database indices are ok?
Mar
8
answered How to look at what is going on in a pegged SQL Server instance?
Mar
7
answered SQL 2008 Change recovery model resetting from Simple to Full
Mar
7
comment SQL Server 2008 has started becoming unavailable for connections at seemingly random intervals
SQL can handle that many incoming connections, but that's a lot to be generated from a single app, I thought there was a limit around 3000 or so for initiated connections. In any case, there's definitely an issue with connections not getting closed, time to dig in to the code I would say.
Mar
5
comment SQL Server 2008 has started becoming unavailable for connections at seemingly random intervals
Your guess might be right, sounds like you have a connection leak, the connections aren't being closed down and being returned to the pool, or aren't eligible for pooling for some reason. Eventually you'll run out of sockets to open. How many rows did netstat return? Did you change anything with your application pool settings?
Mar
4
comment SQL Server 2005 SP3 Express Backups Incredibly Slow
@Adam Robinson : long deletes from tables are a completely different issue, could be dependent on table size, indexing, locking. But slow disk could account for both. Can you run perfmon and see what disk queue length is on the disks? Can you check the max server memory value in sp_configure or SSMS?
Mar
4
answered SQL Server 2005 SP3 Express Backups Incredibly Slow
Mar
4
answered MS SQL Server monitoring / debugging tools
Feb
27
suggested suggested edit on Tools for tracking disk usage
Feb
27
comment Hyper-v back-up
+1: Constant protection and Access are mutually exclusive!
Feb
27
comment Optimal value for performance counter in sql server
+1 for PAL, we love PAL.
Feb
26
answered Hard Drive Partitions for SAS Drives
Feb
25
comment Can't login to SQL Server after joining domain
More likely the local admin group is not necessarily a sql admin, see big yellow box: msdn.microsoft.com/en-us/library/cc280562.aspx
Feb
24
comment SQL Server Offsite Backups
Or take a look at Quest LiteSpeed; it can easily cut backup size in half, but will run your CPU up a bit.