Does a Primary Key always have stats_id 1?
Back to the SQL Server Basics with Wayne
The Myth
I recently was attending a presentation where the presenter stated that the...
2018-07-09 (first published: 2018-06-28)
2,401 reads
Back to the SQL Server Basics with Wayne
The Myth
I recently was attending a presentation where the presenter stated that the...
2018-07-09 (first published: 2018-06-28)
2,401 reads
SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...
2018-07-02 (first published: 2018-06-20)
3,371 reads
New SQL blogger
Jamie at the 45th Parallel (South) – New Zealand
This post is just a quick shout-out. My friend and co-leader...
2018-06-15
329 reads
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
9,094 reads
Killing Time – or removing the time element from a datetime
Over the course of time, we all collect scripts and routines...
2018-06-07
1,883 reads
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
816 reads
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
2018-04-18
1,744 reads
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
1,945 reads
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
855 reads
There are several different options available for working with tabs and spaces in SSMS. In fact, there are enough that...
2018-03-29 (first published: 2018-03-21)
2,929 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
Comments posted to this topic are about the item Multiple Display Productivity
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers