About this blog

 
About this blog
Your Name 
​SQL-Server
@Author

SQL Server 2008 Introduces Filtered Indexes

4 years ago by Randy Dyess

I have been playing around with the latest SQL Server 2008 CTP while trying to keep both my performance tuning and DBA classes updated with the latest changes. When I review new releases of SQL Server,...

@Author

Nice Little Improvement in SQL Server 2008 Management Studio

4 years ago by Randy Dyess

I know it has been awhile since I wrote my last blog and I have all the common excuses on why I have not written one in almost a month and most of them are just excuses and not really active reasons....

@Author

Review of some different ways to delete data

4 years ago by Randy Dyess

I was recently looking at some blog posts and noticed a new one out by the SQL Server CAT team titled Top 10 Best Practices for Building a Large Scale Relational Data Warehouse. This short piece has several...

@Author

Table Partitioning and Indexes (Part 2)

4 years ago by Randy Dyess

In the last post on this subject I talked about table partitioning and aligned indexes. This time I would like to discuss table partitioning and non-aligned indexes. But first I wanted to give you a little...

@Author

Table Partitioning and Indexes (Part 1)

4 years ago by Randy Dyess

As many of you know, SQL Server 2005 introduced the ability to partition data at the table level. No longer did we have to create multiple tables and tie them back together through a partition view and...

@Author

SQL Server Performance Tuning Bootcamp

4 years ago by Randy Dyess

Don't miss our SQL Server Performance Tuning Bootcamp in Dallas, TX
March 10-14, 2008

 

Register Now for this SQL Server Performance Tuning Bootcamp taught by Randy Dyess
5-Day Bootcamp only $2,700! *with...

@Author

Query Wait Option and query timeouts

4 years ago by Randy Dyess

A configuration option in SQL Server that is often overlooked or misapplied is the Query Wait configuration option. This option determines how long a query will wait for a resource (memory) with the default...

@Author

Two New Pieces Finally Published

4 years ago by Randy Dyess

I just wanted to send a quick announcement on two new pieces that I completed at the end of last year that are just now being published. One is the first of a series of 8 videos I recorded for SQL Server...

@Author

New white papers for SQL Server Magazine and DELL

4 years ago by Randy Dyess
Although it has been two weeks since my last post, I have not been on vacation. I have a few posts that will come out over the next few days, but I wanted to write up a small post to tell you that I have...
@Author

CPU Affinity Mask and Hard Binding

4 years ago by Randy Dyess

I’m going to start calling these little blog postings something like: Did You Know? Often when I go to client’s sites for performance tuning engagements, I see that they have set the Affinity Mask to...

@Author

Change SQL Server Authentication Modes

4 years ago by Randy Dyess

I know not a lot of DBAs out there have to change the authentication mode after they have installed SQL Server, but do you know that if you installed SQL Server using the Windows Authentication that you...

@Author

SQL Server 2008 Object Dependencies Video

4 years ago by Randy Dyess

While modifying Solid Quality’s DBA Bootcamp for SQL Server 2008, I begin researching object dependencies. In the past we all knew that verifying the dependencies of objects in SQL Server basically meant...

@Author

Lock Pages in Memory

4 years ago by Randy Dyess

Many of us have heard that SQL Server is not designed to use the paging file, but many people do not know that SQL Server can be paged out if there is memory pressure on the server. SQL Server will try...

@Author

Memory on Startup

4 years ago by Randy Dyess

During one of my classes I was asked how SQL Server reserves memory during its startup. I thought I would take a few minutes to describe how memory is reserved and configuration during the initialization...

@Author

Memory information through a few DMVs

4 years ago by Randy Dyess

One of my traits is that I am always trying to figure out how to get the same information in a variety of ways. When I go out to client sites to do performance assessments, often the DBAs are constrained...

12next
Follow us on: