This sample shows how to call SQLColumns on a table with sparse columns that were defined by using ODBC in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md ...

This stored procedure converts a table or select query to a HTML table format, with some customization options. I have taken as a base, a script Carlos Robles (dbamastery.com) provided me for a static ...

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects simply to a non-technical, business audience. Over… SQL is a programming ...

18 July, 2012. It was a Wednesday. Doing a deployment last night, I ran into an issue around indexing performance around SQL columns of type varchar. Varchar is the ANSI version of character data – ...