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

911 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,916 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,577 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

745 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

811 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,222 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

764 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,182 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,490 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

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

ADF Pipeline Debugging Fails with BadRequest – The Sequel

Forums

Dynamic Unpivot

Writing as an Art and a Job

String Similarity II

Question of the Day

String Similarity II