SQLStudies

GO

by Kenneth Fisher

SQLStudies

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

913 reads

Comparing an inner join vs a subquery

by Kenneth Fisher

SQLStudies

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,917 reads

Well I finally passed the 70-451

by Kenneth Fisher

SQLStudies

So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...

2013-05-01

805 reads

INFORMATION_SCHEMA the un-sung system views

by Kenneth Fisher

SQLStudies

I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....

2013-04-29

2,583 reads

How do I tell the stored procedure name from inside the stored procedure?

by Kenneth Fisher

SQLStudies

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

752 reads

Who writes your documentation?

by Kenneth Fisher

SQLStudies

I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...

2013-04-22

812 reads

Calculating the length of a string (Len vs DataLength)

by Kenneth Fisher

SQLStudies

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,290 reads

How do I use a variable in an IN clause?

by Kenneth Fisher

SQLStudies

I see this question in one form or another a lot. I’ve seen this or something like it probably half...

2013-04-08

766 reads

UNPIVOT a table using CROSS APPLY

by Kenneth Fisher

SQLStudies

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,184 reads

How do I move a SQL login from one server to another without the password?

by Kenneth Fisher

SQLStudies

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,558 reads

SQLStudies

GO

Comparing an inner join vs a subquery

Well I finally passed the 70-451

INFORMATION_SCHEMA the un-sung system views

How do I tell the stored procedure name from inside the stored procedure?

Who writes your documentation?

Calculating the length of a string (Len vs DataLength)

How do I use a variable in an IN clause?

UNPIVOT a table using CROSS APPLY

How do I move a SQL login from one server to another without the password?

Blogs

Designing a Storage Load Test for SQL Server

Questions and Answers from Running a Local LLM

Overview of Claude AI Models: Which One to Choose?

Forums

A question about how to store the address in the database

SSIS package failing intermittently on last Excel Component

T-SQL in SQL Server 2025: JSON_ARRAYAGG

Question of the Day

Multiple Sequence Values