In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that was set to null values, there would still be space taken up in the database. Sparse Columns introduced in SQL Server 2008, are a new type of column configuration that truly take up zero space …
Tonight I had the opportunity to present to the Bellingham .NET users group. About 30 people showed up for the presentation. SQL Server Performance Tuning and Advanced Query Tuning: This presentation will include SQL Server performance tuning tips and recommendations for both the developer and the database administrator. Topics covered will include index usage details, query tuning, understanding the …
SQL Server Performance Tuning for the Bellingham .NET users group Read more »
The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2 ^ 31 – 1 bytes or just about 2gb. Can I specify a varchar(9000) or varbinary(12000)? No. If you are going to specify an actual number instead of (max) then your limit is 8000. …
varchar(max) and varbinary(max) Questions and Answers Read more »
Cleaning up extra indexes, and implementing parameterized queries. I don’t know how many times I have had to explain the difference between a clustered index and a non-clustered index. In the end it is all good. Better performance, faster software, and happier customers.
The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server and find “sqlservr.exe” in the process list, and look at the “Mem Usage” column. But what if you are not on the server, or if you want to grab this information programmatically from an application, …
I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning on Oracle. The following is something that I have discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to …
How much Procedure Cache memory does one SQL Statement take up? Read more »
This week I started working at Emergency Reporting doing database performance tuning and scalability work. Currently this is a half time gig focused on SQL Server database performance. Fun stuff.
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL …
Since I am no longer paying for an broadcast television service (other than Netflix). Not satellite, no cable TV, and no broadcast TV. Now I am 100% internet TV, I guess I should say 100% legal internet TV.
A week or so ago I heard someone on the radio talking about Open DNS as a way to help protect children from some of the nasty sites on the internet. After using it now for about a week, I am very impressed, and I have realize that there are some very interesting features beyond just blocking bad sites. DNS …
OpenDNS Review – What a Great Site, what a great service Read more »