2012-11-22
1,472 reads
Articles
Has tempdb grown since the last restart?
Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.
2012-11-20
8,748 reads
Performance Tuning Re-indexing and Update Statistics – A Case Study
Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.
2012-11-20
5,852 reads
Create SQL Server Analysis Services Partitions using AMO
When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.
2012-11-19
2,635 reads
SQL Saturday #179 - Kharkov, Ukraine
SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.
2012-11-19
1,559 reads
Day 7 of The OLAP Sprint
The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.
2012-11-16
1,011 reads
Generating SubTotals using GROUPING
This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.
2012-11-16 (first published: 2010-07-13)
38,131 reads
SQL Saturday #168 - Tampa BI Edition
A free day of SQL Server Business Intelligence sessions in Tampa, FL tomorrow.
2012-11-16
1,605 reads
SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance
SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.
2012-11-16
2,732 reads
2012-11-15
868 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 SUDIRMAN Telpon/WA:0821•3111•185
BCA KCU SUDIRMAN Telpon/WA:0821•3111•185 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi,...
BCA KCP Angke HUB/CS 08216977701
Jl. Pangeran Tubagus Angke No.37, Jemb. Lima, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Temanggung Telp/wa 085169998765
Telp/wa 085169998765 Jl. R. Suprapto No.21, Kauman, Temanggung II, Kec. Temanggung, Kabupaten Temanggung, Jawa...
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