Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of extended support with Microsoft today! 9th July...
2019-07-24 (first published: 2019-07-09)
699 reads
As if I don’t have enough to do, I started a data structures class at Redis University. Someone recommended this to me as another way a company has structured...
2019-07-24
37 reads
A little bit late but it is here! It is Wednesday already and we are preparing for #DPS2019 which will be in August in Bangalore. Meanhwile I received another...
2019-07-24
20 reads
This is a simple powershell script to query and display hardware and OS information from a remote computer.It uses CIM (Common Information Model) that is available since Powershell version...
2019-07-23
2,682 reads
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics...
2019-07-23
136 reads
Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...
2019-07-23
179 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
3 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
4 reads
Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...
2019-07-23 (first published: 2019-07-09)
806 reads
In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script. When you...
2019-07-23 (first published: 2019-07-08)
715 reads
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers