Community Server for Rent a Coder

How Software Gets Done

Welcome to Community Server for Rent a Coder Sign in | Join | Help

Home

Blogs

Real Life Microsoft IT

Systems (RSS)

SQL Server 2005: The new "missing indexes" feature

There is an interesting and useful new feature in SQL 2005 where it takes all queries that execute and don't find an optimal index...and records the information. You can use this information to generate indexes and speed up your performance. Read More

posted Thursday, May 11, 2006 4:33 PM by admin | 0 Comments
Filed Under: Systems

How SQL Server 2005 "Forced Parameterization" cut ad-hoc query CPU usage by 85%

Is it my imagination or is SQL 2005 running slower?My first impresson with SQL Server 2005 came after installing it on a test server. The test server is a dual processor machine...which was a pretty high powered box back in it's hey-day, Read More

posted Sunday, April 30, 2006 8:11 PM by admin | 0 Comments
Filed Under: Systems

A "must use" SQL Server 2005 Feature-ROW_NUMBER()

If you run your SQL Server as the back end for a website, then paging is one of the most common things that you do. In SQL Server 2000, doing this paging was complicated and resource intensive. But in 2005, there is a new feature called Read More

posted Saturday, April 29, 2006 11:30 AM by admin | 1 Comments
Filed Under: Systems

SQL Server 2005 performance testing with hyperthreading and MAX DOP

There's been alot of negative publicity about hyperthreading (see "Hyperthreading hurts server performance, say developers" which is all over the net...including: http://news.zdnet.co.uk/0,39020330,39237341,00.htm) We had been experiencing disapointing Read More

posted Tuesday, April 18, 2006 11:20 PM by admin | 1 Comments
Filed Under: Systems

Classic ASP: Not ready for prime-time?

There is a VERY bad problem with Active Server Pages (ASP...or what is sometimes known as "classic ASP") which prevents it from being a viable system on which to build a "big IT" project. For 2 years we've been fighting a problem in which Read More

posted Sunday, March 19, 2006 11:56 AM by admin | 4 Comments
Filed Under: Systems

SQL Server 2005: Are your batteries half full or half empty?

Microsoft is running an ad campaign showing skyscraper sized batteries labeled "SQL Server 2005" plugged into enormous buildings. The message is obviously that this database is designed for big companies and serious mission critical systems. Read More

posted Friday, March 17, 2006 8:21 PM by admin | 0 Comments
Filed Under: Systems

Beware the Ides of ISA Service Pack 2 (SP2)

I've confirmed that the SendAcceptEncodingHeader metabase setting that USED to work pre ISA (Internet Security and Acceleration Server) SP2 and allowed IIS to pass through the compression headers for gzip, is no longer working with SP2 (and Read More

posted Friday, March 17, 2006 8:18 PM by admin | 0 Comments
Filed Under: Systems

This Blog

Post Calendar

November 2008

Post Categories

Systems (7)

Syndication

Powered by Community Server, by Telligent Systems