I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

I need for a quick one time demo to generate a bunch (500,000) clients names in a client table under SQL Server 2000.<BR><BR>Everything else in the table is loaded, the clients just don't have names.

A SQL Server expert gives his take on the absolute, No. 1, very worst thing IT pros can do when it comes to indexing. Consultant, author and Microsoft MVP Denny Cherry travels the world helping ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

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?