Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
41 reads
Articles
Table-valued parameters – SQL Server 2008
In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
2008-06-02
2,812 reads
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
39 reads
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
40 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
45 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
31 reads
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
42 reads
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
35 reads
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
50 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-05-31
45 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
Create filegroups in partition
I have a table with partition on create_timestamp field. Though we're storing all data...
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:...
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