400 reputation
415
bio website
location New York, United States
age
visits member for 2 years, 11 months
seen Dec 9 at 18:41

SQL Server DBA


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.
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
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.
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
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
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.
Oct
15
comment Downgrading SQL Server 2012 to Lower Edition
That's a shame. There should be an easy way to do this!
Sep
30
comment Multiple versions of SQL Server on the same development machine
Aaron - what version of Windows are you using for that bad boy?
Sep
30
comment Multiple versions of SQL Server on the same development machine
Great suggestions! Seeing as how you've got so many versions running successfully, perhaps I'll go ahead and add SQL Server 2014 to my new server as well. Thanks!
Sep
30
comment Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
Nice writeup Aaron! I'm going to try this. What happens if I don't adjust the max memory while I have all 4 instances on the same node? Will the buffer caches quickly spill into the page file? Any way to prevent that other than setting the max?
Sep
24
comment Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
Yes, I have 4 instances total, 2 per node.
Jun
19
comment Databases outside of AlwaysOn availability group stuck in RESTORING status
I have not attempted any backup/restore via T-SQL. I have been using the Availability Group Wizard only, and only select a handful of databases out of 30+. When the wizard is complete, the databases I did not select show "Restoring", and the databases I did select show "Synchronized" as expected.
Jun
19
comment Can Availability Groups replace transactional replication?
Just thought I'd point out that Windows Server 2012 does not require Enterprise edition for Failover Clustering. This is now available in Standard.
May
9
comment What is the safest way to run SSIS on Multiple Named SQL Server Instances?
That's great article! Thanks for the link.
May
7
comment attach/detach v.s. backup/restore
When attaching/detaching, it's never a good idea to MOVE the files. You should always be COPYING them. I never trust Windows to move important files.
Apr
2
comment Process attempted to unlock a resource it does not own
I will try to do some monitoring next time that package runs. In the mean time, should I be concerned that there is any corruption or problems in the database?