Duplicate Records using SQLCMD
We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.
The Disappearing DBA
During a "difficult period", a developer often sinks from view. When things are going well, suddenly they are the gunslinger, the hotshot. The DBA often looks on wistfully. For him, the "fame trajectory" seems to work in reverse.
Exploring SQL Server 2008’s Filtered Indexes
One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.
Handling workloads on SQL Server 2008 with Resource Governor
SQL Server 2005 resource allocation policies treat all workloads equally, and allocate shared resources as they are requested. It sometimes causes a disproportionate distribution of resources, which in turn results in uneven performance or unexpected slowdowns whereas the new Resource Governor of SQL Server 2008 allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to the end users.
LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It ended up generating a lot of good comments, always nice to see, and I'll be addressing some of those here and/or in part 3 coming up...
Managing Risk
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Managing Risk
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Managing Risk
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Manners
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
Manners
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Muara Karang Utara Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Pluit Karang Utara Blok I No.36 1. S Kav. 53, Pluit, Kecamatan...
BCA KCP Burangrang Telp/wa 085169998765
Telp/wa 085169998765 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595.Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit...
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