hide system tables

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or some other logging tool, grab 15 minutes of data being executed o...

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or some other logging tool, grab 15 minutes of data being executed on...

How do you index through a set of Columns Programmatically using SQL. I have a Table all the columns have the same data for different dates....

I am trying to index through the columns of MyTable so I can do the same work on all columns. I know how to get the column names from MyTabl...

Here's the situation: we have a character based field of up to 2048 characters in length that we want to store in a single column in a s...

Here's the situation: we have a character based field of up to 2048 characters in length that we want to store in a single column in a s...

Here's the situation: we have a character based field of up to 2048 characters in length that we want to store in a single column in a ...

Any one has an idea? How should I implement R-Tree spatial index in SQL Server? My idea now is to create UDT for my spacial coordinate and t...

Hi, I want to find out what is a good way to identify indexes that need rebuilding. I tried to run DBCC showcontig and identify them based o...