I am modifying a table and I need to add a column that must be defined as being unique. I see that SQL Server allows you to define a UNIQUE constraint on a column but I also see that you can create a unique index on a column. Which one should I use?
2008-09-05
8,319 reads
In this new SQL School video, MVP Brian Knight shows us how to get started with data mining and Reporting Services retrieving data from an Analysis Services cube.
2008-09-04
7,036 reads
How many times has someone asked you to determine how many instances of SQL Server are installed on your network? New author Sakthivel Chidambaram brings us a few tricks for keeping track of those installations.
2008-09-04
23,547 reads
This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008
2008-09-04
2,481 reads
It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information.
2008-09-04
4,301 reads
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
2008-09-04
67 reads
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
2008-09-04
54 reads
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
2008-09-04
63 reads
Business Intelligence expert Vincent Rainardi brings us a new article that looks at how you can profile your data to understand its values and distribution using Integration Services.
2008-09-03
6,990 reads
Blogging is increasingly becoming a part of more and more people's lives. But to what extent should it be part of your corporate image? Steve Jones has a few comments about a very interesting blog he found.
2008-09-03
63 reads
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Comments posted to this topic are about the item Choose the Second One
How many types of DML triggers are there?
See possible answers