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

908 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,912 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

801 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,571 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

735 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

808 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,148 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

759 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,179 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,452 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

When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

Prepping for Certification, Part 4 of 4

Flyway Tips: Automation Assistance in Flyway Desktop

Forums

CAST datetimeoffset(7) as a datetime in UK format

Used Car Dealerships Near Me – Recommendations Needed

what are the downsides of TDE not running vs running?

Question of the Day

Putting the Player with the Number