chandan_jha18 (10/6/2011)

---

Grant Fritchey (10/5/2011)

---

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...

Ninja's_RGR'us (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting older as...

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting older as well. People I...

Script out the database. Like it says above, use SSMS to generate a script. You can also make calls to SQL Server Management Objects (SMO) from code to generate...

It's not something I've run into before. Are you up to date on the service packs? Have you looked to install any of the cumulative updates? I'd start there.

Just a...

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,...