Wildcards in WHERE Clauses

This is just a very short post regarding the use of wildcards in a WHERE Clause

It is possible that the...

Identity Values – Dropouts and Spaces

Identity values are very useful, but there can be misconceptions about the way in which they work. One of the...

SQL Saturday #34

The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...

Speaking at the Baltimore SQL Server User Group

On Monday, the first of February, 2010, I will be speaking at the Baltimore SQL Server User Group meeting at...

Cleaning up sys.dm_exec_cached_plans

Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...

Lenovo W510

I finally ordered a new laptop, a Lenovo W510, that caught my eye. I was thinking the T series 510,...

Handling Escape Sequences in SSIS Expression String Literals

The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...

Handling Escape Sequences in SSIS Expression String Literals

The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...

SQLFool IDX Defrag Scripts

I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts.  Right now she is looking for...

Updating a column

Hi,
I have a table name CustUsers. In this table, there is a field name: PWD
I have refreshed the production database...