2019-03-19
664 reads
2019-03-19
664 reads
2016-08-11 (first published: 2015-06-12)
3,613 reads
This week Steve Jones looks at a few tools that can help your productivity and links to a few more.
2013-12-30
356 reads
2013-12-27
1,541 reads
After a very popular first article on tools for the DBA, David Bird is back with a list of some utilities you might find very handy for working with SQL Server.
2010-01-22 (first published: 2008-12-04)
100,652 reads
2008-11-21
3,000 reads
2008-01-11
2,501 reads
2008-01-04
2,838 reads
This 3-part sponsored article surveys several different methodologies for database development, examines their strengths and weaknesses, and illustrates how Red Gate's comparison tool, SQL Compare, can be incorporated into each model.
2008-01-15 (first published: 2007-12-19)
3,959 reads
2007-10-05
2,232 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Comments posted to this topic are about the item More Funny SELECTs
Comments posted to this topic are about the item Reducing the Cycle Time
I've set up replication in my SQL 2019 environment in attempt to migrate SQL...
What does this code return?
SELECT ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; GOSee possible answers