How to Batch Updates A Few Thousand Rows at a Time
In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.
2021-01-20
In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.
2021-01-20
In this article we look at creating a SQL Server stored procedure that displays a list of all Windows services based on running or stopped state.
2020-11-24
Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead.
2020-11-20
Using Triggers to Replace Scalar UDFs with Brent Ozar.
2020-11-16
The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.
2020-10-16
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
507 reads
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?
2020-09-11
Do table variables and variables respect transactions? If we set the value of a variable during a transaction, and we roll it back, what happens?
2020-09-09
Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.
iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.
2020-09-08
19,459 reads
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
3,321 reads
When you don't have statistics, what does SQL use to calculate the estimated number...
By Ed Elliott
This is a bit of a longer one, a look at how to do...
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
GRADE A ++ VERVALINGSGELD TE KOOP EN WIJ PRODUCEREN HOGE KWALITEIT VAN ECHTE EN...
Yes, my personal favorite is naturally Pikachu. I can hardly resist its cuteness. The...
I have a requirement whereby testers on ServerA need a copy of the production...