File Sizes
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
444 reads
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
444 reads
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,479 reads
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
856 reads
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
574 reads
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
466 reads
2013-05-10
404 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
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...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
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;