Rob Pellicaan

SQL: Removing a specific plan from the procedure cache

Source: http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!2952.entry Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some sort of a scary warning about how...

Published 27-01-2010 11:00 by robp

SQL Server developers factsheet

A colleague pointed me to a nice cheat sheet for SQL Server developers. It contains: - A checklist for writing fast queries - Sargability of queries - A checklist for creating indexes - A legend of the 'Execution Plan Icons', including some optimizing...

Published 26-01-2010 14:35 by robp

Installation of SharePoint 2010 with PowerPivot on a single server.

I took me a couple of hours of research, waiting and clicking, but I have successfully been able to install the public beta of Sharepoint 2010 with the SQL Server 2008 R2 November CTP with PowerPivot for Sharepoint Server 2010 on a single VM. This is...

Published 25-11-2009 0:05 by robp

SQL Server MVP Deep Dives - Something for your Christmas wish list ?

I just purchased this book to have something to read during my 44 hours in airplanes for a 4 week Christmas holiday in New Zealand. The book –written for charity - contains content from 53 MVPs with Paul Nielsen , Kalen Delaney , Greg Low , Adam Machanic...

Published 24-11-2009 16:26 by robp

Auto-create your Installation manual with the Problem Steps Recorder

I saw someone from Microsoft demonstrate a very cool feature included in Windows 7 and Windows Server 2008 R2. It is called the Problem Steps Recorder. You can launch it by running psr.exe. I find it very useful not for problem reporting, but for documenting...

Published 24-11-2009 16:09 by robp

Some Ways To Look For Things in SQL Server Modules

Quote from http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!2218.entry : If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it can sometimes be difficult to keep track of...

Published 24-11-2009 15:25 by robp

How to disable Time sync on a VirtualBox VM

I wanted to start looking at the new SQL2008 R2 November CTP and decided that I would go for a installation on Windows Server 2008 R2 on a VM. Since I am running Windows 7, Hyper-V is not an option and Microsoft has let us down by still not providing...

Published 12-11-2009 11:19 by robp

Filed under: Time Sync, Trial Software, VirtualBox

Replacing * with column names the easy way

Just open Object Explorer, expand the table or view name, click on the "Columns" node and drag it onto the query window: Thanks goes out to Aaron Bertrand for posting this trick on his blog: http://sqlblog.com/blogs/aaron_bertrand/archive...

Published 11-11-2009 12:11 by robp

Where did that money go?

This might be something most developers are already aware of, but I have been familiar with SQL Server mostly as a DBA, not actively busy with the meaning of data and it therefore came as a complete surprise to me. Question: How much is $1/$345, rounded...

Published 11-11-2009 11:23 by robp

SQL SERVER – 2008 – SCOPE_IDENTITY() and @@IDENTITY Bug with Multi Processor Parallel Plan

When a parallel plan is executed SCOPE_IDENTITY or IDENTITY may produce inconsistent results. The bug is active in SQL Server 2008 and any earlier version. See http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=328811 N.B. ...

Published 10-11-2009 14:23 by robp

Filtered Indexes

One of the cool new features of SQL 2008 is Filtered Indexes. A Filtered Index allows you to create an index on just a subset of data, using a filtering predicate. The reduction in index storage space can be significant. For example, the AdventureWorks...

Published 10-11-2009 11:24 by robp

Bad Habits to Kick (T-SQL best practices)

I am currently busy reviewing and updating the internal programming guidelines and best practices for SQL Server programming. While looking on the net for other opinions on subjects, I came across a nice set of articles on best practices from Aaron Bertrand...

Published 10-11-2009 8:07 by robp

SSIS: Set "work-offline" without opening the project

If you’ve done much work with SSIS, you’re probably aware that on opening a package in BIDS, SSIS validates all the objects in the package. This can cause the packages to open very slowly, particularly if it has connections to a database that...

Published 22-10-2009 13:53 by robp

Filed under: SQL, SSIS

What’s your personality type?

Knowing your own strengths and weaknesses can really help in both work and private live, especially if you also know the personality type of the other people your dealing with. Certain personalities can clash if they don’t recognize and respect each others...

Published 30-09-2009 0:38 by robp

SQL Core team visited SQLPASS NL meeting

Yesterday I visited another SQLPASS NL meeting. This time we had a session with the SQLCAT team who brought with them 2 members of the SQL Core development team. The purpose of the meeting was for the team to get feedback on the issues that there are...

Published 18-09-2009 9:07 by robp

Syndication

Recent Posts

Tags

Archives