Monthly Archives: January 2008

Queries to get filegroup of table/indexes

  Quote Queries to get filegroup of table/indexes Yesterday, when I was looking at disk space utilization for a server, I had a need to see what objects were placed on what filegroups, and these queries were the outcome.  The … Continue reading

Posted in SQL Server 2005 | Leave a comment

Formatting a datediff

  Quote Formatting a datediff First off, I had started this post before I saw this post: http://sqlservercode.blogspot.com/2006/07/three-ways-to-get-time-portion-of.html and mine is a bit different anyhow.  (For full disclosure, the blogger in question was the inspiration for part of this post.)   … Continue reading

Posted in Uncategorized | Leave a comment

Split table using views and instead of triggers

  Quote Split table using views and instead of triggers I was playing around with instead of triggers to solve a problem with two tables being treated as one, and I came upon the following solution for making a view … Continue reading

Posted in Code Snippets | Leave a comment

PARSENAME and IP Addresses

PARSENAME and IP AddressesI had never heard of this function until the other day when Steve Kass (check out his SQL page too.  Steve has a very detailed and awesome mind) and Denis The SQL Menace, (who has a very nice … Continue reading

Posted in Code Snippets | Leave a comment

Geocoding With SQL Server

Geocoding With SQL Server Geocoding With SQL Server Update: Sept 10th 2005: The project has moved far beyond what is on this page. MySql s now supported and there is a new interface. Please click here  to get the latest information. THIS … Continue reading

Posted in Code Snippets | Leave a comment

Measure TSQL Statement Performance

http://www.sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx Measure TSQL Statement Performance How do you determine how well your application is performing?  What tools can you use?  Every developer needs to make sure that each application TSQL statement is optimized.  By tuning each query you can make … Continue reading

Posted in Uncategorized | Leave a comment

QVFS – A FAT32 based virtual file system powered by VB.NET 2005

QVFS – A FAT32 based virtual file system powered by VB.NET 2005 (CodeProject)A virtual file system created using VB.NET, a easy way to store multiple folders and files in two real physical files.Download source – 45 KB Introduction This is … Continue reading

Posted in Uncategorized | 4 Comments