395 reputation
315
bio website
location New York, United States
age
visits member for 2 years, 9 months
seen 8 hours ago

SQL Server DBA


Oct
12
awarded  Popular Question
Sep
24
awarded  Autobiographer
Jul
3
comment When should I NOT set the Maximum Server Memory option in SQL Server?
I have also seen Jonathan's recommendations, among others. The problem is that they account for only the SQL Server engine running on the server, and not SSIS, SSAS, etc.
Jul
3
asked When should I NOT set the Maximum Server Memory option in SQL Server?
Jul
2
awarded  Curious
Jun
25
awarded  Popular Question
Jun
17
comment TempDB data files don't shrink well on SQL 2008
I had a similar problem. TempDB wouldn't shrink no matter what until I ran a few steps as seen here: calyansql.blogspot.com/2012/04/…
May
22
comment Why is this query stuck if there are no waits?
@AaronBertrand There are actually many tables, most with constraints, so it's not as simple as a delete query unfortunately.
May
22
comment Why is this query stuck if there are no waits?
@AaronBertrand That does seem to defeat the point of batching, but the utility provides no options other than "GO".
May
21
asked Why is this query stuck if there are no waits?
May
14
accepted Changing the SQL Server service account - any additional considerations?
May
14
accepted Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?
May
14
comment SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?
I should also point out that when starting the SQL Server service from Configuration Manager, it takes about 25-30 seconds before I get the error (and it then starts anyway). And one in a while, it starts without the error. Using the Windows Service screen, the SQL Server service starts up within a second or two - every time.
May
14
comment SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?
Thanks. I know that changing the service account/password should be done in Configuration Manager, but I still can't find what is generating the error, Nor can I find any reason a simple service start/stop should or should not be done via the Windows Services screen.
May
13
revised SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?
added 163 characters in body
May
13
revised SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?
added 163 characters in body
May
13
asked SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?
May
8
awarded  Critic
May
7
awarded  Notable Question
Mar
15
awarded  Notable Question