SQL Q&A: Non-Clustered Indexes and Retaining Permissions
Q What are non-clustered indexes, and what are the pros and cons of using them?
Locking Down DTS
There's no security role to prevent or allow users to creating DTS Packages. Find out how to lock down DTS on your system.
Renaming a SQL Server
Renaming a server can be a mystery in SQL Server. The symtoms that SQL Server displays after you rename a server makes it look like you made a bad mistake.
The ARRAY In SQL Server 2000
SQL Server 2000 and Transact-SQL have many features, but one of the most often asked for features has been the implementation of some sort of array data type. This basic programming concept is notably absent from the development platform and results in many headaches and frustrations for DBAs. New author Alex Grinberg brings us his techniques for simulating arrays in SQL Server 2000.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Duta Merlin Tlp/Wa 08216977701
Komp. Duta Merlin Blok A No. 24-25, Jl. Gajah Mada No.3-5, Daerah Khusus Ibukota...
CS FINANCE CIPUTAT Hub.0821•3111•185
CS FINANCE CIPUTAT Hub.0821•3111•185 Jalan R.E. Martadinata.27, Jl. RE Martadinata No.27, Cipayung, Kec. Ciputat,...
BCA KCP Boulevard Timur Tlp/Wa 08216977701
Jl. Boulevard Timur No.54-55 Blok NC 1, Pegangsaan Dua, Kec. Klp. Gading, Jkt Utara,...
Question of the Day
Creating a JSON Document III
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