ANSI PADDING, Trailing Whitespace, and Variable Character Columns
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-17 (first published: 2008-09-12)
25,340 reads
T-SQL
2008-09-10
4,464 reads
Union
One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.
2008-09-10
10,676 reads
2008-09-09
4,272 reads
generate save, delete, get, and list objects for a table
crates sp and function template for a table
2008-09-05
188 reads
2008-09-04
5,238 reads
Two methods for converting T-SQL date/time values
Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.
2008-09-01
7,536 reads
2008-08-29
4,447 reads
2008-08-26
4,209 reads
2008-08-25
4,097 reads
Blogs
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers