Tuesday, January 25, 2011
How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is almost the same question: How SQL Server stores indexes on variable length columns? Therefore I thought this would be a great topic for a weblog posting. To examine the concrete storage details of an index defined on a variable length column, I have created the following table and populated it with 80.000 records:
-- Create a new tableCREATE TABLE Customers( CustomerName VARCHAR(255) NOT NULL PRIMARY KEY, Filler CHAR(138) NOT...
.NET Web Services
Web services are small units of code built to handle a limited task.
What are Web Services?
Web services are small units of code
Web services are designed to handle a limited set of tasks
Web services use XML based communicating protocols
Web services are independent of operating systems
Web services are independent of programming languages
Web services connect people, systems and devices
Small Units of Code
Web services are small units of code designed to handle a limited set of tasks.
An example of a web service can be a small program...
5 Websites to Edit PDF files Online for free
Portable Document Format(PDF) file is a open standard format for the documents exchange. It was created by Adobe in the 90′s and now the most popular and convenient document format all around the world. There are many reasons why it is so popular. The first is it is more compact(surely smaller in size), Combines everything inside the...
20 Web Services To Send Free Fax Online without the Fax Machine
Fax is an excellent service to send and recieve important files and documents worldwide. But fax machines have always been essential for fax. Well, not anymore. There is no need to purchase an expernsive fax machine or run to local stores and copy center for faxing when you can fax online for free from home without even requiring any fax machine.
Here...