Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
I’m excited to announce that I’m joining the evangelist team at Redgate. Starting next Monday, I’ll be working with Steve Jones, Grant Fritchey, and Kathi Kellenberger — plus the whole...
2018-08-15
2 reads
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
18 reads
I’ve just scheduled two new podcast recording sessions! These are live, half hour sessions – you can join in listen, or share comments. Here’s what we’ll be talking about…....
2018-08-03
2 reads
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
6 reads
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
2 reads
I’ve been enjoying working with SQL Operations Studio lately – a new, free, cross-platform editor from Microsoft. The tool is under active development and it’s a great time to...
2018-07-25
1 reads
I recently received my seventh “Most Valuable Professional” award from Microsoft. Oddly, I don’t think I’ve ever written about what this award means to me until this point. In...
2018-07-11
2 reads
In the last year, developers and DBAs have heard a lot about the General Data Protection Regulation (GDPR) law passed by the European Union. These regulations not only impact...
2018-07-05
1 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Comments posted to this topic are about the item Attaching an SQL Server database...
Comments posted to this topic are about the item Superseded Indexes
I am getting the below error when I execute a SQL command in SQL...
Which of these indexes is superseded by another?
See possible answers