A while back I learned that it’s possible to create temporary stored procedures in SQL Server. I never put that knowledge into practice however because I struggled to think of...
2019-04-16 (first published: 2019-04-02)
856 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
5 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
6 reads
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
1 reads
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
5 reads
Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...
2019-04-05 (first published: 2019-03-19)
1,596 reads
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
1 reads
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
3 reads
This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill. T-SQL Tuesday is a way for the SQL...
2019-03-29 (first published: 2019-03-12)
285 reads
It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...
2019-03-26
27 reads
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Comments posted to this topic are about the item Which Object Definitions Are Available?
Comments posted to this topic are about the item What's Your Theme Music?
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers