SQL Server with Mr. Denny:

SQL


April 10, 2008  8:00 PM

Back To Basics: Stored Procedures, the work horse of the database



Posted by: Denny Cherry
Back To Basics, SQL, SQL Server stored procedures

Stored procedures are extremely useful objects.  Not only do they store T/SQL scripts for later execution, but they also provide us with an extremely important security barrier between the user interface and the database.  The security barrier is used to prevent the users from needing SELECT,...

April 10, 2008  3:00 PM

Back To Basics: Views, what exactly are they?



Posted by: Denny Cherry
Back To Basics, Oracle Views, 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



Posted by: Denny Cherry
Back To Basics, SQL, Tables

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



Posted by: Denny Cherry
Query tuning, SQL, SQL Server 2008

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...


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 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 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 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...


March 10, 2008  10:00 AM

Back To Basics: The SELECT Statement



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

There are four basic commands in databases.  They are SELECT, INSERT, UPDATE and DELETE.  Probably the most important of these is the SELECT command.  The SELECT command is how the data in the database is retrieved and displayed. (All these code samples can be run on all versions of Microsoft...


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: