I've just released version 1.2-20091123 of SQL Server Compressed Backup which can be downloaded here.
SQL Server Compressed Backup will back up SQL Server databases using either gzip, zip or bzip2 compression.
The new features are:
Read the rest of this entry »
Bill Galashan, DBA of bet365 sent over the following query that lists the execution plan of the 10 most frequently executed queries.
He writes:
We got into this due to different query plans coming from a VB or a web app than what was seen when running the same query from Management Studio. Eventually tracked this down to a difference in the set options predominatley whether Arithabort was on or off.
Read more to see his query. Read the rest of this entry »
Tags: dynamic management views, execution plan, SQL Server 2005, SQL Server 2008, SQL Server Administration, SQL Server Engine
I've just released version 1.0 of MSSQL Compressed Backup. This is a command line utility that allows you to backup or restore your SQL Server 2005 databases to/from compressed files such as zip, bzip2, or gzip.
Below are a collection of links on how to rename a SQL Server server.
Rename the SQL Server engine. This describes how to run
sp_dropserver 'old_name' go sp_addserver 'new_name', 'local' go
Rename SQL Server Reporting Services server. This describes how to update a config file with the new server name.
Correct an issue with SQL Server SP2 and Sysprep. This is needed when you run sysprep to rename the machine. The short of it is you will need to delete some registry entries.
I've been working on a way to backup SQL Server 2005 databases to a compressed file recently, but without using temporary files. I recently found that it is actually pretty easy. SQL Server has an interface for creating a virtual backup device so that the data is pumped to your application, not a real device. Once the application has the data, it can compress it, encrypt it, or do whatever it likes. Maybe DBAs would like to save the data to an FTP server. There are so many options.
The application I wrote is called MSQL Compressed Backup which you can find on Sourceforge. It is currently in beta, and I don't plan to release a 1.0 version for awhile until it has had some testing by other people. If you are interested in it, please download a copy and give it a try.
Documentation is currently lacking, but here are a couple of examples. I think they are self explanatory.
I have been working on a performance problem recently, so you might see several blog entries with information that help me. Hopefully they will help you.
Update: Here is a query to get the execution plan of the most frequently used queries.
Getting the SQL Server execution plan from a production can be difficult, since you are not running the code within Enterprise Manager. You can still get the execution plan of any running statement and display the graphical representation in Enterprise Manager. Read the rest of this entry »
Tags: dynamic management views, execution plan, performance, SQL Server 2005, SQL Server 2008, SQL Server Administration, SQL Server Engine
Arclite theme by digitalnature | powered by WordPress