SQL Server with Mr. Denny:

March, 2008


March 31, 2008  10:00 AM

Back To Basics: The UPDATE Statement



Posted by: Denny Cherry
Back To Basics, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL, UPDATE

After you've inserted the data into the table, it's time to update the data.  We do this by using the UPDATE statement.  The update statment can be used in two ways.  The first is to update a record or set of records in a single table, by simply filtering the data in the table by using values...

March 27, 2008  8:21 PM

Joins vs. Exists vs. IN: Not all filters are created the same.



Posted by: Denny Cherry
Query tuning, SQL

Not all filter commands are created equal.  Different filtering operations should be used at different times to get the best performance our of your SQL Server. While the JOIN, EXISTS and IN filters can give you the same results the way that SQL Server gets to the data is very different and can...


March 27, 2008  6:54 PM

New Article: SQL Server tempdb best practices increase performance



Posted by: Denny Cherry
Article, DataManagement, System Configuration

I’ve recently published a new tip on SearchSQLServer.com called “SQL Server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 24, 2008  10:00 AM

Back To Basics: The INSERT Statement



Posted by: Denny Cherry
Back To Basics, INSERT statement, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL

While the SELECT statement is probably the most important command, the INSERT comes in handy.  The INSERT statement is used to do exactly what it sounds like, it inserts data into a table.  There are two ways to insert data into a table.  The first is to pass in each of the values, and the...


March 21, 2008  6:11 AM

I had a great time speaking at the San Diego SQL User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

I'd like to thank the San Diego SQL Server User Group for having me come and speak to them tonight.  I had a great time presenting both my


March 20, 2008  12:00 PM

Remote Desktop, it’s better than ever



Posted by: Denny Cherry
Microsoft Windows, Software

Remote desktop is something that we've all used.  It's easy to find, right there under Programs > Accessories.  But there is so much more that you can do than simply connect to a remote session with it.  If you start the program manually from the run line by running "mstsc.exe" with some...


March 18, 2008  10:24 AM

Slide Decks and Sample Code for San Diego SQL Users Group Meeting



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

Below you will find links to download file files with the MS PowerPoint slide decks and sample files which I'll be using at this weeks presentation at the San Diego SQL Users Group Meeting. There is a lot of sample code in the Query Tuning file.  We'll look through as much of it as we can...


March 17, 2008  11:00 AM

Back To Basics: Using Common Table Expressions



Posted by: Denny Cherry
Back To Basics, Common Table Expressions, CTE, SQL, SQL Server 2005, SQL Server 2008, T/SQL

CTEs (Common Table Expressions) are one of the very cool features introduced in SQL Server 2005.  In there simplest most common form, think of them as a temporary single use view who's context is only within the command which follows them directly.  The syntax of a CTE is very...


March 16, 2008  9:39 PM

Webcast Recover the data, the whole data and nothing but the data you need available for viewing



Posted by: Denny Cherry
Backup & recovery, Quest Software, Webcam

The webcast which I did with Quest Software a couple of weeks ago "   Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 13, 2008  8:00 AM

SQL 2008 prevents schema changes if the table must be dropped



Posted by: Denny Cherry
Config, SQL, SQL Server 2008, SSMS

When editing the table schema in the SQL Server 2008 UI and the required change requires that the table needs to be dropped and recreated by default the UI will not let you make the change. The kinds of changes that would require that the table be dropped and recreated would be inserting a...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: