• Start
  • About
  • Contact
mattssok.com
Menu Close
  • Start
  • About
  • Contact

Script

A quick, and not so dirty, date dimension for SQL Server

2019-01-29mattssok Leave a Comment

So this week I thought we should have a look at one of the many ways to build a date dimension. With that said I want to stress that most of this is borrowed/stolen from the great mssqltips. The changes… Continue Reading →

Business Intelligence, DateDimension, Procedure, Script, SSMS, T-SQL, Uncategorized BI, Date dimension, mssqltips, Script, SQL, Stored Procedure

SQL Server – drop and alter constraints

2018-12-15mattssok Leave a Comment

Hi all! This week we will have a look at an easy and convenient way to get around those situations when you have been a good developer and used you constraints. (As you should.) However, for some reason you need… Continue Reading →

Productivity, Script, SSMS, T-SQL, Uncategorized Alter, Constraint, Drop, Enable, Primary key, Script, SQL, TSQL

Add dummy rows to a table to enforce primary/foreign key constraint

2018-12-08mattssok Leave a Comment

Sometimes the data is not what you want it to be. Or rather the quality is not what you want it to be. What I am referring to in this case is when you have a primary key and you… Continue Reading →

Procedure, Productivity, Script, SSMS, T-SQL Columns, Foreign key, Primary key, Productivity, Script, SQL, SSMS, Stored Procedure, T-SQL, Table Definition

Archives

  • November 2019 (1)
  • January 2019 (4)
  • December 2018 (3)
  • November 2018 (1)

Categories

  • Business Intelligence (4)
    • SCD2 (1)
  • Productivity (7)
    • Editor (2)
    • SSMS (2)
  • SSIS (5)
    • Agent (1)
  • SSMS (6)
  • T-SQL (9)
    • Merge (1)
    • Procedure (6)
      • DateDimension (1)
    • Script (5)
  • Uncategorized (5)
© 2021 mattssok.com. All rights reserved.
Fashionista by aThemes