Optimizing SQL Server Performance by using File and Filegroups
A look at files and filegroups in SQL Server 7.0, including some optimization tips.
2001-09-27
9,049 reads
Articles
Using AWE Memory in SQL Server 2000
Learn how to take advantage of AWE memory to boost the performance of SQL Server 2000.
2001-09-27
1,009 reads
IQ Reference Review
Tired of lugging all those reference books around? Check out this site that is sure to find a permanent home in your favorites list.
2001-09-26
2,365 reads
Review : Rent A Geek Book with IQReference
If your bookshelf looks like most in the technology field, you tons of tech books. This new product by IQ Destination allows you to virtually rent books.
2001-09-26
2,544 reads
Update: Funny Windows Error
Thanks to all of you who have sent us your funny SQL Server and Windows errors. Here are a few more contributed by Sergei Yakovlev.
2001-09-26
209 reads
2001-09-26
3,387 reads
The Sysadmin Price List
Implement this and I guarentee your tech support call volume will drop!!! (Or you'll soon be retiring)
2001-09-25
2,806 reads
Introducing IQReference
IQReference is an online reference platform using well known, published materials. Read about this exciting and benefical product.
2001-09-24
3,167 reads
Managing Spatial Information with SQL Server
You already know how to use SQL Server to manage your core business data, now learn how to leverage this knowledge to manage your "spatial" data.
DATE: September 25, 2001
TIME: 2:00pm ET, 6:00pm GMT
DURATION: 40 minutes, including questions & answers at the end
With SpatialWare for SQLServer, you now have the ability to manipulate spatial objects and store them inside of SQL Server allowing you to share information across the enterprise.
2001-09-24
52 reads
Undocumented Stored Procedures in SQL Server 6.5
This article examines some useful undocumented stored procedures in SQL Server 6.5
2001-09-21
3,304 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