2014-02-28 (first published: 2011-02-16)
13,550 reads
2014-02-28 (first published: 2011-02-16)
13,550 reads
2014-02-21 (first published: 2010-08-16)
15,915 reads
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)
42,372 reads
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,318 reads
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,973 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...
Hello Everyone, At work, I've been getting more involved with hosting and database stuff....