Tag Archives: sql server

Baselines

Posted on February 1, 2013 by way0utwest

You come into work one day and as you sit down, your phone rings. It’s one of the business groups complaining that the database is running slow. You check the server and find CPU at 80%, 800 pages/sec, disk IOps … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Granting Permission to Grant Permissions

Posted on January 28, 2013 by way0utwest

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users. It’s not a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Granting Permission to Grant Permissions

Still 32

Posted on January 28, 2013 by way0utwest

I was listening to a presentation recently and the presenter talked about some of the restrictions in working with 32 bit SQL Server on 64 bit Windows hosts. Another person joked that any companies still running 32 bit software were … Continue reading →

Posted in Editorial | Tagged | 2 Comments

If You Need To Fix Database Filename Extensions

Posted on January 24, 2013 by way0utwest

In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however, and you might wish to “fix” the filenames to conform to the proper extension. How can you do this? Well, … Continue reading →

Posted in Blog | Tagged , , | 1 Comment