At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing strategies to boost performance in SQL Server databases--from 2000 to 2025.
Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...
I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?
The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...