WOW!!!! Your second post and you nailed the ddl and sample data. Excellent job!!! This takes many people dozens of posts, if they ever actually do it right. The only...

The problem here is that we can't see your...

Do you know how to use a where clause?

if exists(select * from sys.indexes WHERE ...)

select * from sys.indexes

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

mark.bienkowski (7/17/2013)

---

Sean Lange (7/16/2013)

---

At best you can find out what indexes have been used. This is not the same as what tables. So often this type of request is followed...

DATEDIFF can return negative numbers. FWIW, you don't need to use floor. You are dividing datediff / 30 which is integer division, the result will be an int. For example:

select...

You are going to have to use RowNumber somewhere along the way...

mark.bienkowski (7/16/2013)

---

Hello world.

I need to show all tables from my database that meet some conditions. For example tables with entries only after a particular date.

I want to see what...

As Phil said, although more gently than me, you do not need a cursor for this at all. There is absolutely NO NEED for one. If you can explain why...

And if at all possible do yourself a favor and change the column to datetime. When you store datetime information in another datatype you lose the ability to do calculations,...

ramyours2003 (7/16/2013)

---

what are the possible reasons when a query is timed out ?

what are the possible reasons for not truncating the log file ?

i have Log file of...

Nice. I always forget about except, not really sure why. Thanks for reminding that is in the toolbox!!!

This will explain what...

Assuming that each person who uses the application connects to the sql server with a unique login you could just query SYSTEM_USER.

select SYSTEM_USER

The above code will retrieve the username of...