A Surprising Result from Ident_Current

If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...

5-Weeks to PASS Summit 2010 Countdown

With 5-weeks until the PASS Summit it’s time to start getting ready for the event.  As I’ve discussed a couple...

Determine if Directory Exists using xp_cmdshell

Recently, I came across a forum post from a user trying to determine if a directory existed in the file...

PASSMN Board of Directors Nominations

It’s that time of the year again.  Time to get in some nominations for the 2011 PASSMN Board of Directors. ...

Tip: OVER and PARTITION BY

Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…

OVER
OVER allows you...

It’s Implied

This has been on my radar now for a little over a week.  I ran across a  request in the...

SQL Saturday New England: The Date

Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...

How Do I Spot Identity Columns That Are About to Max Out?

Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...

SSWUG Fall 2010 Virtual Conference This Month

Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up.  On October 20-22, you can attend a conference from...

Reminder – Deadline for SQLRally Pre-Con Abstracts is October 15th

See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...