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)
6,176 reads
T-SQL query to find the list of objects referring Linked Servers
2021-01-19 (first published: 2021-01-13)
6,176 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
371 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)
916 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)
1,122 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
35 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)
446 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)
724 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)
605 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)
493 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)
446 reads
The world of databases keeps growing, and the pressure to extract meaningful insights from...
By HeyMo0sh
Are you looking to boost your skills and knowledge in Database DevOps, learn how...
We all know that choosing the right basic SQL training is absolutely crucial if...
Comments posted to this topic are about the item Metadata Driven Pipelines – Data...
Comments posted to this topic are about the item Post Restore Tasks for the...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers