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
Bert Wagner
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
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
3 reads
Should You Use Index Hints?
Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...
2018-08-16 (first published: 2018-07-31)
3,363 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
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
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
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
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers