381 reputation
210
bio website
location New York, United States
age
visits member for 2 years, 2 months
seen Apr 17 at 12:57

SQL Server DBA


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?
Apr
2
comment Process attempted to unlock a resource it does not own
The Windows logs have nothing else at that time. There was an SSIS package running at the time which finished after the error message with a SUCCESS. I'd have to do a lot of digging and work with developers to try to replicate this somewhere else, but I can do it if needed. I did see that connect item, but we're at SP4 already, so I don't think that will help.
Mar
15
comment Efficency of stored procedures vs raw queries
There's a great related article here, including scripts to delete those single-use plans. sqlskills.com/blogs/kimberly/…
Mar
13
comment How do I get more details on a full text catalog error?
No luck with integrity checks, and no luck with the troubleshooting section unfortunately.
Mar
5
comment SQL Server Database Mail - Why can't I run an execute against xp_sysmail_activate?
That was exactly the issue. I changed the owner of msdb to sa, and all the e-mails starting sending. Good catch and thanks!
Mar
4
comment SQL Server Database Mail - Why can't I run an execute against xp_sysmail_activate?
Version 10.50.2500. Also, I tried GRANT EXEC ON schema::sys to [your_login_name]; No luck there.
Nov
21
comment Finding exact statement causing error 3930
Perfect! I found that the error was a try/catch set up incorrectly in a trigger. Thank you.