For additional methods of dealing with parameter sniffing, check out Chapter 38 of the SQL Server MVP Deep Dives II[/url] book. It covers things not included in the article such...

TSQL is a querying language, not a presentation and formatting language. If you want to change the format, you need to have a report, a spreadsheet, or build an application.

Too bad you weren't on 2008 or better, you could just use the MERGE command.

As it is, you need to do two TSQL statements. The first should be an INNER...

vince_sql (10/5/2011)

---

Grant Fritchey (10/5/2011)

---

chandan_jha18 (10/5/2011)

---

Thanks. I was trying to remove the cast functions in the 'on' filter which Grant mentioned sometime ago.

But as you(Paul and Grant) mentioned about posted...

chandan_jha18 (10/5/2011)

---

Thanks. I was trying to remove the cast functions in the 'on' filter which Grant mentioned sometime ago.

But as you(Paul and Grant) mentioned about posted date which is...

paul_ramster (10/5/2011)

---

Your outer query has the WHERE clause:

where PostedDate='1/19/2011'

and PostedDate is defined in the view as:

CAST(CAST(SUBSTRING(WH_Status.StatusHistory,CHARINDEX('Batch posted successfully',CONVERT(VARCHAR(MAX),WH_Status.StatusHistory))-35,26) AS DATE) AS DATETIME) AS PostedDate

You will always get a scan on...

chandan_jha18 (10/5/2011)

---

Grant Fritchey (10/5/2011)

---

No real way to tell you anything without more information. Minimum an execution plan.

You say you're getting a table scan, do you have clustered indexes on the...

Yeah, as long as it's a separate instance. In terms of a DR situation,...

If the DB names are the same, you won't be able to log ship or mirror and still have access to one of the databases.

No real way to tell you anything without more information. Minimum an execution plan.

You say you're getting a table scan, do you have clustered indexes on the tables? If not,...

If the CPU is 100%, I'd focus there, not on memory. Memory pressure can evidence itself with increased I/O as more stuff gets flushed to disk more frequently, but it's...

From what you're saying, it's dynamic. You won't be able to create a plan guide for it. Modify the text and put in hints directly or take away the dynamic...

What problem are you trying to diagnose?

Scans aren't necessarily bad and seeks aren't necessarily good. It really depends on their relationship to the rest of the process, the number of rows involved, joins associated... It's actually...

But then you build the system to allow the drill-down to make another query. I've been through this too, at multiple organizations with multiple different data sets. There are any...