TakeNote... - SQL Server

Posts: 252
Comments: 466
Trackbacks: 17

SQL Server

Just reminder of a post I wrote back in December. Don’t forget that there is a variety of free ebooks available for download on a number of different developer and IT topics. Developer subjects include Programming Windows Phone 7, Moving to Visual Studio 2010, and Introducing SQL Server 2008 R2. IT topics include Deploying Windows 7, Understanding Microsoft Virtualization Solutions and First Look at Office 2010 just to name a few. Have a day...

Share This Post:

Posted On Monday, May 23, 2011 9:46 AM | Feedback (0)

Free eBooks from Microsoft–We like free!

In a recent blog post I mentioned the availability of the Programming Windows Phone 7 ebook by Charles Petzold. Well I have good news, there are a number of additional FREE ebooks available from Microsoft to help you continue honing your tech skills. Moving to Microsoft Visual Studio 2010 Introducing Microsoft SQL Server 2008 R2 Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft Understanding Microsoft Virtualization Solutions (Second Edition) First Look Microsoft...

Share This Post:

Posted On Tuesday, December 07, 2010 9:03 AM | Feedback (0)

Unexpected SQL Server 2008 Performance Tip: Avoid local variables in WHERE clause

Sometimes an application needs to have every last drop of performance it can get, others not so much. We’re in the process of converting some legacy Visual FoxPro data into SQL Server 2008 for an application and ran into a situation that required some performance tweaking. I figured the Making Microsoft SQL Server 2008 Fly session that Yavor Angelov (SQL Server Program Manager – Query Processing) presented at PDC 2009 last November would be a good place to start. I was right. One tip among the list...

Share This Post:

Posted On Friday, April 30, 2010 3:09 PM | Feedback (1)

SQL Server 2008 RTM is available for download!

Yes, you read that correctly. Check it out here: http://www.microsoft.com/pr... Have a day. :-|

Share This Post:

Posted On Wednesday, August 06, 2008 4:31 PM | Feedback (3)

How To: Reset Identity column in SQL Server

This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find this helpful. Every so often (just this morning!) I find myself resetting an identity column value back to 0 after I've deleted all the existing records so the table gets a fresh start at primary key 1. Yes, I know all about primary keys not changing and how the value in the primary key doesn't matter and...