Sins of SQL: The Time Table
Steve Gray discusses one of the oldest OLAP techiques for representing the time dimension - and shows why it's a lot easier to stick to DATETIME values.
2010-06-01
13,382 reads
Steve Gray
Blogs
Daily Coping 8 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Don’t be afraid of No
How many times have you been afraid to hear “No”? We have all been...
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Forums
DBCC CHECKDB output
I ran a DBCC on a database and it found some anomalies. Just looking...
Why is sys.master_files showing the size of RBS files as 0?
Dear Everyone I hope you are all safe in these strange times. I am...
In where condition use column value which contains column name
Hi Team, Greetings! I have below table. let table name =Emp I need to...
Ask SSC