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 on changes to a table’s structure, or I’m replacing a table with a view. I’ll usually reach for the following query (or something like it. 1: SELECT ROUTINE_NAME…
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 I figured they wouldn’t be working that week anyway.
Helpbags.org
A very good friend of mine has been working on a non-profit she created. What she’s been doing is collecting a few small things that homeless people can use. She’s not trying to cure homelessness, but she is offering a helping hand. I’ve helped her hand out these bags before. I’ve seen the appreciation on…
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 SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
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 SQL is a constant learning process. You have to be willing to look at your solutions and throw out those ideas that no longer work…
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 | default } What’s it all about? Let’s take these one at a time, and dig in a little bit. partitionSchemeName (columnName) Before you can use this option, you have to have your partition scheme defined. Check…
SQL Session – Inside SQL Server Policy-Based Management
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 SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
Time to Bottle the Beer!
It’s time to transfer the beer to the bottle! I tried a little of the premature beer. It definitely needs a little time in the bottle to mellow, and carbonate. I can’t wait a month to try this again. I know it’ll get better and better up to six months from now. Waiting is the…
ASC, DESC, and Filtered Views
I know I’ve covered quite a bit of the CREATE INDEX statement, but there is even more to learn. Today I want to cover ASC, DESC, and the WHERE clause for indexes. ASC | DESC By default, indexes are created in ascending (ASC) order. This is fine most of the time. You’re going to be…
National Brewing Day
I’ve decided it’s time to get back into brewing. So I went down to alternative beverage and get All the supplies to start crafting my own beer. I decided on the Irish Red. It’s one of my favorite styles. I got the kettle, an outdoor burner, bottles, and all the ingredients. My sister has been…