Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
859 reads
StrateSQL
SQL Server Indexing Book Giveaway – Week 5
It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent...
2016-07-05
666 reads
SQL Server Indexing Book Giveaway – Week 5
It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent out four copies of the book based on comments from...
2016-07-05
1 reads
Tuesday Morning SQL Break – July 5, 2016
Yesterday was a holiday here in the United States, so I’m starting the week on Tuesday. For those in the...
2016-07-05
792 reads
Monday Morning SQL Break – June 27, 2016
The best way to make the most of the week is to set your goals. One of the things I...
2016-06-27
880 reads
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So… it’s Saturday night and I missed getting this out on Friday morning…
But, in past three weeks’ posts (1, 2, 3),...
2016-06-26
715 reads
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So… it’s Saturday night and I missed getting this out on Friday morning… But, in past three weeks’ posts (1, 2, 3), I talked about how I’ve got a few copies...
2016-06-26
1 reads
Monday Morning SQL Break – June 20, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-06-20
863 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
713 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I...
2016-06-17
1 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
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
SSIS package works in VS but failed in SSMS
Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has...
Need a list of stored procedures that execute multiple stored procedures
Hello SSC! I hope you all had a happy and safe holiday! Apologies if...
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 OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; See possible answers