Capture the execution plan for the query. I'd also capture the plans for the individual views.

Combining views, even through something as seemingly innocuous as a UNION ALL, is a...

Sean Lange (5/7/2015)

---

COALESCE is just another function and is not at all relevant here. Not sure...

Functions against columns lead to scans. Period. End of story. You can't have the functions there AND get good performance. No matter what.

Also, DISTINCT is an aggregation function suggesting that...

I'll write one and then you can correct it.

😀

That's part of the object level permission as defined on the database you're scripting. You could probably write a PowerShell routine to remove it later.

If you're using the Wizard, when you get to Set Scripting Options, click on the Advanced button. There's a "Script Object Permissions" check box. Make sure that's disabled. That should...

If you're really serious about learning SQL Server, first, assuming you don't have an MSDN subscription where you can just download a copy of SQL Server, you'll need to purchase...

It sure sounds like something in the network configuration. There's not exactly a lot of variation in how you can type BACKUP DATABASE TO DISK = that's going to result...

goldberg.yoni (5/7/2015)

---

Hi,

I'm tasked to develop a gaming web application system with relatively large database - it should hold the data about 300 million players, the orders/payment of each player -...

If nothing constrains the data in any way, you can have duplicate rows.

I completely misread...

I think I'd go back to Eirikur's suggestion and make sure everything is patched to the same level. That could absolutely lead to this type of behavior ... if there's...

T. C. (5/7/2015)

---

Thanks Grant.

I've looked at the plan again, and the query is left joining to the table that has the index seek/lookup (not every row on the outer side...

Not exactly. Snapshot isolation creates a copy of the row while it's being modified. That copy can be read while the modification is occurring. The lock on the table is...

Jacob Wilkins (5/6/2015)

---

Yeah, running that ALTER DATABASE command requires an X lock on the DB in question, so you effectively have to be the only session using the DB.

You could...