Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
788 reads
Ctrl-alt-geek
Quick Tip: Migrating a SQL Server Mirroring Witness server.
If you’re like me, you might be thinking “I want some more things to think about when I migrate between...
2014-03-27
638 reads
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...
2014-03-13
733 reads
Issue with sys.dm_db_index_usage_stats in SQL Server 2012
I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused...
2014-03-10 (first published: 2014-02-27)
3,210 reads
SQL Server configuration files
Problem: You require the ability to perform a repeatable standardised installation of multiple instances of SQL Server or the ability...
2014-02-13
42,358 reads
Conditional Aggregates
The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...
2014-02-11 (first published: 2014-02-04)
3,066 reads
My Favourite SSMS productivity tips
It’s a well known fact that any sitcom that runs for a certain length of time will release a clip...
2014-01-13
1,662 reads
Apply SP1 to SQL Server 2012 on active/active Windows Server 2012 cluster.
A while ago I blogged my about my approach to service packing a SQL Server 2008R2 active active cluster. Time...
2014-01-08
1,571 reads
Quick tip: Could not load package “xxx” because of error 0xC0014062
I struck this error in one of my SSIS packages, I found lots of tips and suggestions online for the...
2014-01-08 (first published: 2014-01-06)
1,990 reads
Duplicate Statistics
The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...
2013-09-03 (first published: 2013-08-28)
3,477 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers