Select or print is just a personal preference to you on SSMS. It's going to be different when you call it form the application.

In ssms you'd use print or...

You have to add an extra select to display the variables.

Of course the SELECT will be tones faster.

HOWEVER. Keep in mind that for any insert, update, delete in ANY of the tables of the indexed view, you will have...

while @@rowcount <> 0

DELETE TOP (5000) FROM dbo.Table where Dt....

You can then include waitfor to give the server time to breathe and also commit every few runs.

You select count(*) is...

Yes it is.

In the reports's available variable you have user.userid or something like that.

Create a new dataset that fetches the default value from some table and use that value to...

bitbucket-25253 (9/26/2011)

---

Sh*t happens. The question wasn't designed especially for that, but I expected it.

This one is just a small typo by Steve... and it keeps on going.

Apparently people like...

You'll need to edit all and every ad hoc queries you need to run under that isolation.

Maybe you can set that at the connection level but I can't tell you...

http://sqlfool.com/2011/06/index-defrag-script-v4-1

Make a master report with subreports on it. It'll export all into 1 workbook on different worksheet (might have to set new page on the subreport for that, but...

Removed

Perry Whittle (9/26/2011)

---

yes, like i say every system is different. Here's the other thing though, if you are backing up, copying and restoring every 15 mins the disconnects and the...

Perry Whittle (9/26/2011)

---

yes, you are correct. If the database is in standby mode then users have to be disconnected to restore the logs.

The point is, there isn't necessarily an...

I'm going to say something that looks compeltely useless until you get it.

You say that join is taking 90% of the query? Then fine, whack it.

BTW left join +...

Perry Whittle (9/26/2011)

---

why is replication yours then 😉

For most users log shipping provides excellent report offloading. I dont understand your point...

When #1 doesn't work because you have a dynamic <server, db, owner, table> then you need #2.

The other real case is search dashboards where you have n optional parameters. ...