DBCC CheckTable, Spatial Indexes and incorrect compatibility mode…..
Just a very quick blog today regarding an issue that has arisen with one of my clients. During Integration it...
2012-11-19
1,251 reads
Just a very quick blog today regarding an issue that has arisen with one of my clients. During Integration it...
2012-11-19
1,251 reads
I finally pulled my finger out and took the last exam of the MCSE SQL Server 2012 – Data Platform certification...
2012-10-30
6,869 reads
Well I finally got around to completing the MCSA aspect of the SQL Server 2012 Certification and I’m pleased to...
2012-09-13
1,306 reads
I wouldn’t class myself as an expert in SSIS but I certainly know my way around but came across something...
2012-07-03
8,689 reads
Well after being a bit late in trying to book the beta exams I managed to get three of the...
2012-06-25
936 reads
Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their...
2012-06-25
777 reads
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,504 reads
After sitting the Administering Microsoft SQL Server 2012 Databases Beta exam (71-462) on Monday, I was still a little disappointed...
2012-04-06
1,366 reads
On Monday I did my first Microsoft SQL Server exam since I did my SQL Server 2000 exams many moons...
2012-04-04
1,438 reads
Sorry for another Powershell post but I’ve been doing a lot of it recently and coming up with (what i...
2012-02-03
20,735 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;