SQL Server growing the data file faster than the speed of light

As I was using the following scipt to monitor the Data file autogrowths of a database today, I noticed something funny:

 

?View Code TSQLSELECT TE.name AS [EventName] ,
T.DatabaseName ,
t.DatabaseID ,
t.NTDomainName ,

Continue reading […] SQL Server growing the data file faster than the speed of light […]

 

Creating and populating Date dimension in a DW for use in SSAS

Here is a script I found on SQLDusty’s blog on how to populate a Date dimension.

I am re-posting this script here so I can have access to it at any time. Props to Dustin!

 

?View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59
–Create the tables
BEGIN TRY

Continue reading […] Creating and populating Date dimension in a DW for use in SSAS […]

 

Storage misconceptions - hard drives and SSDs

Here are a few misconceptions about storage which I have come across over the years:

the disk plates are moving faster on the inside that is why it is faster to read.

NO: it actually is more efficient to read the data on the outside part of the platter because the head can read more sectors without

Continue reading […] Storage misconceptions – hard drives and SSDs […]