2020-09-22
906 reads
Sergiy Floka
Banker’s Rounding. What is it good for?
An in depth look at the implications of using Banker's Rounding.
2020-06-15
18,582 reads
Performing a Right and Comprehensive Age Calculation Part 2
Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.
2017-03-30
1,843 reads
Performing a Right and Comprehensive Age Calculation
Age calculation based on the right method used in real life.
2017-03-28
4,312 reads
2017-03-09 (first published: 2017-02-16)
1,985 reads
2016-11-16
1,262 reads
2013-06-24
2,883 reads
2013-05-24
2,362 reads
2013-04-30
2,260 reads
2008-09-04
5,244 reads
Blogs
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Forums
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
More Documentation is Needed
Comments posted to this topic are about the item More Documentation is Needed
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers
