Tibor Karaszi

Send email after Agent job execution

TiborKaraszi — Wed, 28 Dec 2011 11:15:00 GMT

After executing a job, I want to have an email with the following information: Success or failure in the mail subject (not just in the body) Success or failure and execution time for each job step in mail body Have output file(s) for the job steps attached...(read more)

SQL Live Monitor

TiborKaraszi — Sat, 19 Nov 2011 08:46:00 GMT

I just found this one out there and wanted to share it. It connects to an instance and show you a bunch of figures. Nothing you can't extract yourself with SQL queries, but sometimes it is just nice to have one tool which is very easy to use. Here's what...(read more)

Who owns your jobs?

TiborKaraszi — Thu, 06 Oct 2011 16:13:00 GMT

Yep, another Agent blog. The topic of job owner has been discussed here before, but this is a specific situation, which potentially is a ticking bomb. First a quick recap of how agent does things: When a job is owned by somebody who is sysadmin, then...(read more)

Agent Alerts Management Pack updated

TiborKaraszi — Thu, 15 Sep 2011 19:13:00 GMT

I have updated the Agent Alerts Management Pack, cleaned up the T-SQL code which creates the alerts. You can now just copy, paste and execute that code. Earlier, for some of the some of the alert definitions it just generated the calls to the query result...(read more)

Ola Hallengren's maint procedures now supports logging to table

TiborKaraszi — Sat, 16 Jul 2011 01:19:00 GMT

This can for instance be very useful if you want to keep track how long time things take, over time. Check them out here .Version history here ....(read more)

Article released about moving databases

TiborKaraszi — Sun, 10 Jul 2011 13:26:00 GMT

Just a short notice that I've released an article about moving databases between SQL Server instances: You find it at http://www.karaszi.com/SQLServer/info_moving_database.asp ....(read more)

Restricting memory using Resource Governor

TiborKaraszi — Tue, 19 Apr 2011 11:13:00 GMT

You might know that Resource Governor (RG) can be used to allow you to affect resource allocation inside SQL Server. RG was introduced with SQL Server 2008 and requires Enterprise Edition or similar/higher. There are two things you can govern using RG:...(read more)

What does this Express Edition look like, anyhow?

TiborKaraszi — Thu, 10 Feb 2011 17:40:00 GMT

Chances are that you rarely get to see the Express Edition of SQL Server if you mainly work with servers. This blog post is inspired from a forum discussion where some functionality is missing in SQL Server Management Studio (SSMS) and I suspected that...(read more)

Are we Borg?

TiborKaraszi — Wed, 09 Feb 2011 20:47:00 GMT

Is it time to stop remeber things? For real, this time? Today I needed to find two pieces of SQL Server related information. One was straight foward, I posted it on #sqlhelp on twitter and a minute or so later I had the answer. The other was a bit more...(read more)

Upgrading from Express Edition to Standard Edition

TiborKaraszi — Thu, 27 Jan 2011 12:14:00 GMT

Say you encounter an SQL Server which is Express Edition, and it really should have been some higher edition. Sounds familiar? It is common for me as a consultant to find plenty of SQL Servers at a customer's site. Many of the databases in these will...(read more)

Point-in-time restore of database backup?

TiborKaraszi — Tue, 28 Dec 2010 16:42:00 GMT

SQL Server 2005 added the STOPAT option for the RESTORE DATABASE command. This sounds great - we can stop at some point in time during the database backup process was running! Or? No, we can't. Here follows some tech stuff why not, and then what the option...(read more)

Another bugfix for sp_indexinfo

TiborKaraszi — Tue, 09 Nov 2010 08:26:00 GMT

JackMcC reported correctly at http://sqlblog.com/blogs/tibor_karaszi/archive/2009/02/18/sp-indexinfo-updated.aspx that sp_indexinfo will count rows double (or even tripple) if there are lob or row overflow allocations. Now fixed. Thanks Jack....(read more)

Why we never want to trick SQL Server into rebuilding a log file

TiborKaraszi — Thu, 14 Oct 2010 17:04:00 GMT

"Never" is a strong word, so let me say that we really really want to avoid it, if at all humanly possible. In short, we will have a (potentially) broken database, both at the physical level and at the logical level. Read on. Just to be clear, when I...(read more)

New util proc: sp_tableinfo

TiborKaraszi — Sun, 10 Oct 2010 11:59:00 GMT

Some of you might use my sp_indexinfo to easily get lots of details about the indexes in a database. I added an sp_tableinfo with info rolled up to table level. This allow to quickly see the largest tables in a database and things like that. Check it...(read more)

Why can't we have column alias in ORDER BY?

TiborKaraszi — Sun, 03 Oct 2010 09:43:00 GMT

You probably think something like "What! Of course we can!". And so did I when I read the title for a post about this in a forum. Let us first establish that you can have a column alias in ORDER BY: SELECT p.ProductID AS pid , p.ListPrice AS pr FROM Production.Product...(read more)