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 ‘SQLServerPedia Syndication’
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 »Parse XML in SSIS
One of the built in data sources in in SSIS is an XML document. I started writing a package to pull data from XML stored in a SQL table. I noticed that there were several little gotchas that I had to work around to get the data the way I wanted. The XML file can [...]
Posted in SQLServerPedia Syndication, SSIS Tags: Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS, XML, XML Source No Comments »Looping through files on an FTP server
I have always know that that SSIS has an FTP control Flow task, but I have never tried to use. Turn out that the task is fairly limited and can be a pain to work with. I am attempting to get a list of all files, in a folder, on an FTP server. The FTP [...]
Posted in SQLServerPedia Syndication, SSIS Tags: FTP, Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS 1 Comment »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 »SQL Custom Keyboard Shortcuts
Keyboard shortcuts play an important role to increase the productivity, in any development environment . There are tons of shortcuts that are beneficial in SQL Server Management Studio. SSMS 2005/2008 also allow you to easily add your own keyboard shortcuts. The two shortcuts that I always create are the SELECT TOP 1000 * FROM and [...]
Posted in General, SQL, SQLServerPedia Syndication Tags: Management Studio, SQL 2008, SQLServer, SQLServerPedia Syndication 2 Comments »Reporting Services – Dynamic SQL
I am working on creating some auditing reports on our current SSIS framework. I would like to create a Reporting Services report that I can have a standard looking report and change the query based on the Package Name. To do this I created a table that contains the Package name and the validation query. [...]
Posted in SQLServerPedia Syndication, SSRS Tags: Business Intelligence, SQLServerPedia Syndication, SSRS Comments Off