Updating Views
Written by Ian Treasure
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...
2011-08-03
10,134 reads
Blog Posts
August Monthly SQL Server Checklist
First day of the month and first Monday of the month. The list is coming out a bit late due...
2011-08-02
790 reads
Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions
SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...
2011-08-02
620 reads
Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings
We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...
2011-08-02
15,668 reads
Fitting In-The Editorial
This editorial I wrote ran on SQLServerCentral a couple weeks back and generated a lot of comments, and more than...
2011-08-02
302 reads
I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
556 reads
LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3
Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or...
2011-08-02
1,710 reads
Minnesota SQL Server Study Group (August)
Last month, I started using Meetup to schedule SQL Server Study Group events. The idea is to meet twice a...
2011-08-02
938 reads
PowerPivot Gallery Error Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’
Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!! What to do now? Why did you get...
2011-08-02
1,061 reads
SQL Server Functions- An Introduction
SQL FUNCTION: -
Function in a database can be defined as the code segment consisting of a logical group of SQL...
2011-08-02
2,976 reads
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 KCU THAMRIN Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta...
Cara Refund Tiket di BookCabin
Cara nya cukup menghubungi CS resmi BookCabin di nomor 082162909071 Dan Bisa melalui whatsapp...
BCA KCP Kramat Jati Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
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