Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,126 reads
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,126 reads
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
719 reads
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
757 reads
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,430 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
694 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
868 reads
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
718 reads
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,676 reads
Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to...
2011-01-11
655 reads
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
765 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;