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)
717 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,483 reads
INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
2011-10-04
6,340 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,596 reads
2009-10-05 (first published: 2009-09-21)
2,167 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,112 reads
2008-03-03
14,457 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
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
Daily Coping 6 Dec 2022
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
What’s next: Job search burnout
I was given 4.5 months notice this past June and was fortunate to find...
Forums
Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns
Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...
The Availability Group Secondary Connection
Comments posted to this topic are about the item The Availability Group Secondary Connection
SSRS Expression Error
I am getting the following error when I try to use the Expression below....
Ask SSC