dates

Posted by Derek Dieter on 17 June 2009, 9:32 pm

create table dates(
id int not null,
[date] as (yyyy+mm+dd),
yyyy char(4) not null,
mm char(2) not null,

[Aaron Bertrand] Cumulative Updates available for SQL Server 2008 SP2 & SP3: Today Microsoft has released two ne... http://t.co/WrwqSBf0 about 6 hours ago from twitterfeed

[Aaron Bertrand] How SQL Saturday could be better: I've been to a lot of SQL Saturdays. They are great events to... http://t.co/bLe97UD5 01:28:46 PM May 15, 2012 from twitterfeed

[Aaron Bertrand] SQL Server 2008 R2 Service Pack 2 CTP is available: You can download the service pack 2 CTP fro... http://t.co/kblQTr2y 07:17:01 PM May 14, 2012 from twitterfeed

[SQLTeam] Why to avoid SELECT * from tables in your Views: -- clean up any messes left over from before: if OB... http://t.co/GIDxRhEY 03:12:16 PM May 11, 2012 from twitterfeed

[Kalen Delaney] Did You Know? Turning Off Locking: Back when the lock manager was rewritten for SQL Server 7, an... http://t.co/lzEEpC11 11:41:52 PM May 07, 2012 from twitterfeed

[Aaron Bertrand] A cautionary tale about grandfathering CAL licenses in SQL Server 2012 Enterprise: I've tried t... http://t.co/1Uoru0DD 04:09:54 PM April 27, 2012 from twitterfeed

[Kalen Delaney] Geek City: Build a Big Table with a Columnstore Index: I was looking all over to find a big tabl... http://t.co/kzBZMTZu 08:53:46 PM April 26, 2012 from twitterfeed

[SQLTeam] ClearTrace Performance on 170GB of Trace Files: I’ve always worked to make ClearTrace perform well. T... http://t.co/R24uwgOl 12:25:22 PM April 26, 2012 from twitterfeed

[SQLTeam] ClearTrace Beta for SQL Server 2012: I have a beta version of ClearTrace that supports 2012. You can ... http://t.co/IrXM7ZFb 01:21:20 PM April 25, 2012 from twitterfeed

User Defined Functions and Performance - There is definitely a lack of... http://t.co/YdHjOTuH #fb 06:50:48 AM April 25, 2012 from SQL Server Planet

SQL Server Planet