intellectually constipated

This is a follow-up to the blog entry from Jasper Jugan . This is a modification to the script to allow for schema specific deletes of the SP's, Views and I added Functions.   create procedure usp_DropSPFunctionsViews as   ...

And I really do mean fortunate. On March 10th I am to embark in five weeks of some of the toughest technical training that I will do during my career. I have been to week long ramp-ups and boot-camps to help facilitate learning during my career. But this...

Not much to say. I have been angry that he has not returned my emails. Sorry Ken. Ken Henderson – We Will Always Remember You   Technorati Tags: Ken Henderson , SQL Server , SQL

I use this when I need to join two fields. One has a date, the other has a time.   IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_MergeDate2Time]' ) AND type in (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) ...

So here is my 2nd favorite new gadget on my Windows Mobile device. With the 3G network speed and my SlingPlayer mobile, when I am not using Mobile Live search, I am either watching tv or listening to the news on my Windows Mobile Device. The quality is...

I have really started to like my Samsung Blackjack running Windows Mobile lately. I am going to start to share some of my favorite applications and gadgets as time permits. My latest and probably favorite as of now is Live Search for Windows Mobile. I...

Nothing else to be said. GOOCH

This function returns an integer of the hour of the year passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfYear]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP...

This function returns an integer of the hour of the month passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfMonth]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP...

This function returns an integer of the number of days in the half year.   IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHalfYearDays]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP...

I would have to say that one of my favorite new utilities that shipped with SQL Server 2005 has been the SQLCMD utility . I am going to demonstrate the use of include files. The following is the complete call syntax for SQLCMD. sqlcmd [{ { -U login_id...

These tables can be used for testing various data types of SQL Server. You can extend as needed. SET NUMERIC_ROUNDABORT OFF ; SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,QUOTED_IDENTIFIER, ANSI_NULLS ON ; GO -- Create XML Schema...

Here is a view that contains column information. This is useful if you need to create a DDL statement for a table. CREATE VIEW dbo.vColumnInfo AS SELECT tbl.name AS [Table_Name], SCHEMA_NAME(tbl.schema_id) AS [Table_Schema], CAST (ISNULL(cik.index_column_id...

Here is the link. http://support.microsoft.com/default.aspx/kb/939537 Here are the fixes in this release. SQL bug number KB article number Description 50001581 938243 (http://support.microsoft.com/kb/938243/) FIX: Error message when you run a full-text...

This script will generate tsql code to bcp and bulk load data for all tables in a given DB. SET NOCOUNT ON GO DECLARE @ path nvarchar(2000), @batchsize nvarchar(40), @format nvarchar(40), @serverinstance nvarchar(200), @security nvarchar(800) SET @ path...

I was got to Hoboken, no path trains, so I waited for a bus. That got me to downtown, so I waited for another bus, but then the riots started, so I started walking....and walking and walking...took me 7 hours to get to our office, that on a normal day...

This about sums it up! The integration of CA's ERwin® Data Modeler with Microsoft's Visual Studio Team Edition for Database Professionals brings together an industry-leading heterogeneous database design product with a focused MS SQL Server development...

This function will return the date name for a given date time. 1: USE [DW_SharedDimensions]; 2: GO 3: IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetDateName]' ) AND type in (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT...

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...

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...

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...

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

So in Part II of this article I had created a View so that I could then create an index on this view to see if that was going to give me the expected results. I did create the view, but not the index. So you probably already know. These columns are non...

I have now started the process of evaluating the other possible ways of executing the query. These include using a derived table, Common Table Expression and an Indexed View. My intent is to not use any functions that could twist my results. Below is...

I am calling this Part I because I know I still have some more details to discover about something I learned today. Not sure I fully understand it right now, but by the time I get to Part N, I am confident I will know way to much about the subject. I...