GO
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...
2013-05-06
901 reads
SQLStudies
Comparing an inner join vs a subquery
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,906 reads
Well I finally passed the 70-451
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...
2013-05-01
798 reads
INFORMATION_SCHEMA the un-sung system views
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....
2013-04-29
2,552 reads
How do I tell the stored procedure name from inside the stored procedure?
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...
2013-04-24
730 reads
Who writes your documentation?
I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...
2013-04-22
804 reads
Calculating the length of a string (Len vs DataLength)
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,036 reads
How do I use a variable in an IN clause?
I see this question in one form or another a lot. I’ve seen this or something like it probably half...
2013-04-08
756 reads
UNPIVOT a table using CROSS APPLY
I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...
2013-04-12 (first published: 2013-04-01)
4,176 reads
How do I move a SQL login from one server to another without the password?
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...
2013-04-03 (first published: 2013-03-25)
9,414 reads
Blogs
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
Free Cloud Environment Setup: A Beginner’s Guide
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers