Featured Blog: iFTS Manageability – Loading thesaurus files
MVP Simon Sabin continues his in depth look at Full Text Search in SQL Server 2008. This time he examines how you can load Thesaurus files.
2008-03-04
1,883 reads
Articles
Script Component as Data Source
In this article Dinesh Asanka demonstrates how you can use your own data sources in SQL Server Integration Services.
2008-03-04
1,650 reads
SQL Server 2005 Express Edition - Part 16 - Transactional and Merge Replication
Marcin Policht provides a step-through sample implementation of transactional and merge replication.
2008-03-04
2,533 reads
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-04
39 reads
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-04
32 reads
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-04
35 reads
Open Source SQL DDL Scripting Tool
Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.
2008-03-03 (first published: 2007-03-06)
10,167 reads
2008-03-03
16,049 reads
2008-03-03
40 reads
2008-03-03
33 reads
Blogs
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...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
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