Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2010

SQL Source Control Early Access Program Open

Managing T-SQL source code has never been easy, and has often been the bane for many T-SQL developers. Later this year, this problem will go away as Red Gate Software introduces its new SQL Source Control software, which allows T-SQL code to be managed under source control, while working directly… Read more

0 comments, 201 reads

Posted in SQL Aloha on 28 January 2010

Are You Running the x86 Version of SQL Server 2005/2008?

If so why?  Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008, or 2008 R2 in a production environment.  I have been advocating that people use 64-bit versions of SQL Server 2005 and above for some time now. NewsGator’s production SQL Server… Read more

27 comments, 1,098 reads

Posted in Glenn Berry's SQL Server Performance on 28 January 2010

The Predictioneer

I’m not sure how this book got on my radar, but it turned out to be fairly interesting. It’s written by a professor at Harvard that uses Game Theory and readily available information about the world to both predict what will happen in a general sense, and to guide his…

Read more

1 comments, 215 reads

Posted in The Voice of the DBA on 28 January 2010

SQLSaturday #40 Announced

SQLSaturday #40 will be held July 31st, 2010 in Miramar, FL. This is the second annual SQLSaturday organized by Scott Klein and Herve Roggero. Great area to visit! Call for speakers is open.

Read more

0 comments, 155 reads

Posted in SQLAndy on 28 January 2010

SQLSaturday #39 Announced

SQLSaturday #39 will be held April 24, 2010 and is being coordinated by Melissa Demsak and others from the NJ SQL Group. Registration and call for speakers and sponsors is  now open!

Read more

0 comments, 173 reads

Posted in SQLAndy on 28 January 2010

The Little Stick

In the end, that was what made the difference. I was typing along one night on my spare Acer and the cursor kept jumping. I was getting too close to the touchpad, and it kept picking up my hands, jumping the cursor. I type rapidly, and it kept causing me… Read more

2 comments, 211 reads

Posted in The Voice of the DBA on 28 January 2010

What the Exec?

I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used 2008 personally.  I know I haven’t seen everything, but a couple of weeks ago a friend of mine asked me to look at some stored procedures he was working…

Read more

8 comments, 161 reads

Posted in Wise Man or Wise Guy on 28 January 2010

IN and NOT IN

One of the most common mistakes made in T-SQL is thinking that these behave identically.  I've personally opened up a forum topic on it because I didn't know what the difference was.  This post will join a small army of other places on the net devoted to correcting this misunderstanding.… Read more

15 comments, 362 reads

Posted in Never Say Never on 28 January 2010

The Black Art of PowerShell V2 Version Numbers

Last week while helping someone in the SQLPSX forums having an issue importing modules I suspected they had a CTP version of Powershell, but being the skeptical person I am I needed proof. My first thought was there must be a simple built-in command to return the Powershell version number.…

Read more

0 comments, 211 reads

Posted in Chad Miller on 28 January 2010

SQL Search 1.0 Beta Available

Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you to easily search for “text strings”, allowing you to quickly find objects stored within a SQL Server instance.

For example, if you want to find all of the objects… Read more

4 comments, 556 reads

Posted in SQL Aloha on 28 January 2010

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 first WHERE clause below can use an Index seek

Where LastName like ‘[a-z]%ent’ can use an index

This second statement will not be able to use a seek…

Read more

0 comments, 186 reads

Posted in The SQL DBA in the UK on 27 January 2010

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 more interesting things that I see people assuming is that an identity value will ensure you have a continuous range of values for that column. They assume that this code:

Read more

4 comments, 208 reads

Posted in The Voice of the DBA on 27 January 2010

SQL Saturday #34


The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a great opportunity to learn about SQL Server and things around SQL Server. If you’re in the New England area, please register and take advantage of this excellent event. 450 of…

Read more

0 comments, 184 reads

Posted in The Scary DBA on 27 January 2010

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 7:00 PM EST. My topic will be SQL Server Locking and Blocking Made Simple. In it, I will discuss:

  • The need for locking
  • The consequences of blocking
  • How SQL Server…

Read more

0 comments, 117 reads

Posted in Joe Webb on 27 January 2010

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 question is “How can i clear this rubbish out ?”.  On 2008 its simple enough, Microsoft have kindly enhanced DBCC FREEPROCCACHE to accept a plan_handle.  On 2005 things are… Read more

0 comments, 405 reads

Posted in Dave Ballantynes blog on 27 January 2010

Lenovo W510

I finally ordered a new laptop, a Lenovo W510, that caught my eye. I was thinking the T series 510, but once I added a few things it was the same price as the W510, but had 2 fewer cores. Since I do a decent amount of video stuff,… Read more

0 comments, 261 reads

Posted in The Voice of the DBA on 27 January 2010

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 dynamic.  When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code. 

For example, a common reason you… Read more

0 comments, 341 reads

Posted in Devin Knight on 27 January 2010

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 dynamic.  When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code. 

For example, a common…

Read more

1 comments, 748 reads

Posted in Devin Knight on 27 January 2010

What Three Events Brought You Here?

Whiners and Whingers Get Wedgies

Yes, I deserve a Wedgie

There I was, just a couple weeks back, whining that I wasn’t getting tagged by friends when a new meme comes out.  Sure enough, when my friend, Paul Randal (blog | twitter), starts a new meme with me… Read more

0 comments, 182 reads

Posted in Kevin E. Kline on 27 January 2010

SQLFool IDX Defrag Scripts

I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts.  Right now she is looking for Beta testers.  Anybody that is interested could find more info at:

http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/

Read more

0 comments, 322 reads

Posted in SQL RNNR on 26 January 2010

Newer posts

Older posts