|
SQL Server Community Worldwide |
|
|
By host on
1/21/2008 7:38 AM
|
|
|
It was brought to my attention that there was a site being developed that is intended to be the hub of all things SQL Server. This site is packed full of tips, articles, forums, links and other information that will be valuable for the SQL Server professional.
To visit the site go to: www.SQLCommunity.com.
|
 |
|
|
|
|
|
Performance Benefits of Sub-Queries |
|
|
By host on
1/15/2008 2:24 AM
|
|
|
|
When querying large datasets the strategic assembly of the query's tables are as important as the assembly of the WHERE clause. The joining of a sub-query instead of a standard joining of tables can result in performance gains. The benefit comes from the order of execution; the sub-query is executed prior to the joining of the other tables which could result in attempting to join less rows of data.
The following query unions two tables that join to the PRODUCT table:
SELECT
Production.Product.ProductID,
Production.Product.Name,
Production.Product.ProductNumber,
Production.TransactionHi ...
|
|
|
|
|
More...
|
|
|
Great Start To A Year! |
|
|
By host on
1/3/2008 8:14 PM
|
|
|
My first widely published article occured today on DevX.com. It's title is Evaluating How Filtering Options Affect T-SQL Performance. This is a great way to start a new year! I anticipate authoring more articles in 2008. In fact, I am working on my next article on the subject of Threat Modeling which will also be published by DevX. The date of publication for my next article is to be determined.
Click here to go directly to the Evaluating How Filtering Options Affect T-SQL Performance article.
Enjoy!
|
|
|
|
|
|
|
|
Indexing Strategies |
|
|
By host on
12/28/2007 9:13 AM
|
|
|
At the most recent IndyPASS meeting, Tom Pizzato presented on the subject of Indexing Strategies. Tom's presentation was packed with detail that ranged from introducing the concept of indexing as well as discussing performance considerations at the page level.
This presentation was exceptional and so much so that I wanted to make note of it here in my blog. A great point discussed in this presentation was that while in general table scans in a query are not desireable there are times where they are more efficient than an index seek. For example: If you were querying a 100 row table.
Also noted was how the order of execution in a WHERE clause can effect the performance of a query as well as its use of indexes.
There was alot of great information and not enough time to fit it all in. A special thanks to Kimberly Tripp who provided Tom with a large portion of the information presented by Tom. To download Tom's slidedeck,
|
|
|
More...
|
|
|
SQL Server 2008 Cometh |
|
|
By host on
12/16/2007 10:36 PM
|
|
|
|
Like most real world developers and DBAs, I am working with multiple SQL Server versions at the same time. I currently work with SQL Server 2000 in one project while working with SQL Server 2005 in another. To further this experience, I recently had a discussion with a peer who just completed a project to move SQL Server 7 to SQL Server 2000. Some businesses are more eager to adopt the latest and greatest software while others take the “wait and see” or “if it ain’t broke don’t fix it” approach.
We now find ourselves on the cusp of another version of SQL Server. This really begins the new Microsoft eighteen month release plan. This plan is very aggressive; but so is the software and database marketplace. SQL Server has become quite a complex platform and frequent improvement and innovation is not only desired but essential to its survival and competitiveness.
Regardless of whether one feels that this new version is too soon or just in time, it is fast approaching and Microso ...
|
|
|
|
|
More...
|
|
|
|
Why Blog? |
|
|
By host on
12/10/2007 9:16 AM
|
|
|
|
There are many blogs on the internet. These blogs range from a series of short technical articles to updates on the latest developments and activities of a new baby. There are many motivations to writing a blog, her are just a few that I immediately think of:
- Exercising writing skills.
- Communicating specialized knowledge.
- Communicating ideas to a community of persons with a similar interest.
- A public diary.
- Sharing information to family, friends, or professional peers.
- Venting or establishing an outlet to voice an opinion/viewpoint.
- Marketing of a service/product.
For me, my motivation of writing this blog is two-fold:
1. In my early days of becoming a VB/VB.NET/SQL Server developer a big chunk of my learning came from online articles, forums and blog entries. When I run into an overly difficult challenge, these are still a ve ...
|
|
|
|
|
More...
|
|
|
A Brief Introduction To Threat Modeling |
|
|
By host on
12/4/2007 7:02 AM
|
|
|
|
Threat Modeling is one of those topics that you may see pop up in my blog fairly frequently. It is a subject that I find very interesting. I am in the process of authoring an article on this subject which should be published early 2008; but thought I would provide some nuggets for this blog.
Threat Modeling is the formal process of evaluating and documenting an asset's exposure to security breaches and data loss. An example of an asset would be an enterprise architecture of a network, an individual server, an application, a database or even non-computer based items such as patient file folders stored in a doctor's office. This is key to the security plan of any asset.
This process can be boiled down to four steps:
- Defining Assets
- Identifying Vulnerabilities
- Analyzing Threat ...
|
|
|
|
|
More...
|
|
|
Interaction of Web Controls Using Events |
|
|
By host on
11/30/2007 12:50 PM
|
|
|
|
One of the tricky aspects of using web controls in a .NET Web Application is the interaction of web controls. A scenario that may accurately describe the need for such interaction would be a master page that contains one web control that provides a search functionality and another that allows data entry functionality for the item recalled and selected from the search web control.
The use of “Events” works very well. I have used these quite extensively in my past .NET Web Application projects. A quick example of how an Event can be implemented:
Web Control 1 (we’ll call it webControl1) will be the instigator of the event. “DoSomething” will be the name of the event. The Event will need to be declared at the top of the class by using the following syntax:
Public Event DoSomething() ...
|
|
|
|
|
More...
|
|
|
INTERSECT Operator |
|
|
By host on
11/26/2007 12:49 AM
|
|
|
|
In my recent research for filtering options I ran across an operator that I had never considered: the INTERSECT operator. This operator was introduced with the release of SQL Server 2005.
The INTERSECT operator returns unique values from where they exist in both queries being evaluated. A sample of how this may appear in a query is as follows:
SELECT ...
|
|
|
|
|
More...
|
|