2014-02-28 (first published: 2011-02-16)
13,440 reads
Todd Fifield
2014-02-21 (first published: 2010-08-16)
15,709 reads
Calendar Tables
Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.
2014-02-14 (first published: 2010-07-15)
41,441 reads
Using a Variable for an IN Predicate
How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.
2013-03-01 (first published: 2011-06-21)
26,069 reads
Key Word Searches
This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.
2012-09-07 (first published: 2011-02-28)
34,840 reads
Blogs
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Daily Coping 25 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
VMworld 2020 – Top 10 Database Sessions (Part 1)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
New Stuff Can Be Scary
Comments posted to this topic are about the item New Stuff Can Be Scary
Stored Procedure Performance Woes... How to get around CURSORS for html gen.
Hi everyone, Working with a stored procedure that is used in an application of...
Any guides for sizing Azure managed instances.
Hi All, Has anyone got any tips for sizing a move from VM running...
Ask SSC