INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
2011-10-04
6,210 reads
INFORMATION_SCHEMA
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,589 reads
2008-03-03
13,209 reads
Blogs
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Steps for a Successful Data Migration Session at Microsoft Ignite
By kleegeek
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...
Daily Coping 2 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Stored Procedure "Caching"
I'm having an issue with a database that I recently moved from SQL 2014...
SQLSaturday Foundation
We are setting up this thread to welcome questions and comments about the latest...
update query problem
Is there a way to take these two records and update the NULL values...
Ask SSC