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,379 reads
Jack Corbett
- Interests: Sports, books, Bible
Thoughts on SQL Server Certification
This is probably part 1 of a series, but no guarantees.
Why Certify?
I've been working with SQL Server for 10 years...
2010-03-19
1,842 reads
SQLSaturday Acquired by PASS – Reactions
The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...
2010-02-26
563 reads
What the Exec?
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-02-05
1,755 reads
2010-01-12
667 reads
Where Will We PASS Each Other?
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
2009-10-30
1,205 reads
Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-14
1,825 reads
What happened to that email?
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-17
1,143 reads
SQL Server Profiler Part 2: Custom Templates and Saving Data
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
2009-06-15
4,431 reads
Introduction to Profiler
This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.
2009-04-16
10,959 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers