No, it's not automatically a bad idea, and the variable may or may not give any better estimates.

It has to do with parameter sniffing and the ability of the optimiser...

Brandie Tarvin (5/16/2016)

---

GilaMonster (5/16/2016)

---

My favourite was the candidate who addressed every answer to my team lead, even though I...

My favourite was the candidate who addressed every answer to my team lead, even though I was asking the...

Brandie Tarvin (5/16/2016)

---

Oh, dear. I can just...

Sigh. Via PM: "Can you access my computer via Teamviewer to fix the firewall settings"

Can, yes. Will, not a bloody chance in hell.

Then you're going to have to sit and debug the network connectivity. It's probably closed ports on a firewall or similar, which is why it's going to need a local...

Speak to your network admin, or whoever set the VPN up. It's not something that random people on the internet are going to be able to fix for you.

tt-615680 (5/16/2016)

---

Here is the script for the user databases:

1. stop SQL Server Service

2. Check the location of the tempdb files

Use master

GO

SELECT name AS [LogicalName],physical_name AS [Location],state_desc AS...

Yup, entirely possible. Rolling upgrades like you describe are the only time that log shipping (or mirroring) is supported across versions.

I strongly recommend you don't leave that SQL Server accessible from the internet. Set up VPNs so that you can connect securely and ensure that random computers on the internet...

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate....

What?

An app shouldn't be able to tell what kind of...

Yes, it's expensive (it's re-writing the entire table), no, it's not online.

Why don't you create a clustered index on the table, then you don't have to worry about forwarded records?

How did you fail back?

What state is the secondary database in?

This looks like Oracle code.

While some people do know Oracle, this is a SQL Server forum (as in Microsoft SQL Server), and that's what most answers will be written for.