When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
639 reads
I have been experimenting more and more with ChatGPT on a regular basis. I’m interested and curious how this will help. I had a friend at one of the...
2023-05-26
27 reads
I delivered a presentation for the Houston SQL Server User Group tonight, virtually from Colorado. I’d love to go down, but couldn’t do it today. The slides for the...
2023-05-25
16 reads
I’m going to attend the Denver Dev Days 2023 in June. I submitted a few sessions and got two picked. I’ll be doing these talks: Blogging for the Tech...
2023-05-25
4 reads
Microsoft states that enabling TDE usually has a performance overhead of 2–4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want...
2023-05-24 (first published: 2023-05-10)
931 reads
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
442 reads
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
1 reads
Setting up a local web server was something that I haven’t done in a long time and this was really easy. This post shows how to do this with...
2023-05-24
159 reads
I had a question on multiple backups in a file and had to check my syntax. This post shows how to see which backups are in a file. Note:...
2023-05-24 (first published: 2023-05-10)
134 reads
Using Statistics Parser to easily read output from STATISTICS IO and STATISTICS TIME.
2023-05-23
283 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;