SQL Server 2008 (Katmai) July CTP – Do you feel the need for speed?

Here it is…the July CTP for SQL Server 2008. I was going to start the download tonight and install in the morning…but I forgot I was on Verizon FIOS…man I love that Fiber! Download your copy now! https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470 Technorati Tags: SQL Server, SQL Server 2008, KATMAI

2

SQL Server Function to Return Date from Numeric Value

This function will return a datetime for a numeric value. This is using the 1900 date system, the same as used by Excel. See http://office.microsoft.com/en-us/excel/HP100791811033.aspx for more examples.   1: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[util].[uf_GetDateFromNumeric]’) AND type in (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’)) 2: DROP FUNCTION [util].[uf_GetDateFromNumeric] 3: GO 4:  …

1

SQL Server Function to Return Numeric Value for DateTime

Technorati Tags: SQL Server, SQL, Function, Intellectually Constipated This function will return a numeric value for a given date. This is using the 1900 date system, the same as used by Excel. See http://office.microsoft.com/en-us/excel/HP100791811033.aspx for more examples.   1:   2: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[util].[uf_GetNumericDate]’) AND type in (N’FN’, N’IF’,…

2

HUH?

Technorati Tags: business intelligence, data mining, gooch, sql server, toons a day in the life of a business intelligence consultant…

1