Always Backup WITH CHECKSUM?
When you’re specifying WITH CHECKSUM as you’re backing up databases, SQL Server will use checksums to help catch any inconsistencies with pages. This seems like a setting that you should always use and would expect to be a default setting. So why doesn’t SQL Server include it by default? They Are Who We Thought They … Continue reading Always Backup WITH CHECKSUM?
T-SQL Tuesday #150 – My First Technical Job
It’s time for T-SQL Tuesday. This month’s invite comes from Kenneth Fisher who asks to hear about our first technical job. Check out the full invite by clicking the T-SQL Tuesday image below: The Long Magenta Line Have you tried turning it off and on again? My first technical job was working in CNS (Computer … Continue reading T-SQL Tuesday #150 – My First Technical Job
Multiple Counts in One Query
Have you have been tasked with pulling multiple counts from the same table? Maybe you need to find how many records have a value for a column and how many are NULL. Or maybe you need to see how many records are true and how many are false. It’s simple enough to run a query … Continue reading Multiple Counts in One Query
Using INSTEAD OF Trigger to Update View
I ran into a strange issue recently and thought it would make for a great blog post. I was notified of a standard application process failing with the following SQL error: Msg 4405, Level 16, State 1, Line 19View or function ‘XXXXX’ is not updatable because the modification affects multiple base tables. I recognized the … Continue reading Using INSTEAD OF Trigger to Update View
More Bang for Your Buck with Buffer Pool Extension
Perhaps you started out with X amount of memory when your SQL server was brought online and over time, with additional load and activity on that SQL server, users are not quite getting the type of performance they’re used to getting. Sure, you can buy more memory. What if that’s not an option? If you’re … Continue reading More Bang for Your Buck with Buffer Pool Extension
T-SQL Tuesday #149: T-SQL Advice to My Younger Self
This month’s T-SQL Tuesday invitation comes from Camila Henrique who asks us to go back in time and give some T-SQL advice to our younger selves. It’s not hard for me to think of a few tidbits of advice. Check out the topic invitation and more by clicking on the image below: Typing on Multiple … Continue reading T-SQL Tuesday #149: T-SQL Advice to My Younger Self
What About Temporary Stored Procedures
I would venture to say temporary tables in SQL Server are common. What doesn’t seem to be as common is the usage of temporary stored procedures. Let’s take a look at creating temporary stored procedures and a few uses for them. Everything is Temporary Creating a temporary stored procedure is similar to creating a temporary … Continue reading What About Temporary Stored Procedures
Synonyms in SQL Server
Are you familiar with synonyms as they relate to SQL Server? I haven’t seen them used too much out in the wild but understand they can have benefits. Let’s take a look at what synonyms are in SQL Server and some common reasons for implementing them. So Close A synonym in SQL Server allows you … Continue reading Synonyms in SQL Server
Missing SQL Server Agent Job Owner
Do you know which account is the owner for your SQL Server Agent jobs? Some jobs might be owned by user accounts which can become a problem. What happens if that job owner isn’t around forever and goes away? Will that job just keep chugging along? Without an existing owner, a SQL Server Agent job … Continue reading Missing SQL Server Agent Job Owner
Dropping Offline Databases
…Oops. “Oops” is not a word you want to utter often as a database administrator. Sure, accidents happen (who hasn’t missed that WHERE clause when deleting data) but there are steps you can take to minimize problems that will ruin your day, week, etc. Let’s look at a few ways to delete databases that supposedly … Continue reading Dropping Offline Databases
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.