Occasionally I come across UPDATE and DELETE statements where the target SQL Server table is referenced with the NOLOCK hint. Does this hint help or hurt performance in this case?
2014-03-03
4,698 reads
SQL Saturday is coming to Exeter on March 22, 2014. Join Red Gate's David Atkinson and the rest of the speakers at this free day of SQL Server training and networking, organized by SQL South West.
2014-03-03
1,737 reads
Come see Grant Fritchey and Steve Jones (from Red Gate Software) and many more SQL Server experts while you enjoy spring in Orlando, FL at SQL Intersection.
2014-02-28
408 reads
There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a number of techniques around that work, but finding ones that scale well makes for a tougher, but interesting, challenge.
2014-02-28
3,824 reads
This article will help us identify the backup which was used to restore the database. This may seem simple when the database backup is from the same server but the complications begin when the backup is not from the same server.
2014-02-27
4,515 reads
In this tip, Sadequl Hussain will try to list a few areas DBAs need to cover when they are designing new systems or reviewing proposed solutions.
2014-02-27
5,421 reads
Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren't there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They're great in certain circumstances but they represent a trade-off, and they come with considerable 'small print'. Jes Borland explains.
2014-02-26
4,674 reads
The day before SQL Saturday Silicon Valley, SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on March 14 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
2014-02-25
1,782 reads
A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.
2014-02-25
3,416 reads
sp_ExecuteSQL can be used to dynamically execute T-SQL code. Learn how to use it and how to add parameters to control what code is executed.
2014-02-24
10,557 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...
BCA KCU SUDIRMAN Telpon/WA:0821•3111•185 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi,...
Jl. Pangeran Tubagus Angke No.37, Jemb. Lima, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
Telp/wa 085169998765 Jl. R. Suprapto No.21, Kauman, Temanggung II, Kec. Temanggung, Kabupaten Temanggung, Jawa...
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