Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
533 reads
A Discussion of SQL Server-Related Topics
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
796 reads
Reports in SSMS (Day 30)
SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of...
2018-01-30
535 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
848 reads
Saving SSMS Settings (Day 28)
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
392 reads
Comparing Query Plans (Day 27)
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
453 reads
A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
697 reads
Working with Comments (Day 26)
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
382 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
344 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
310 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers