Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
864 reads
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
864 reads
It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent...
2016-07-05
669 reads
It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent out four copies of the book based on comments from...
2016-07-05
4 reads
Yesterday was a holiday here in the United States, so I’m starting the week on Tuesday. For those in the...
2016-07-05
797 reads
The best way to make the most of the week is to set your goals. One of the things I...
2016-06-27
883 reads
So… it’s Saturday night and I missed getting this out on Friday morning…
But, in past three weeks’ posts (1, 2, 3),...
2016-06-26
719 reads
So… it’s Saturday night and I missed getting this out on Friday morning… But, in past three weeks’ posts (1, 2, 3), I talked about how I’ve got a few copies...
2016-06-26
3 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-06-20
867 reads
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
716 reads
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I...
2016-06-17
3 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;