Prevent SQL Server Blocking using Lock_Timeout
In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.
2020-01-24
T-SQL
T-SQL script to purge all the tables including foreign key references
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
2,387 reads
SQL Server Name Convention and T-SQL Programming Style
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
2019-12-10
23,198 reads
Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-25 (first published: 2019-11-24)
698 reads
Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-12 (first published: 2019-11-08)
1,935 reads
T-SQL query to copy data from one database to another database
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in both Source and Destination DB.
2019-11-07 (first published: 2019-10-30)
5,038 reads
T-SQL query to get the latest available backup chain
T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.
2019-11-08 (first published: 2019-10-30)
3,121 reads
Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
6,096 reads
SQL and T-SQL for Beginners in 229 minutes
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
26,089 reads
Blogs
Microsoft Fabric Training and Tutorials
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
DBA and Developer: Allies or Adversaries?
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
Forums
Query about GAC (Global Assembly Cache)
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
How to check for data loss after rollback
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
How to create a baseline using counters to analyze server performance?
I am currently working on creating a baseline for our server, using various counters...
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers