I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...
2022-03-02 (first published: 2022-02-15)
210 reads
In the last few Fundamentals posts you were introduced to a couple of ways to limit and control the data stored in the tables in your database. A primary...
2022-02-28
16 reads
I recently saw a question about the Azure Data Studio Intellisense: “Why won’t intellisense in Azure Data Studio work with different schemas?” Immediately I thought, “Wait, it does.” But,...
2022-02-22
52 reads
We’ve always been able to look at statistics with DBCC SHOW_STATISTICS. You can even tell SHOW_STATISTICS to only give you the properties, STAT_HEADER, or histogram, HISTOGRAM. However, it’s always...
2022-02-21 (first published: 2022-02-07)
408 reads
I recently wrote an article about PostgreSQL restores (and by extension, backups) over on Simple-Talk. The restore process within PostgreSQL, without 3rd party involvement, can be a little tricky....
2022-02-14 (first published: 2022-02-03)
120 reads
This is just a quick note to talk about the future, mine, yours and this blog. First, I’m not abandoning SQL Server. I’m actively working on a revision of...
2022-02-09
39 reads
A common issue in performance is the lookup, key or RID, but the question frequently asked is, which columns are looked up? You need to know in order to...
2022-02-07 (first published: 2022-01-24)
414 reads
Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...
2022-01-31 (first published: 2022-01-18)
441 reads
I saw a question the other day, questioning why they’re creation of temporary tables was so slow. What they were doing was (a much more complicated version of) this:...
2022-01-24 (first published: 2022-01-10)
876 reads
Strictly speaking, a recompile isn’t really a performance tuning problem. In fact, a lot of time, recompiles are desired because they reflect changes in statistics which are likely to...
2022-01-12 (first published: 2022-01-03)
268 reads
I came across a bit of a weird error when I was trying to...
As a Software Engineer, i would like to learn how to dockerize my Python...
This is something that I’ve seen pop up a couple of times on various...
Comments posted to this topic are about the item Is Perfect Software Attainable?
Hi I am considering creating Contained Availability Groups in my production environment. Thinking I...
I run a marked transaction across multiple databases with this code:
BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs' USE sandbox2 INSERT dbo.AddressTable (AddressID, AddressValue, AddressPostal) VALUES (12, '123 three St', '4444') GO USE sandbox3 INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message') GO INSERT sandbox4.dbo.logger (uid) VALUES (700) COMMIT TRAN onemorenewdbTran GOHow many marks are inserted into msdb.dbo.logmarkhistory? See possible answers