SQL Server with Mr. Denny:

Development


April 10, 2008  3:00 PM

Back To Basics: Views, what exactly are they?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Views are strange objects.  They look like tables, can be queried like a table, but they don't store any actual data.  Think of them as a virtual table which has pointers back to the source tables.  Views can combine data from one or more tables via joins just like a select statement. Using...

April 10, 2008  10:00 AM

Back To Basics: Tables, without them we have nothing to do

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Tables are the core of any database platform.  Without tables we would be able to process data, but we would have no way to store the data.  In the simplest terms tables look like Excel sheets.  They both have columns and rows.  When you view a table in the client tools it looks much like an...


April 7, 2008  11:00 AM

SQL Server 2008 changes the way that CONVERT/CAST works

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless.  In SQL Server 2008 this problem is fixed.  Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime...


April 3, 2008  11:00 AM

New INSERT syntax in SQL Server 2008

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

One of the very cool new feature which SQL Server 2008 gives us is an change to the INSERT statement.  Now you can...


April 1, 2008  6:43 PM

New Article: Tips for scheduling and testing SQL Server backups

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've just published a new tip on SearchSQLServer.com called Tips for scheduling and testing SQL Server backups.  In it I'm talking...


March 31, 2008  10:00 AM

Back To Basics: The UPDATE Statement

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

After you've inserted the data into the table, it's time to update the data.  We do this by using the UPDATE statement. ...


March 27, 2008  8:21 PM

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Not all filter commands are created equal.  Different filtering operations...


March 27, 2008  6:54 PM

New Article: SQL Server tempdb best practices increase performance

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

While the SELECT statement is probably the most important command, the INSERT comes in handy.  The INSERT statement is used...


March 21, 2008  6:11 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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


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: