2021-01-05
533 reads
Data Types
2019-12-19
259 reads
2019-06-11
851 reads
2018-11-27
1,032 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,469 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,655 reads
2016-08-26
1,386 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
Don't Let Corner Cases Drive Your Design
Comments posted to this topic are about the item Don't Let Corner Cases Drive...
A New Operator
Comments posted to this topic are about the item A New Operator
Troubleshooting Common SQL Server Errors: 823, and 824
Comments posted to this topic are about the item Troubleshooting Common SQL Server Errors:...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers