Just to be clear, moving the report to a read only replica won't necessarily make it any faster.

Switch to bulk-logged, perform some bulk inserts or index rebuilds...

Ed Wagner (10/22/2014)

---

I guess I'll have...

In a real system you'd never do either of those prints in a stored proc. The application would check that a city has been selected before calling the proc and...

Ok, so we've confirmed that there are no rows for the city Greenville.

Which tab of the output are you looking at for the printed results?

Screenshot?

What does the query I posted return please?

I wasn't asking where in the code you were doing the IF, I can read T-SQL fine. Where are you looking when you...

Looks fine...

What does this return?

DECLARE @city varchar(20)

SELECT @City = 'Greenville'

SELECT CompanyName

FROM Customer

WHERE CompanyName IS NOT NULL

AND City = @city

UNION

SELECT CompanyName

FROM Supplier

WHERE City = @city

Also, where are you checking to see...

A braai has nothing to do with slow roasting anything.

Similarly, if you invite people for a braai here, there better not be just burgers, though we don't have tradition of smoking stuff.

Not directly, because there's no implicit conversion possible from INT to DATE.

What you can do is to add a new column with a DATE type, update it with the converted...

Huh?

After the restore you can add more files and filegroups, move the data around, that kind of thing. Nothing to do with generating scripts.

And what did a google search turn up?

It's not a term with a rigid definition

If you've got no stats for the problematic period, you're going to have a very hard time figuring anything out.

First place I would have looked, with monitoring, would have been...

ramana3327 (10/20/2014)

---

We implementing always on mainly because of reporting server. We don't have OLAP source for the reports. Our current reports are running hours and hours and causing deadlocks on...

Firstly, can you clarify what you mean by 'database refresh'?