Dynamic Search Conditions
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2008-03-25
3,820 reads
Articles
2007 Tech Salary Survey Results
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
2008-03-24 (first published: 2007-04-03)
10,150 reads
Name value pair (EAV) model
Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modelling
2008-03-24
7,232 reads
Ready Made Code Snippet Tool Box Courtesy of SCOM
Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.
2008-03-24
7,173 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-24
32 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-24
30 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-24
32 reads
SQL Server 2008 security and compliance features reduce security risks
Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.
2008-03-24
2,187 reads
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-23
32 reads
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-23
38 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