Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for more
2008-05-07
2,498 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
39 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
38 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
36 reads
This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.
2008-05-07
3,048 reads
This is a product that we have not heard much about, but Microsoft has a Data Protection Manager, designed to help ensure you can recover your databases by centralizing your backup files. Author Jay Dave brings us a short overview on this product.
2008-05-06 (first published: 2007-05-23)
5,889 reads
A unique solution that allows Reporting Services to easily publish information from your SQL Server Error logs.
2008-05-06
7,566 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-06
41 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-06
36 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-06
31 reads
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Comments posted to this topic are about the item Adding and Dropping Columns II
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
Comments posted to this topic are about the item More Documentation is Needed
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