2019-12-19
258 reads
Data Types
2019-06-11
850 reads
2018-11-27
1,029 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
5,428 reads
2017-10-05
1,069 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,653 reads
2016-08-26
1,385 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers