Create AT&T Network Hierarchy Diagrams using SQL Server Data
Diagrammatic support for large, complex hierarchical data structures in SQL Server.
2020-10-09 (first published: 2018-09-04)
3,259 reads
Diagrammatic support for large, complex hierarchical data structures in SQL Server.
2020-10-09 (first published: 2018-09-04)
3,259 reads
A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.
2019-06-14 (first published: 2017-10-19)
4,913 reads
Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.
2016-09-13
1,827 reads
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
2016-02-04
3,528 reads
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
2015-06-15
3,680 reads
Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.
2014-08-14
10,197 reads
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,519 reads
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
2014-01-07
4,387 reads
Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.
2013-11-04
5,383 reads
A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.
2013-07-01
4,600 reads
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
This post comes off the back of my last, where I looked at issues...
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In today’s connected world, a reliable network is the backbone of any successful business....
A while into install I get a Microsoft OLE DB Driver for SQL Server....
Comments posted to this topic are about the item More Funny SELECTs
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