Browse by Tags
All Tags »
Performance (RSS)
I had two contrasting conversation about upgrade to SQL Server 2008 yesterday. A good friend of mine Darren is keen to use SQL Server 2008 for his new projects because he understands how it makes much better use of the many cores available on his new
Read More...
Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Consolidation has become synonymous with virtualization, but even hardcore VMWare addicts and VMWare themselves advise that databases are one of the last targets of a virtualisation
Read More...
Day 19 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I often get asked how much faster is SQL Server 2008 than SQL Server 2000, what impact will virtualisation have on my performance, and my answer in fine Microsoft tradition
Read More...
Day 6 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Indexed Views allow result sets to be persistent as they are materialized on physical storage which avoids performing costly joins and/or aggregations at execution time.
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
I have put Business Intelligence into a number of small businesses and these guys typically have one server set a side for BI, so how do you cram the database and the cubes into one box to get the best performance? SQL Server databases and Analysis Services
Read More...
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
Read More...
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
Read More...
With all of the BI stuff in SQL Server , the new data types like filestream and geography, it is is good to get back to basics like performance, OLTP and administration. So here’s a list of white papers for the classic DBA: Online Transaction Processing
Read More...
It is already possible to get an indication of how well SQL Server 2008 will perform before it is released as there already some TPC benchmarks published for it. The performance of Integration Services has been separately tested, as have a number
Read More...
I get more and more questions about SQL Server running in a Virtual machine so here’s 3 FAQs to start with… 1. Is there Support for SQL Server on non Microsoft Virtualization platforms (e.g.VMWare)? The definitive document on the is here . In summary
Read More...
It seems very fashionable to buy in technology these days, and some of you must if anyone is actually writing their own stuff these days. I have met quite a few of the product team and they are real people, Like Boris Baryshnikov who wrote resource governor,
Read More...
Subscribe in a reader" />
