Sign in
intellectually constipated
patrick gallucci's sql server brain drain
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
.net
Business Intelligence
Common Table Expressions
Data Warehouse
Derived Tables
Erwin
Gadgets
general
IC Dictionary
Indexed Views
Katmai
Microsoft Certified Architect
Pages
Query Processing
SQL Function
SQL Script
sql server 2005
SQL Server 2008
SQL Server Stored Procedure
SQLCMD
ssis
Training
vista
visual studio
Windows Mobile
Archive
Archives
April 2008
(1)
February 2008
(2)
November 2007
(1)
October 2007
(2)
September 2007
(5)
August 2007
(7)
July 2007
(4)
December 2006
(3)
May 2006
(7)
October 2005
(3)
September 2005
(2)
December 2004
(1)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
intellectually constipated
How to drop all tables, all views, and all stored procedures from a SQL 2005 DB...
Posted
over 5 years ago
by
MSDNArchive
2
Comments
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 ...
intellectually constipated
The few, the proud, the fortunate. Microsoft Certified Architect Program
Posted
over 5 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
Bricks seldom feel good.
Posted
over 5 years ago
by
MSDNArchive
1
Comments
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
intellectually constipated
SQL Server Function to merge a date with a time
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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' )) ...
intellectually constipated
Windows Mobile Slingbox and SlingPlayer Mobile
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
Live Search, Windows Mobile and my little GPS friend!
Posted
over 6 years ago
by
MSDNArchive
3
Comments
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...
intellectually constipated
HALO 3
Posted
over 6 years ago
by
MSDNArchive
2
Comments
Nothing else to be said. GOOCH
intellectually constipated
SQL Server Function to get the Hour of the Year
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQL Server Function to get the Hour of the Month
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQL Server Function to return half year number of days.
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQLCMD and the power of the little r
Posted
over 6 years ago
by
MSDNArchive
3
Comments
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...
intellectually constipated
SQL Server Data Types Test Tables
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
Column Information View for SQL Server
Posted
over 6 years ago
by
MSDNArchive
4
Comments
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...
intellectually constipated
Released - Cumulative update package 3 for SQL Server 2005 Service Pack 2
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
Generate BCP, Bulk Insert code with TSQL
Posted
over 6 years ago
by
MSDNArchive
5
Comments
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...
intellectually constipated
That about sums up my day.
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
CA Erwin and Microsoft's Visual Studio Team Edition for Database Professionals
Posted
over 6 years ago
by
MSDNArchive
0
Comments
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...
intellectually constipated
SQL Server Function to Return DateName
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQL Server 2008 (Katmai) July CTP - Do you feel the need for speed?
Posted
over 6 years ago
by
MSDNArchive
2
Comments
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...
intellectually constipated
SQL Server Function to Return Date from Numeric Value
Posted
over 6 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQL Server Function to Return Numeric Value for DateTime
Posted
over 6 years ago
by
MSDNArchive
2
Comments
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...
intellectually constipated
HUH?
Posted
over 6 years ago
by
MSDNArchive
1
Comments
Technorati Tags: business intelligence , data mining , gooch , sql server , toons a day in the life of a business intelligence consultant...
intellectually constipated
SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part III
Posted
over 7 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part II
Posted
over 7 years ago
by
MSDNArchive
1
Comments
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...
intellectually constipated
SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part I
Posted
over 7 years ago
by
MSDNArchive
1
Comments
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...
Page 1 of 2 (38 items)
1
2