SQL Server with Mr. Denny:

SELECT statement

1

May 22, 2013  2:00 PM

The Optimizer Isn’t As Smart As You Might Want It To Be



Posted by: Denny Cherry
Database, Database Design, Index Performance, Performance, Performance Problems, Problems, SELECT statement, SQL Server, SQL Server 2008 R2, Stored Procedures, T/SQL, Tables

A little while back I got one of those phone calls.  You know the one, the lovely 6am phone call about random performance problems.  There were two...

January 23, 2013  9:00 AM

NOLOCK is not a turbo button



Posted by: Denny Cherry
CREATE INDEX, Database, Execution Plans, Indexing, SELECT statement, SQL Server, T/SQL, Tables

All to often when talking to developers they put the WITH (NOLOCK) table hint in place to speed up queries without understanding what the table hint does.  I've...


August 15, 2012  2:00 PM

Old Web Based Applications Need To Be Removed



Posted by: Denny Cherry
Data Loss, Data Security, Database, Database Administration, SELECT statement, SQL Injection, SQL Server, Stored Procedures

What happens to most obsolete web based applications at most companies?  They sit idle on a web server for months, sometimes years.  Why is this a problem? Because many of these old applications can be easily exploited via SQL Injection allowing access into the SQL Server databases which they...


November 27, 2008  12:15 PM

Back To Basics: Creating Indexes



Posted by: Denny Cherry
Back To Basics, CREATE INDEX, SELECT statement

After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database.  If you haven't already done so, its now time to start adding indexes to your database.  The catch with index is that there is such a thing as to...


July 21, 2008  11:00 AM

A better way to index text data



Posted by: Denny Cherry
Index Performance, Query tuning, SELECT statement, T/SQL, Tables, Uni-code

Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for.  However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server.  This is because of the large amount of data being put in...


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


1

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: