2016-01-11
556 reads
Vinay Thakur
SQL Server 2016 – whats new…lets see
Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....
2016-01-11
428 reads
Installation SQL Server 2016
Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html
2015-12-15
975 reads
log reader uses single CPU
For replication even if you have multi core CPU it uses only one as log reader agent has single threaded...
2015-10-09
434 reads
Whats new in SQL Server 2016
While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with...
2015-07-31
1,635 reads
hey its time for 2016!!!
Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...
2015-05-29
1,212 reads
Whats New 2014
Hey all, Continue to my whats New series, I am going through its new features and the more I am...
2014-12-19
574 reads
Re-initialize replication not working
For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask...
2014-02-22
563 reads
Sql Cluster Resource not comming online
when you check on the sql server services and sql agent services it’s getting started on windows cluster but on...
2014-02-22
675 reads
TempDB Contention 2.1.%
Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of 2.1.103...
2013-10-16
743 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 Kelapa Gading Raya TLP/WA 08216977701
Jl. Boulevard Raya No.1 Blok L, Klp. Gading Tim., Kec. Klp. Gading, Jkt Utara,...
BCA KCP Teluk Mas HUB/CS 08216977701
Komplek Ruko, Jl. Soka 1 Jl. Terusan Bandengan Utara No. 95 G-H, Pejagalan, Kecamatan...
BCA KCP Kas Pusat Grosir Cililitan Hub/Wa 08216977701
Jl. Mayjen Sutoyo No. 76 Cililitan Kramat Jati (Lt .2 No. 641 Kota Adm,...
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