Generate Column Metadata
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
716 reads
INFORMATION_SCHEMA
Using TOP To Rank Columns In a Table
This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.
2011-10-25
6,476 reads
INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
2011-10-04
6,317 reads
Query-generated Column Expressions
A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.
2010-05-25
8,595 reads
2009-10-05 (first published: 2009-09-21)
2,137 reads
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,102 reads
2008-03-03
14,046 reads
RE: Clone Database
If you need to have the clone db continuosly with the last changes, you should choose between log shipping and replication. Wich one is better will depend of how much latency you can support.
2004-01-21
2 reads
RE: dynamic source sql string in transformation
If I am understanding you correctly you might try creating a stored procedure that allows a parameter to be passed to it (Credit Score) and stores this in a table. Within the same stored procedure execute (xp_cmdshell) the DTS package modifying it to read from the Credit Score table.
2003-08-22
1 reads
RE: PeopleSoft's 8x Compare and Report Output(prt,idx)
I would like the data to be in a format I can import into db table or use in excel, or maybe even a text format. I could use just about anything, except what we have now. Just a note. I just started taking MS SQL so I have aways to catch up. Cliff Moore […]
2003-08-19
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers