career development
SQL Session – Execution Extract, Transform, and Load your Data Warehouse
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
Latest
personal
Surprise!!!!
Another year in the books. Time to take a break from the daily grind and go out into the world. I hereby declare this a holiday! On this day you should eat,
personal
Another Year Older, But Am I Any Wiser?
A review of the past year. Have I learned any lessons.... we'll see!
ToyboxCreations
ToyboxCreations Username Password Remember Me Register | Lost your password? ← Back to ToyboxCreations
career development
SQL Session – Execution Plan Caching and Reuse
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
personal
And Now For Something Completely Different
I've been debating what to do about my weight a lot lately. My doctor's have always given me the helpful gems: "Eat healthier foods," and "Go to the gym." I
SQL201
Find Stored Procedures Referencing…
Time and time again, I find myself trying to find all the stored procedures that reference a specific database object. It usually comes around when I'm working
My July 4th
Jul 9 My July 4th Guess where I spent the evening of the 4th? I finally made it down to m5! It was awesome. There was even a simple piece of paper on the door, thanking fans for finding the place. It was late, and no one was around, but...
book reviews
10 Questions Science Can’t Answer Yet
This book is a quick read, but it will give you lots of food for thought. There are 10 chapters, each addressing a question that science doesn't have a complete
career development
SQL Session – Inside SQL Server 2008 Resource Governor
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
t-sql
Code Review
I'd like to start a new series that will help you learn some of the techniques I've used in the past. Some of these techniques are useful, some aren't. Using
t-sql
INDEX ON partition_scheme_name, filegroup_name, and default
Consider the CREATE INDEX statement below: CREATE INDEX ix_tableName_columnName ON tableName (columnName) ON { partitionSchemeName (columnName) | fileGroupName