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

Apr
30
awarded  Yearling
Aug
18
awarded  Quorum
Apr
30
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
1
comment Problems creating a functioning table
no, just the Object_ID(), everything else will work without it.
Jun
1
revised Problems creating a functioning table
added 39 characters in body
Jun
1
revised Problems creating a functioning table
added 115 characters in body
Jun
1
answered Problems creating a functioning table
Apr
30
awarded  Yearling
Dec
28
awarded  Popular Question
Nov
23
comment TFS Check-In Exception - TF30042 Database is Full
I wouldn't use 25% for growth, a fixed amount in MB or GB is better; if your log file is large, adding a 25% chunk on the log file can take a while and cause time outs. Check the SQL server for errors in the log.
Jul
8
comment SQL Server blocking queries
Have you made sure your stats are up to date and indexes well defragged?
Jun
22
answered DML Auditing (“Who did inserts?”)
Jun
21
answered Management studio bug
Jun
11
comment Windows Server 2008 Task Scheduler Tasks Not Executing
Did you check the event log for other activity in the time window, like patching/reboots? Check for services stopped/started. No daylight saving time events? Power failure, server running on UPS?
May
26
comment How do I change the system wide collation of a SQL Server 2008 instance
detaching from the old instance and attaching to the new would be quicker. Make sure your new instance is same SP level as the old.
May
25
answered User not functioning after backup and restore of database to another server in SQL Server 2005
May
24
comment SQL 2008 R2 Memory Consumption
I would monitor the SQLServer:MemoryManager:Total Server Memory counter. If there is memory pressure you should see it go down.
May
12
answered SQL Server Job Question