SQL Server Quickie #13 – Hash Join Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-29
1,822 reads
Blog Posts
Team-based Database Development: Playing Nice With Others
Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others”
If you...
2014-04-29
2,648 reads
What is a Non-Clustered Columnstore Index?
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,578 reads
[SQL Snacks Video] SQL Server Table Partitioning 103
Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two...
2014-04-28
929 reads
Central Management Studio CMS
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-28 (first published: 2014-04-21)
1,969 reads
How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation...
2014-04-28
774 reads
Last Weeks Top “Reading” Links #81
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-28
648 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
1,987 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
759 reads
Resume Generating Event (RGE)
No, I haven't lost my job. This is just one of those topics that's good to get out there. There...
2014-04-28
1,215 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?