Browse by Tags

Analysis Services Performance Guide

Vi segnalo un white paper sulle tecniche di performance-tuning applicabili su Sql Server 2008 Analysis Services. Il documento è scaricabile qui .

Posted to External News (Weblog) by Anonymous on 11-17-2008
SQL Server 2008 Plan Guides

So here’s how it’s done.. So here’s how it’s done..I rarely know more about SQL Server than my friend Beatrice so I was surprised when I mentioned plan guides and she hadn’t heard of this new feature. I have to say this is not a big mainstream thing and it takes me back query hints in SQL Server 2000...

Posted to External News (Weblog) by Anonymous on 11-14-2008
SQL Server 2008 supports how many cores?

I often say that a database is only as good as the system it is running on. For example SQL Server supports 64 cores (as opposed to CPUs) because that is the limit in Windows Server, even in Windows Server 2008. However if you have been at PDC or TechEd in Barcelona (where I am writing this...

Posted to External News (Weblog) by Anonymous on 11-07-2008
SQL Server 2008 Notification Services

Notification services is one of the deprecated features in SQL Server 2008, essentially it is supported for now but will not be in the next release of SQL Server. If you are using notification services currently and you are looking to upgrade to SQL Server 2008 then you can get it from here . But why...

Posted to External News (Weblog) by Anonymous on 10-21-2008
Virtualizing SQL Server 2008

Those of you at last months SQL Server unleashed events may remember Prem Maher form the SQL Customer Advisory Team ( SQLCAT ), talking about a whitepaper on virtualizing SQL Server, well it’s finally out and available here This white paper, unlike some I have read, is a really deep study on the...

Posted to External News (Weblog) by Anonymous on 10-10-2008
SQL Server 2008 Management event in Manchester

Unlike Manchester United, SQL Server 2008 is under new management. What I mean by this is that there are a load of new tools to configure, tune and audit which are essential to keep a modern database in the premiership. While I have done a few events on this theme in the London area, the TechNet...

Posted to External News (Weblog) by Anonymous on 09-29-2008
SQL Server 2008 disponível no Brasil

Ontem foi anunciada a disponibilidade da versão RTM do SQL Server 2008 ! O SQL Server 2008 traz uma leva de novidades: governança e compressão de dados, suporte para dados geo-espaciais, gerenciamento baseado em políticas, relatórios avançados e serviços de análise. O produto estará disponível nas seguintes...

Posted to External News (Weblog) by Anonymous on 08-07-2008
Direto do TechEd em Orlando: Performance Monitoring usando SQL Server Management Studio (por Daniel Camillo)

Microsoft SQL Server 2008: Performance Monitoring Using SQL Server Management Studio Essa foi mais uma sessão muito boa que tivemos aqui no TechEd North America 2008 em Orlando, nesta sessão foi abordado como momitorar o SQL Server 2008 através do Management Studio. Como o SQL Server Management Studio...

Posted to External News (Weblog) by Anonymous on 06-16-2008
SQL Server 2008 Filtered Indexes vs Index Views

SQL Server 2008 has a new feature called filtered indexes which are like normal table indexes only they have a simple where clause, meaning that the index will only cover rows specified in the where clause. As I have mentioned before an obvious example is where you can filter out nulls and still...

Posted to External News (Weblog) by Anonymous on 05-22-2008
Primary keys and Clustered Indexes

One of the many great SQL Server resources out there is SQL Server Central , and this article on there, Worst Practices - Not Using Primary Keys and Clustered Indexes , by Andy Warren caught my eye. For the most part he’s absolutely right you’d be mad not to have a primary key on a table and to...

Posted to External News (Weblog) by Anonymous on 05-11-2008

Page 1 of 2 (13 items) 1 2 Next >