Articles

SQL Server 2012 introduced an unified BI Semantic Model (BISM) which is based on some of the existing as well as some new technologies. This model is intended to serve as one model for all end user experiences for reporting, analytics, scorecards, dashboards, etc. In this tip, I will talk in detail about the new BISM, how it differs from earlier the earlier Unified Dimensional Model (UDM) and how BISM lays down a foundation for future.

2012-11-27

3,420 reads

SQL Saturday #182 - Istanbul

by Press Release

SQLServerCentral.com

SQL Saturday

SQL Saturday at the gateway between Europe and Asia. If you are nearby, come join in a free day of SQL Server training and presentations.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-11-27

1,348 reads

SQL Saturday #181 - Tokyo

by Press Release

SQLServerCentral.com

SQL Saturday

A free day of training, SQL Saturday comes to Tokyo, Japan. Come have a SQL Server day with fellow data professionals if you can.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-11-26

1,330 reads

Returning the Top X row for each group (SQL Spackle)

by Dave Ballantyne

SQLServerCentral.com

T-SQL

One of the most common T-SQL questions is on returning a ranked result set for each member of a group. Dave Ballentyne brings us a short tutorial on how you can do this in T-SQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(72)

You rated this post out of 5. Change rating

2012-11-23 (first published: 2010-12-06)

30,059 reads

Discuss

SQL Server Transaction Log Fragmentation: a Primer

by Additional Articles

SimpleTalk

T-Log

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.

2012-11-23 (first published: 2012-05-01)

7,126 reads

Happy Thanksgiving 2012

by Press Release

SQLServerCentral.com

Happy Thanksgiving from everyone at SQLServerCentral.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(13)

You rated this post out of 5. Change rating

2012-11-22

1,472 reads

Discuss

Has tempdb grown since the last restart?

by Orlando Colamatteo

SQLServerCentral.com

Administration

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(9)

You rated this post out of 5. Change rating

2012-11-20

8,748 reads

Discuss

Performance Tuning Re-indexing and Update Statistics – A Case Study

by Additional Articles

SQL Server Performance

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

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

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

by Press Release

SQLServerCentral.com

SQL Saturday

SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-11-19

1,559 reads

Articles

Understanding the SQL Server 2012 BI Semantic Model (BISM)

SQL Saturday #182 - Istanbul

SQL Saturday #181 - Tokyo

Returning the Top X row for each group (SQL Spackle)

SQL Server Transaction Log Fragmentation: a Primer

Happy Thanksgiving 2012

Has tempdb grown since the last restart?

Performance Tuning Re-indexing and Update Statistics – A Case Study

Create SQL Server Analysis Services Partitions using AMO

SQL Saturday #179 - Kharkov, Ukraine

Blogs

Overcoming Imposter Syndrome: A Plan

Advice I Like: Celebrate Success

Programmatically Retrieving MLV Lineage and Refresh Times

Forums

BCA KCP Iskandar Muda Tlpn/wa:085373737551

BCA KCP MT Haryono. Tlp:085373737845

BCA KCP Morowali Telp:Cs.08216977726

Question of the Day

Increase Deadlock Detection