|
|
-
|
|
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution with you. The challange was to keep track of changes on a table that we had only a readonly access to, and keep a history of the changes. Furthermore ...
|
|
-
|
|
The main focus of this blog is to write about SQL Server related stuff – but now and then in the past we have written a few blog posts which was not 100% SQL Server related – and that is exactly what I am going to do today.
A few months back I discovered t...
|
|
-
|
|
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at work. The session was no surprise about SQL Server performance. If you missed the ANUG event, you now have the option to listen to an ANUGCast with ...
|
|
-
|
|
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every once in a while. I knew for certain, that the affected queries were waiting for 30 seconds for an intent exclusive lock on something, before a timeout oc...
|
|
-
|
|
I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No, I like hunting for SQL queries that are messy, or down right nasty. My latest hunting adventure was to find the root cause for intermittent query timeout...
|
|
-
|
|
With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around with it before, but the other day I was asked if CDC might be used for a specific purpose. Because I had no previous experience using CDC, ...
|
|
-
|
|
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter and more efficient ways to do things – and that is spot on what I’ll do today.
Finding the time when SQL Server was last restarted, and using that timestamp to calculate the actual runtime is......
|
|
-
|
|
Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you perform the backup or restore from the gui in management studio, it shows you the progres for every 10%. But what to do if you issuet the backup or restore command yourself, and did not specify the s......
|
|
-
|
|
With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of the concatenation of two or more strings – if the input is another type than string a conversion will be done implicit. The CONCAT() function takes between 2 and 254 parameters.
Here is how the s......
|
|
-
|
|
In a series of blog posts we will have a look at the new SQL Server 2012 table type called FileTable. This first blog post will be a simple getting started – how to create a FileTable and how to dump files into the folder and do some simple file manipulation.
A SQL Server FileTable is a special tab......
|
|