Fragmented array

Hi, Using query analyzer on a SQL 2000 server. I'm having trouble even describing what I want here... Let's try this, here's the...

I have 18 tables that are all related by the primary key. When I join all the fields together for reporting, it only shows the records that ...

Hi Guys, I am using sql server 2000 and i want to find missing number between 1 and 1000 in a table. what is the query for that? pls advice ...

I have 200 tables that have data entered into the daily. I need to identify all dates that are missing from the tables. for example: date co...

I have a series of start and end time records. The problem is to select the min and max time from the series of records. The following contr...

How to find the minimum value from time Timestamp column ? I want get the eralier timestamp vlaues from the avaliable list when iam using Ag...

Is there a way to convert the numbers under memory, cpu and I/O usage into some kind of percentage or number of KB? So far I have been getti...