Author: Bradley Schacht

Content Shift, Still SQL, Just More SharePoint 0

Content Shift, Still SQL, Just More SharePoint

Many of you may have notice that I have been a little inconsistent with my posts lately. It’s been a crazy couple of months. I just want to make everyone aware of a couple of things I’m about to do...

Find Recently Run Queries 0

Find Recently Run Queries

If you have ever closed a query window by accident only to wish you could get back your work an instant later you may be in luck.  If you ran the query in question there is hope for you.  The...

0

SSIS Variable and Expressions Followup

Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday.  It has been a lot of fun, so thank you to everyone who has come out and hopefully learned...

Posting This Week 0

Posting This Week

I just wanted to do a quick post to let everyone know that I am in fact going to be posting the follow up content that I promised in my webinar and at SQL Saturday.  It has been a busy...

1

SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)

What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a lie, but the rest of this blog is not a lie, just to be clear.  🙂 COUNT(*) – Number of...

Reset Identity Column in SQL 0

Reset Identity Column in SQL

I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a table and I want to be able to just pull up my blog and look it up.  Yet again today...