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,903 reads
SQLStudies
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
796 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,549 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
729 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
803 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,011 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
754 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,175 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,406 reads
Using Templates
Templates are one of those really handy tools that most DBAs I know of have either never heard of or...
2013-03-18
1,156 reads
Blogs
The Third Sabbatical
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Advice I Like: Focus on what’s important
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions
By Rohit Garg
Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...
Forums
200 hours YTT in Rishikesh
Embarking on a 200 hours YTT in Rishikesh is a transformative journey that goes...
Azure Database Watcher Monitoring
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Can You Ask for a Raise?
Comments posted to this topic are about the item Can You Ask for a...
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers