September 14th, 2011 
When maintaining a data warehouse, it is import understand the size and disk requirements of your tables over time. My current client has asked that I generate a report showing table disk usage over time, so that we can predict table growth. I was looking around and found the procedure sp_spaceused. This returns the row [...]
Posts Tagged ‘T-SQL’
Table Size History
Posted in SQL 
Tags: Dimesion, Disk Usage, Fact, sp_spaceused, SQL, SQL 2008, SQLServer, SQLServerPedia Syndication, SSIS, SSRS, T-SQL, Table 
No Comments »Avoiding dups when querying sysssislog
Last year I blogged about Avoiding dups in Parent Packages, when using custom logging. Todd McDermind has a good post on how to query the sysssislog table, if you are using the built in SQL SSIS logging. http://toddmcdermid.blogspot.com/2011/04/transforming-ssis-sysssislog-entries.html
Noir SQL… Or, a Hardboiled Approach to Getting the Job Done
You can tell a lot about my state of mind by the books I’m reading. Lately, it’s Urban Fantasy with a Noir feel to it. Specifically, I’m reading Mike Carey’s Felix Castor series, and I just finished a book by Richard Kadrey called Sandman Slim: A Novel. I love the anti-hero. The protagonist who is [...]
Advance Search – SQL Server
As a BI Consultant, I am frequently going into new databases and writing queries against unfamiliar data sources. I have created a stored procedure that goes against the system views to help quickly find a key word in a Table, View, Columns or Stored Procedure. Once the procedure has been created you can execute it [...]
Posted in SQLServerPedia Syndication, T-SQL Tags: SQL, SQL 2008, SQLServerPedia Syndication, T-SQL No Comments »Getting Schooled on Dynamic PIVOT
I wrote a post about Deconstructing Pivot. With my newfound confidence, I decided to tackle dynamic pivots. This is a common scenario where you need to PIVOT, but you don’t know exactly what you’re going to end up with. Basically, you want to allow all of the possible column headers to come back with the [...]
Trusted Foreign Keys
Hey friends! Long time, no see. I know, you’re wondering where I’ve been. Lately, I’ve had the luxury of taking some time to work on Microsoft certifications. I just got through 70-448, Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Now, I’m working on 70-433, Microsoft SQL Server 2008, Database Development. I’ll admit… I [...]
Posted in Database Development, Performance, T-SQL Tags: Database Development, Foreign Key, SQLServer, T-SQL Comments Off