SQL SERVER – Performance Impact of Unique Index
Today I am going to share a story of my client who has hired me over 7 times for my most popular consulting service Comprehensive Database Performance Health Check for different servers and situations. In the latest engagement, we had a very interestin …
How to Enable SQL Server CLR Integration using T-SQL
The post How to Enable SQL Server CLR Integration using T-SQL appeared first on SQLServerCentral.
Do you really know what’s happening with your servers?
The post Do you really know what’s happening with your servers? appeared first on SQLServerCentral.
PolyBase in SQL Server 2019 – The End of ETL?
One of the new features in SQL Server 2019 is SQL Server Big Data Clusters, and one part of this feature is PolyBase. Now you may wonder: Hasn’t PolyBase been around for quite a while? And you’re right! PolyBase was introduced in SQL Server …
Building an AMD Ryzen 7 3700X Desktop Machine
Since the AMD Ryzen 3000 series processors were released on July 7, 2019, I decided to build a new desktop machine based on this processor. This was to give me some hands on experience with an AMD Ryzen 3000 series processor, and because I actually enj …
DBA Training Plan 4: Checking for Corruption
You would think that when SQL Server writes your data to disk, it’s totally safe. Forever. You would be wrong. It’s almost like there are gremlins out to get you, purposely trying to trash your data. In the really old days, it was problems …
SQL Authority News – SysAdminDay – System Administrator Appreciation Day
System Administrator Appreciation Day or SysAdminDay is around the corner and I am very excited about it. Every single year, I receive tons of emails and messages on this day.History of SysAdminDayI think the trend of celebrating sysadmin day is increa …
Azure Elastic jobs
Azure Elastic jobs provide similar functionality in Azure as MS SQL Server Agent for MS SQL Server databases on premises. The only big problem I have noticed so far is a lack of graphic tools to manage Azure Elastic jobs. So, the most of operations wit …
Data privacy next steps: Compliant Database DevOps
The post Data privacy next steps: Compliant Database DevOps appeared first on SQLServerCentral.
What are Columnstore Indexes?
Columnstore indexes were first introduced in SQL Server 2012. They are a new way to store the data from a table that improves the performance of certain query types by at least ten times. They are especially helpful with fact tables in data warehouses. …
DBA Training Plan 3: Treat Your Servers Like Cattle, Not Like Pets
In our last post in this series, I talked about why you should be using Ola Hallengren’s maintenance script for backups and sp_DatabaseRestore for faster restores. These two tools have implications for how you build, back up, recover, and fail ov …
SQL SERVER – Dynamic SQL and Temporary Tables
Followup question to previous blog posts is always fun and interesting. Earlier on this blog, I had written about SQL SERVER – Dynamic SQL and Global Temporary Tables, I received following follow up question about Dynamic SQL and Temporary Tables …
Data Transfer Strategies between MongoDB and SQL Server
SQL Server users are accustomed to the relative ease with which they can get data from, and send data to, other databases systems. This article aims to answer the question of whether there are any problems of data interchange with MongoDB. In doing so, …
How to find Updated Column in SQL Server Trigger
The post How to find Updated Column in SQL Server Trigger appeared first on SQLServerCentral.
Can an Index Reduce Performance of SELECT Query? – Interview Question of the Week #234
Question: Can an Index Reduce Performance of SELECT Query?Answer: Of course!I have discussed this subject multiple times on this blog. Of course, Index can reduce the performance of any query and particularly of SELECT queries without even being that i …