In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them..
2018-10-08
3,419 reads
The name of the Agent job isn't necessarily what it does, and just because your'e not getting failure emails doesn't mean the job is working.
2018-10-05
6,492 reads
In this tip we look at how to insert missing values for an identity column using the SET IDENTITY_INSERT command.
2018-10-04
2,900 reads
Azure Storage can store many types of data, from NoSQL tables to VHDs. In this article, Supriya Pande explains how to work with Azure Storage Explorer, a tool that makes it easy to manage storage in Azure. She also provides an example of using the Azure Storage .NET SDK to upload files.
2018-10-04
2,593 reads
In this tip look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
2018-10-03
2,545 reads
Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics.
2018-10-02
3,526 reads
Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares
2018-10-01
2,535 reads
In this tip we look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
2018-10-01
2,109 reads
If someone says clustered indexes slow you down, they haven't read this.
2018-09-28
2,418 reads
In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.
2018-09-28
3,220 reads
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...
Cara buka blokir Bank Permata (rekening/ATM/mobile) dapat dilakukan melalui PermataTel di 1500-111, whatsapp, 0821"...
Kompleks Perkantoran Pettarani, Jl. AP. Pettarani No.18, Tamamaung, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan...
BCA KCP Senen Telpon/wa:0813.7887.595.Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....
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