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?
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.
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.
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.
This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008
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.
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?
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?
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?
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.
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Brigjen H Jl. Brigjend H. Hasan Basri No.26 E, Alalak Utara, Kec. Banjarmasin...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
BCA KCP Kebon Sirih Telpon/wa:0813.7887.595.Jl. Kebon Sirih No.6A Lantai 1 B, Gambir, Kecamatan Gambir,...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers