RESTORE VERIFYONLY what does WITH LOADHISTORY do?
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
3,012 reads
Blog Posts
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
7 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
8 reads
SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
25 reads
SQL Server – Blocking a Truncate
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
553 reads
The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,228 reads
Are you a morning or evening person?
I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting...
2018-07-30
312 reads
Coming Back After complete 3 Years
Friends/My Readers,
Its been a long i have been away from my blogging.When i see back Its exactly 3 yrs Today(30/July/2015...
2018-07-30
317 reads
Forcing Execution Plan
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,308 reads
SQL Server Availability Group Auto Seeding Error
SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups. ...
2018-07-30
699 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers