Database jokes
Sometimes when work is tough you just need to take your eyes and mind away from your working console. Jokes are...
2014-07-18
6,084 reads
Igor Micev
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one...
2014-07-18
1,292 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
221 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
2 reads
2014-05-21
1,834 reads
Quick Snapshot
The idea for this script came at times when I was having a project that needed to use snapshots of databases...
2014-05-09
108 reads
Script for database snapshot
The idea for this script came at a time when I was having a project that needed to use snapshots...
2014-05-09
93 reads
SQL Server sample databases
Here are some places on the web where you can find sample databases for SQL Server. It's nice to have...
2014-02-27
1,346 reads
SQL Server sample databases
Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have...
2014-02-24
212 reads
2014-02-19
2,641 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
identify consecutive records greater than 1
Hello I need help identifying all records that have consecutive hours (time in order)...
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...
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