2021-01-12
416 reads
Data Types
2021-01-05
501 reads
2019-12-19
239 reads
2019-06-11
839 reads
2018-11-27
1,004 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
3,104 reads
2017-10-05
1,054 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
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Daily Coping 3 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Forums
How to update table partwithcompany column name company id by companyid for max
How to update table partwithcompany column name company id by companyid for max partid...
Appttime add with duration how to get endtime please
Hoe to get appt_time+duration = end_time can you please help on this
SQL Sever becoming Non Responsive
SQL server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....
Ask SSC