So then, what’s the definition of an object……..?
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
571 reads
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
571 reads
As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...
2011-12-05
1,188 reads
I’ve recently decided I’ve got to get with the times and started dabbling with Powershell. Up until now i’ve not...
2011-09-19
2,161 reads
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
2011-08-09 (first published: 2011-07-27)
801 reads
On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...
2011-07-25
833 reads
For those of you who’ve worked with NetApp and SnapManager for SQL Server, you will know can generate a scheduled...
2011-06-09
1,204 reads
An ex colleague and good friend of mine has recently been having trouble with Snapmanager for SQL, anyone had similar...
2011-04-07
675 reads
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
747 reads
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
923 reads
After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many...
2011-03-11
733 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;