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.
2009-04-06
9,834 reads
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.
2009-04-06
2,810 reads
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.
2009-04-06
2,583 reads
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...
2009-04-06
3,009 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-06
895 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-06
642 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-06
575 reads
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.
2009-04-05
59 reads
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.
2009-04-05
72 reads
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.
2009-04-05
52 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers