Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

All Blogs

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

Authors

Search

XML Feeds

Google Ads

Tags: sql server 2008

comments
Rate Post:
submit to reddit Digg!FacebookDotnetkicks

I wanted to start writing a series of blogs on mirroring to share what I’ve learned over the years and since SQL Server 2005 gave us this feature. Before we go into that I want to go over the operating modes that we have in mirroring. We have two operating modes, Asynchronous and synchronous. The first major key is Asynchronous operating mode is only available in Enterprise Edition (and Developer).

Read More...
comments
Rate Post:
submit to reddit Digg!FacebookDotnetkicks

If you are using snapshots be aware that running sp_helpdb reports wrong files. Let's take a look by running some code

First create a test database

tsql Sample Code (See Article for Rest)
Read More...
comments
Rate Post:
submit to reddit Digg!FacebookDotnetkicks

Here is something interesting to think about

Create this table and insert these 2 rows

tsql Sample Code (See Article for Rest)
Read More...
comments
Rate Post:
submit to reddit Digg!FacebookDotnetkicks

To me it seems that Visual Studio Team System 2008 Database Edition is the stepchild of the Visual Studio family. Even in shops that have MSDN Universal/Ultimate subscriptions this version is just not used that much. Maybe it is that long name of this product, I still prefer DataDude. I would like to show you that if you do have licenses for this tool then you should use it because it has some great features. Today we will focus on static code analysis.

Before we start, make sure to grab Microsoft Visual Studio Team System 2008 Database Edition GDR R2

and install that on top o...

Read More...
comments
Rate Post:
submit to reddit Digg!FacebookDotnetkicks

In order to figure out if you need more memory for a SQL Server you can start by taking a look at Buffer cache hit ratio and Page life expectancy.

Buffer cache hit ratio

Here is what Books On Line has to say about Buffer cache hit ratio

Buffer cache hit ratio

Percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups over the last few thousand page accesses. After a long period of time, the ratio moves very little. Because reading from the cache is m...

Read More...

:: Next >>