My two cents

Which queries are missing indexes?

leo.pasta — Thu, 08 May 2008 20:48:28 GMT

One of the things I really enjoy when doing performance tuning on 2005 (I still work on a mix of several SQL 2000 and some SQL 2005) is the sys.dm_db_missing_index* DMVs. As the query processor evaluates queries, it detects if that specific query could...(read more)

SQLBits

leo.pasta — Sun, 02 Mar 2008 21:47:24 GMT

Yesterday I attended the SQL Server focused conference called SQLBits , which this year took place in Birmingham. First of all, many thanks to Tony Rogerson , Simon Sabin and all organisers. You did a hell of a good job!!! As a suggestion for the next...(read more)

Data purity

leo.pasta — Mon, 26 Nov 2007 22:39:41 GMT

Reviewing DBCC CHECKDB syntax for SQL Server 2005, I found a [DATA_PURITY] option added to its syntax. This option enable the following checks on each column value of those datatypes: Unicode character - The data length should be a multiple of 2. Datetime...(read more)

Losing your Transaction log

leo.pasta — Tue, 20 Nov 2007 00:17:50 GMT

Technorati Tags: SQL Server , Recovery Some days ago, my boss got on my desk asking if I could take a look at one database that was not opening. That DB was in a virtual machine used for our sales presentations. For some reason, several files got corrupted...(read more)

The sound of silence

leo.pasta — Thu, 06 Sep 2007 22:14:01 GMT

This one isn't related to SQL Server. But do you know when sometimes you get stuck in an almost infinite loop of dialog boxes and for some reason you don't want to kill the application? "Sorry <beep> guys, this <beep> should <beep> end...(read more)

Page splits

leo.pasta — Mon, 13 Aug 2007 20:36:07 GMT

These days, investigating a fairly simple insert which was taking longer than what I would consider reasonable for that particular piece of code, I explored several possible causes. One thing that raised my attention was that the "Pages split/sec" perfmon...(read more)

Database CCTV*

leo.pasta — Tue, 10 Jul 2007 21:21:00 GMT

* CCTV - Closed Circuit Television. Widely used in UK (and for sure in many other parts of the globe) to monitor against social misbehavior. Policy Manager A policy manager is one important piece in the centralized administration puzzle. The general idea...(read more)

Instant gratification

leo.pasta — Mon, 02 Jul 2007 23:14:49 GMT

I expected that my first “real” post would be about one of the features that had more appeal to me on SQL Server Katmai, but I will have to post about a discovery that was so useful to me, and yet so basic that I am almost ashamed to have found it only...(read more)

Getting on board

leo.pasta — Mon, 25 Jun 2007 22:50:00 GMT

Ok, I confess, I always wanted to be part of the blog community, but I have never found a compelling reason to fight the inertia and start blogging. But after Tony Rogerson invitation on http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/22/sqlblogsters...(read more)