Carpe Datum
Data Flotsam and Jetsam
Browse by Tags
All Tags
»
Performance Tuning
(RSS)
Administration
DBA
Design
Developer
Development
Encryption
Indexes
Maintenance
Management
Metadata
Scripts
Security
SQL Server
SQL Server 2008
Tips
T-SQL
Fixed Cycle Applications
26 September 08 06:30 AM
|
Buck Woody
|
1 Comments
I was working with someone last night on some performance tuning and noticed that they didn't have a specific issue that was causing their system to slow down - it was a combination of things. As we were working, I found a bunch of things that were running
Read More...
The Quickest Route to a Custom Collector
24 September 08 06:30 AM
|
Buck Woody
|
1 Comments
The Data Collector feature in SQL Server 2008 is a new way to automate the gathering of any data from SQL Server you want to store historically. Combine that with the Management Data Warehouse and Custom reports, and you have a powerful monitoring and
Read More...
Time-based Optimization
14 March 08 09:02 AM
|
Buck Woody
|
0 Comments
One of the primary jobs of both developers and DBAs is optimization, or its more common name, performance tuning. Lots of the management tools improvements for SQL Server 2008 are aimed at performance, such as the new activity Monitor. Using the tools
Read More...
Speeding up encryption
27 August 07 08:18 AM
|
Buck Woody
|
2 Comments
A friend of mine from Tampa, Florida wrote me the other day with an interesting observation: "I have a small finding and don't know where to publish it. Maybe you can help get the word out via your blog? OPEN SYMMETRIC KEY is somewhat costly to execute.
Read More...
Index Overlaps
21 August 07 10:32 AM
|
Buck Woody
|
0 Comments
There are a lot of tools in SQL Server 2005 that will help you with indexes, from enhanced plan diagrams to the Database Tuning Advisor. But I was scouting around this morning for a script that would find places where I had indexes that included duplicate
Read More...
Search
Go
This Blog
Home
About
Email
Tags
Administration
Career
Computing
Conferences
Connections
Customer Contact
DBA
Design
Developer
Development
Documentation
Downloads
Encryption
Error Codes
Help
Indexes
Latest Version
Links
Locks
Longhorn
Maintenance
Maintenance Plans
Management
Metadata
Microsoft
Microsoft Update
MSDN
PASS
PBM
Performance Tuning
Personal
Planning
Podcast
PowerShell
Process
Questions
Quote Of The Day
Rant
Real World DBA
SCOM
Scripts
Searching
Security
SQL Server
SQL Server 2000
SQL Server 2008
SQL Server Documentation
SQL Server Downloads
SQL Server Management Studio
SQL Server Server
SSIS
SSMS
Standard Reports
Strings
Support
System Center Operations Manager
Technet
Testing
Tips
T-SQL
Tutorials
Upgrades
Walkthroughs
Web
Windows 2008
Archives
October 2008 (3)
September 2008 (22)
August 2008 (22)
July 2008 (21)
June 2008 (21)
May 2008 (21)
April 2008 (25)
March 2008 (23)
February 2008 (22)
January 2008 (21)
December 2007 (15)
November 2007 (18)
October 2007 (23)
September 2007 (21)
August 2007 (21)
July 2007 (1)
June 2007 (3)
May 2007 (3)
April 2007 (3)
March 2007 (2)
February 2007 (3)
Syndication
RSS 2.0
Atom 1.0
Having trouble with a feed from this site? Post a reply to any blog entry.