In database planning and design it is essential to plan out how much HD space you are going to need to store your data. If you use BOL and do a search for "Estimating Table Size" you get three articles: - Estimating the size of a table - Estimating the size of a table with […]
2006-06-21 (first published: 2006-06-13)
512 reads
After replying to a post today I thought I'd share this with all.This is a user defined function that I use to return a table of parameters passed in a parameter string. Function UsageSelect * From dbo.fnParseParamString ([@ParamString='Delimited String of parmaters'],[@Delimeter='Delimiting Character'])Lets say you are concatenating a list of form data from a web page […]
2006-06-13 (first published: 2006-06-07)
357 reads
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Script to identify the most expensive queries on your database server using the Query...
In this post we're going to go through the steps to set up Always...
Hi I have a situation where I am testing two versions of the same...
I'm looking for best practice here and these are Azure VMs by the way....
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Ask SSC