2018-08-16
882 reads
Alter table
2018-08-02
911 reads
2018-07-26
945 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
4,283 reads
2017-06-29
1,130 reads
Change Column datatype
This script is for converting Char to nChar and varchar to nVarchar with the same length.
This process has reduced the manual work by 80% (approximately) in our case.
2017-04-24 (first published: 2017-04-10)
540 reads
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,404 reads
2015-06-16
1,966 reads
2013-10-18
2,851 reads
2012-04-25
3,652 reads
Blogs
Encrypting Your SQL Data Should be Your Default Option
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...
Power BI Embedded: Using Row-Level Security for Multilingual Reports
By DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
Daily Coping 29 Nov 2022
By Steve Jones
Today’s coping tip is to make a meal using a recipe or ingredient you’ve...
Forums
Sql table join help
I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...
Why do Sql Server In operator behaves differently and return nothing?
I am using sql server 2017. I am trying to use the in operator,...
Basic Checks on a New AWS RDS SQL Server
Comments posted to this topic are about the item Basic Checks on a New...
Ask SSC