Sql-Server

Rilasciato il Cumulative Update #6 for SQL Server 2008 SP1

http://support.microsoft.com/kb/977443/en-us

Dopo l’installazione della Cumulative Update, la versione di SQL Server 2008 sarà la 10.00.2757.

Rilasciata la Cumulative Update #9 for SQL Server 2008 RTM:

http://support.microsoft.com/kb/977444/en-us

Dopo l’installazione della Cumulative Update, la versione di SQL Server 2008 sarà la 10.00.1828.

Un ottimo articolo pubblicato su Simple Talk che entra nel dettaglio delle statistiche di distribuzione dei dati usate da SQL Server per la generazione dei piani di esecuzione:

http://www.simple-talk.com/sql/t-sql-programming/13-things-you-should-know-about-statistics-and-the-query-optimizer/

Strumento per la creazione visuale di Report.

http://pebblereports.com/

Free, molto semplice da usare e con un ampio set di features:

- Tables, charts and crosstabs - Multiple sheets per report - Multiple data sources per report - Display table and chart side-by-side with same data - Conditional formatting without writing code - Full-featured graphical Query Builder; supports SQL Server and Oracle - Query builder supports editing join condition; supports building Where clause - Work directly on data (no “layout mode”) - Slice and dice data to discover trends - Drill down to see more detail - PDF, XLS and MHTML export - MHTML export compatible with Outlook and Microsoft Word - Email formatted reports as in-line HTML (as opposed to attachment) via Outlook or SMTP - On-report interactive sorting - Parameter prompting - Embed data in report, with ability to filter embedded data - Top N filter - Build complex filters with And/Or conditions - Apply style sheet - Expand All / Collapse All - Banded rows - Compact, stepped and block style display of row group headers - 16 different chart types - Charts consistent with Edward Tufte and Stephen Few principles - Performance and scalability that rivals some server-based reporting products - Calculated fields - Data displayed in controls (as opposed to paginated document) for quick browsing - Deploy report to Report Server directly - Save as RDL

Tool free per la visualizzazione dei Job di SQL Server che offre feature aggiuntive rispetto al tool nativo:

• Failures
• Long-running jobs
• Multiple jobs running simultaneously
• Zoomable rows and columns
• Predefined filters and sorts
• Tooltips for job runs, showing job name, start and end time, duration, etc.
• Colour bars to indicate job-run clashes

http://www.sqlsoft.co.uk/sqljobvis.php

In questo articolo:

windowsteamblog.com/blogs/windowslive/archive/2009/12/22/a-peek-behind-the-scenes-at-hotmail.aspx

Arthur de Haan, responsabile dei Test e del System Engineering di Windows Live, fa una breve panoramica dell’architettura di Hotmail basata su SQL Server 2008.

Alcuni punti chiave:

• We host well over 1.3 billion inboxes
• Over 350 million people are actively using Hotmail on a monthly basis
• We handle over 3 billion messages a day and filter out over 1 billion spam messages
• We are growing storage at over 2 petabytes a month
• We currently have over 155 petabytes of storage deployed (70% of storage is taken up with attachments, typically photos).

L’articolo Monitoring free space in tempdb transaction log spiega come monitorare lo spazio libero nel transaction log del database di sistema tempdb.

Una delle ragioni che ci spinge a monitorare lo spazio libero sul T-Log è la ricerca delle query che durante la loro esecuzione consumano eccessive risorse.