November 20, 2007 01:20 PM

Sharpen Your Basic SQL Server Skills

Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator
Rating: (0)
SQL Server Magazine
InstantDoc ID #97337

Executive Summary:
New DBAs get answers to basic Structured Query Language (SQL) questions. This month’s column explores the difference between FILLFACTOR = 0 and FILLFACTOR = 100; ISNULL and NULLIF; a clustered index and a nonclustered index; % used as a wildcard and % used as an operator; and TRUNCATE and DELETE.


This m...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Thanks for informing us about the problem, tilleymf@hotmail.com. The downloadable code should be available to you now.

And thanks so much for reading!

Christan Humphries, Your Savvy Assistant

Christan2/15/2008 11:51:17 AM


Hi
While reading the article "Sharpen Your Basic SQL Server Skills " I have attempted to save/open the "Download the Code" item 97337.zip and it appears to be empty. Tried this from multiple workstations, but to no avail.
Thanks - Michael

MICHAEL2/15/2008 8:10:42 AM


Solution to pop-up ads: Stop playing with your pointer... The pop-up key words are green and double-underlined so aren't really "booby-traps".

Eliminating pop-ups is a good way to increase the cost of everyone's subscription.

Saleem12/26/2007 10:03:41 PM


Here's a comment from a new subscriber after two minutes of trying to look at my first "subscriber-only" article: I really hate those annoying fly-over links that pop up an irrelevant advertisement as I am trying to follow the text with my mouse pointer. I believe the fact that I've subscibed indicates that I paid for this content. Therefore, I do not understand why you feel compelled to plant advertising booby-traps in the paid content. Does anyone, including the advertiser imagine that inclination to purchase is increased by the use of these obnoxious pop-ups?

Robert11/21/2007 3:25:19 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS