Understanding SQL Server Full-text Indexing – (Part 2)
Checkout the final part of this two part article series here, in which I discussed how to create full-text index...
2013-09-17
541 reads
Basit's SQL Server Tips
Understanding SQL Server Full-text Indexing – (Part 1)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-09-17
640 reads
Up or out? Deciding on SQL Server scalability
Scalability is the ability of a system to support an increased workload by adding incremental system resources without fundamentally changing...
2013-08-06
555 reads
SQL Server upgrade paths: What to do before, during, after upgrading
Creating SQL Server upgrade paths from one version to another is a task that every database administrator is eager to...
2013-08-06
757 reads
Guide to SQL Server Table Indexes (Part 3)
Checkout the part-3 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-08-06
552 reads
Guide to SQL Server Table Indexes (Part 2)
Checkout the part-2 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-08-06
529 reads
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-08-06
933 reads
Understanding Data Normalization
Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases....
2013-08-06
555 reads
Guide to SQL Server Table Indexes (Part 1)
One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with...
2013-07-15
1,381 reads
Understanding SQL Server Query Optimization Statistics
SQL Server query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer...
2013-07-15
1,515 reads
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 Permata Ujung Menteng Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota Jakarta...
BCA KCP Sejati Mulia Telpon/wa:0813.7887.595
BCA KCP Sejati Mulia Telpon/wa:0813.7887.595.Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, Jati Padang,...
BCA KCP Pulogadung Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo Gadung, Kota Jakarta...
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