2019-12-19
231 reads
Data Types
2019-06-11
836 reads
2018-11-27
1,001 reads
Change Integer to BigInt on a Very Large Table
This article will show how to change the data type of a column when the table contains more than 1 billion records.
2017-11-09
2,298 reads
2017-10-05
1,050 reads
Constant Data Types
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
2016-10-03
1,627 reads
2016-08-26
1,356 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Partitioning table techniques which one is best way?
Hello All, I am about to do partitioning for my DW tables based on...
MAXDOP and cost threshold for parallelism settings
Hi All, On one of our newly migrated sup-prod azure vm which is running...
How not to have sql to restart on the same node but failover on 1st failure in a
Hi, By default sql tries to restart on the same node in case of...
Ask SSC