T-SQL query to find the list of objects referring Linked Servers
T-SQL query to find the list of objects referring Linked Servers
2021-01-19 (first published: 2021-01-13)
715 reads
T-SQL query to find the list of objects referring Linked Servers
2021-01-19 (first published: 2021-01-13)
715 reads
It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and...
2021-01-14
308 reads
As I promised in my previous post T-SQL script to find hierarchy of tables – Columnar result – SQL Server Carpenter, here is another version of the query to...
2021-01-14 (first published: 2021-01-07)
843 reads
I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server...
2021-01-07 (first published: 2021-01-02)
842 reads
One of my LinkedIn connection reached out to me for help, to find the hierarchy of all the tables in a database. He was in dire need of some...
2021-01-07
16 reads
In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made...
2021-01-06 (first published: 2020-12-31)
390 reads
In the previous article Find columns with NULL values across the table we discussed that storage space can be saved by removing columns with NULL value across the table...
2020-12-30 (first published: 2020-12-21)
674 reads
Recently, I was working on one of the performance tuning assignment with an esteemed client. The size of their databases were growing tremendously. Growth in the database size is...
2020-12-22 (first published: 2020-12-11)
496 reads
Being a Database Developer or Administrator, often we work on Performance Optimization of the queries and procedures. It becomes very necessary that we focus on the right queries to...
2020-12-15 (first published: 2020-12-07)
440 reads
This article was first published on: 2020-03-14.
This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.
We'll cover examples...
2020-08-04 (first published: 2020-07-23)
408 reads
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi all, I have two SQL jobs. These jobs execute SSIS packages and then...
I am using SQL Server 2008 R2 Express edition. I have already set Maximum...
Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...