6 Techniques For Troubleshooting Your Code
This post is a response to this month's T-SQL Tuesday #105 prompt by Wayne Sheffield. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-08-14
Bert Wagner
6 Techniques For Troubleshooting Your Code
This post is a response to this month's T-SQL Tuesday #105 prompt by Wayne Sheffield. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-08-14
1 reads
Displaying Long Values in SSMS
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
2 reads
Displaying Long Values in SSMS
Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...
2018-08-07
347 reads
Displaying Long Values in SSMS
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
2 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
3 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
2 reads
T-SQL Tuesday #104 Roundup
This month’s T-SQL Tuesday topic asked “What code would you hate to live without?” Turns out you like using script...
2018-07-27 (first published: 2018-07-17)
2,661 reads
Pinal Dave Helps Me Fix My Performance Tuning Problems
Be sure to check out this week’s video on YouTube.
This week I was fortunate enough to film a video in...
2018-07-24
306 reads
Pinal Dave Helps Me Fix My Performance Tuning Problems
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
1 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Migrated to new server, 2019 enterprise, jobs taking 300% longer to run. Ideas?
Hi all, So here's the situation. We migrated to a new server as our...
2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847
Tables have identical structure but different indexes (except) PK and different stats. all...
Azure SSMS SQL Managed instance Windows Authentication
Hello, I am trying to connect to my SQL Managed Instance from my laptop...