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
459 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
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
702 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
389 reads
Adaptive Query Processing – Batch Mode Adaptive Join
Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators
2018-01-25
1,238 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
364 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
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
357 reads
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
1,425 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
318 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
187 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Alamat Kantor BCA KCU Green Garden Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
Alamat Kantor BCA KCU Sunter Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers