hx_OLEDBproviders
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
408 reads
hx_ShowFixedDriveSpace
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
661 reads
2001-08-22
374 reads
2001-08-22
723 reads
Optimize Character Field Usage
This stored procedure was designed to scan all your character based columns in a particular database and show the minimum, maximum and average data length. As well as give an efficiency rating of the data stored. Input: None Output: Table name, Column name, Defined datatype and length, Average length of data for that column, Minimum […]
2001-08-10
1,670 reads
Blogs
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Forums
Db growth rate
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Reference for doing Data Warehousing in SQL Server
Everybody (well almost) knows that if you want to learn the design patterns for...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers