Data Types - Does size really matter? - nvarchar vs. varchar
How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...
top of page
- Aug 16
- 2 min
How To Identify The Grain
Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...
- Apr 14, 2021
- 2 min
Trace Flag 1117 and SQL Server 2019
For VLDBs I've always created multiple files for each file group and had to set the trace flag 1117 on to ensure that all files grow at...
- Mar 16, 2021
- 3 min
Data Types - Does size really matter? - DateTime vs. DateTime2
How many of us have just created a new table and put a Created Datetime and Modified Datetime field in with the default DateTime...
bottom of page