2008-03-03
31 reads
Articles
Adding Reporting Services to an existing SQL Server installation
In this tip we look at the process of installing Reporting Services on a server that is already running Database Services.
2008-03-03
4,015 reads
Configuring SQL Server memory settings
Learn about SQL Server memory needs and settings including RAM amounts, how to enable AWE, maximum server memory and the differences of 32- and 64-bit platforms.
2008-03-03
4,550 reads
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
2008-03-02
35 reads
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
2008-03-02
29 reads
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
2008-03-02
32 reads
Monitoring and Recording DDL changes on SQL 2005 (NARC)
Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.
2008-02-29
7,488 reads
Practical Methods: Naming Conventions
Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.
2008-02-29 (first published: 2007-03-07)
15,075 reads
Check List for Performance Optimisation in SQL Server Analysis Service 2005
This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.
2008-02-29
2,565 reads
Enabling Drillthrough in Analysis Services 2005
Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.
2008-02-29
1,461 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