Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,090 reads
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,090 reads
Ever feel like you are all alone? Maybe a little isolated? This month’s PASSMN meeting might bring up these feelings...
2010-09-15
613 reads
As I mentioned in the my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the...
2010-09-15
1,389 reads
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking...
2010-09-14
714 reads
Have you taken the time to plan a fall get-away for some free SQL Server training? You can do this...
2010-09-08
753 reads
A couple weeks back someone asked me some questions about data types. Apparently, while implementing some financial data, each developer...
2010-08-24
764 reads
This Friday I’ll be traveling to Nashville for SQL Saturday #51. Because I rock, I picked a 5:40 AM flight...
2010-08-17
510 reads
That’s right! PASSMN is breaking the mold and heading onto new ground. We are making our second annual Friday full-day...
2010-08-16
539 reads
It’s that time of the month and that time of the years. Time for another PASSMN meeting. Also, time for...
2010-08-16
424 reads
It’s been a busy week and I haven’t been able to put the time in to picking the winner for...
2010-08-07
766 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;