SELECT <col1>, <col2>, etc..

FROM <table1> WITH (INDEX(<idx1>))

WHERE <condition clause>

SELECT name

FROM employee WITH (INDEX(idx_name))

Hope this helps. I have run into problems where the hint causes an error with an ADO...

Thanks everyone..but,

I am looking for the amount of space that is actually storing data(or indexes) in a datafile. Basically, I am looking for space utilization. DBCC SHOWFILESTATS provides...

Thanks for the input 🙂

I recreated the indexes today and on some of them the density levels changed. (I had many indexes and stats w/ 0 density levels.) I...

I ran sp_updatestats and dbcc updateusage and those readings stayed the same. That's when I made the post. I can't see how a scan density would be 0...

Let me throw some other ideas at you. I have been in the middle of slowing performance myself.

Take a look at your query plans and see if there are...

Thanks for the info everyone. I noticed the query plans have changed over the last couple of weeks and some apps are having performance issues. I don't understand...

Thanks Brian,

Can I delete these indexes, and do they consume space?

Thanks All....

Yes, there are plenty of opportunities with this to do some performance tuning. I will get to that eventually..

I would really like to prove or disprove a memory...

I am seeing a database that runs well for a few hours, even during peak hours, and then anywhere from 8 to 20 hours later performance takes a big hit....

1 Gig of RAM.

The application is poorly tuned. I just walked into this shop and we will get to things like excessive indexes.

I WANT SQL Server to hold onto the memory. ...

The job is an ActiveX script, and since I am new to the company I am not fully aware of what it is doing. See "You know you are a...

You just might be a DBA if......

The thought of cleaning tables has nothing to do with food