March 17, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Common Table Expressions,
CTE,
SQL,
SQL Server 2005,
SQL Server 2008,
T/SQLCTEs (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
Posted by: Denny Cherry
Config,
SQL,
SQL Server 2008,
SSMSWhen 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
Posted by: Denny Cherry
Back To Basics,
SELECT statement,
SQL,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
T/SQLThere 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...
March 6, 2008 3:12 AM
Posted by: Denny Cherry
In Person Events,
Query tuning,
Resource Governor,
SQLThe good folks of the San Diego SQL Server User Group has invited me to come speak to them on March 20, 2008. The meeting starts at 6PM.
If you are in the area I urge you to come and check it out. The topic of my talk will be Query Tuning as well as a bit of Query Governor. If you...
March 6, 2008 2:26 AM
Posted by: Denny Cherry
Article,
Compliance,
Quest Software,
SQLI've written a technical brief on how my company,
March 3, 2008 10:00 AM
Posted by: Denny Cherry
Back To Basics,
SQL,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008I've seen a lot of posts online over the last few weeks with people asking about basic query syntax. So over the next few posts I'm going to show some basic T/SQL queries as well as some more "advanced" features and syntaxes.
Hopefully you'll find these syntaxes useful.
All the code...
March 2, 2008 11:45 AM
Posted by: Denny Cherry
Article,
RAM,
SQLI've recently published a new tip on SearchSQLServer.com called "
February 28, 2008 8:00 AM
Posted by: Denny Cherry
In Person Events,
SQL,
SQL Server 2008Well I just got back from the Launch event. The event was excellent. Microsoft was giving out a lot of really excellent information about all the products. The turnout was just amazing. I heard that about 5000 people registered, and that based on prior events about 3500 were expected to...
