SQL_ME_RICH (12/5/2012)

---

Is it true that if I have a T-SQL statement using (NOLOCK) in multiple places in my Stored Procedure (FROM, INNER JOIN, etc...) that those hints are being...

Performance.

Everything's fast on few hundred rows. With a...

Yeah, don't store dates as varchars, store them as datetime data types and then the comparisons will be date-based, not string based.

I strongly recommend fixing the...

Looks pretty good.

Why multiple files in a filegroup? Just to allow for the SAN's snapshot? (check that the snapshot software supports SQL Server databases before you use it). There's...

That's deprecated and has been for about 7 years. Look up ALTER INDEX

The thing which is giving me some perplexity is that before...

Nope.

There's two main reasons for going multiple files/multiple filegroups

1) IO throughput. This requires...

You still haven't answered my question about shrinks.

Fill factor is not going to affect how the index rebuild works. It'll affect how the index fragments after that, but not the...

Irrelevant to this question.

Year and a half old thread

The post title mentioned corruption, but the contents mention performance. Which is it? Do you have random index corruption or do you have poor performance?

Typically when an index rebuild fixes...

Bhuvnesh (12/5/2012)

---

then there is no guarantee that destination table will have same ID for same records as it has in source table (remember...sequence of insert query will...

What are you trying to...

If the DB with the errors is just your monitoring DB then that's not so bad.

Still need the checkDB output to say anything helpful.

ALTER DATABASE <database_name>

SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Managing Transaction Logs[/url]

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Partitioning is mostly about maintenance and data loads, not performance.

Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Searching on something like '%couldnot%' is going to be...