Absolutely correct

P.S. - My guess is that this...

Split the sentence into words, store each word in a new row. Then you can use INTERSECT and EXCEPT to get the results you want.

Backups do not run through the buffer pool. They use memory outside of that. Look up 'Backup Buffers' for more details

Other question is why?

Generally for backups you want the storage as simple as possible so that retrieving the files for a restore is as easy as it can be made....

Why do you think something's missing? Is it giving an error? Not working? Something else?

SQL 2008 R2 is a different version, so you'd start by buying new licenses for the new version. It's not a service pack.

Though to be honest, given that SQL 2008...

The size will be the problem. The file type isn't, SQL doesn't care at all what goes into a varbinary(max), it's just binary data as far as the database engine...

Yes, you can, because as I said above, "If you specify the port number, the lookup to SQL Browser isn't necessary and the client connects to the server and port...

All a named instance is is a 'lookup' to a port number, kinda like the friendly name that resolves to an IP address. What happens when you connect to a...

Or, if you want to be even more confusing...

create table [where]

([where] char(5),

[from [where] varchar(25),

[select [where from [where] varCHAR(50),

)

go

insert into [where] values ('from where', '[from [where]]', 'select [where]...

So a query that runs once an hour and takes 1001 ms is a bad query, but one that runs 50 times a minute and takes 900 ms is a...

Why?

Luis Cazares (1/22/2015)

---

Brandie Tarvin (1/22/2015)

---

rodjkidd (1/22/2015)

---

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the...

It's possible to have deadlocks with partition escalation that you wouldn't otherwise be able to get. There's a brief discussion in https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

Couple comments immediately

Why the dynamic SQL? All you're doing there is making things more complex, there's nothing in that query I can see that requires dynamic SQL.

SELECT oc.[name] AS...