Reputation
445
Top tag
Next privilege 500 Rep.
Access review queues
Badges
6 18
Impact
~34k people reached

  • 0 posts edited
  • 3 helpful flags
  • 28 votes cast
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
Mar
12
revised Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?
edited title
Mar
12
asked Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?
Mar
6
asked Changing the SQL Server service account - any additional considerations?
Jan
30
comment Use @@servername and db_name() on notify operator task
For the server name portion, I recommend changing the DISPLAY NAME in the mail account configuration to include the instance name. For example, all the e-mails from my servers show "[InstanceName] SQL Server Alert" in the FROM column in my mail client. That way there is no confusion regarding what server sent the alert.
Dec
20
awarded  Popular Question
Dec
6
comment How to determine if SQL Server Reporting Services database is being used?
If that logs every report execution, I might be good to go. This table in both ReportServer and ReportServerTempDB are both empty. Perhaps they were never used. You should post your coment as an answer!
Dec
6
asked How to determine if SQL Server Reporting Services database is being used?
Dec
6
comment Why isn't SQL Server using the Max Server Memory setting?
The development team is holding us back! :)
Dec
6
comment Why isn't SQL Server using the Max Server Memory setting?
It's an inherited server, and things are moving off it....slowly.
Dec
6
asked Why isn't SQL Server using the Max Server Memory setting?