SQL Server Nation

For all of your SQL Server needs.

Sign in | Join | Help

April 2009 - Tip of the Week

Tip of the Week

Home

Syndication

Recent Posts

Tags

Archives

Sort by: Most Recent | Most Viewed | Most Commented

The Numbers Table (Round 2)

Originally I wrote about The Numbers Table over at SQL Server Central . Over there I presented the structure and a couple options on how to populate it. I won't dwell on all of that again. I'm just going to keep it simple. What is a numbers table...

Published 27 Apr 2009 9:29 PM by BrandonGalderisi

Filed under: views, Intermediate SQL, Beginner SQL, Advanced SQL, User Defined Functions
Fast searching of large (n)varchar values

In this Tip of the Week post, we will discuss how you can index a large data field to allow fast equality searching. What does this mean? It means that you won't be able to do indexed LIKE searches, but you will be able to do indexed = searches. Why...

Published 2 Apr 2009 1:00 AM by BrandonGalderisi

Filed under: Advanced SQL, Indexes

Copyright SQL Server Nation 2009

Powered by Community Server (Non-Commercial Edition), by Telligent Systems