Microsoft BI Metadata Toolkit

Some of you may have visited the link to Microsoft’s whitepaper on the BI Metadata Toolkit only to find the referenced samples download link is not working. Many of us have always had a copy of the whitepaper, but not the samples download. We’ve received that missing download and are sharing it here. The folks […]

Read more
SQL Server 2008 – New table/column limits

Here are some new*, upgraded limits as they apply to tables in SQL Server 2008: Column limit per base table: 30,000 columns, which is up from 1,024 columns Index limit: 1,000 indexes, which is up from 249 Statistics limit: 30,000 statistics, which is up from 2,000 These limits are still bound to the row size […]

Read more
SQL Server 2008 Upcoming Features/Additions

Here are some highlights of things that will be offered with SQL Server 2008: Activity Monitor for the DBA: Finally a way to see, in an easy to use UI, information related to active sessions, wait states, file I/O, long running queries, etc… Oh, and you can launch Profiler from here as well. Object Search: […]

Read more