ChrisM@Work (9/25/2015)

---

mw112009 (9/25/2015)

---

Luis, Yes

Reason: EXISTS is just a another subquery that runs for each row that was fetched. Subqueries take time.

The LEFT JOIN will figure out the data set just...

You might be able to in the case of that exact value, by casting it as an appropriate numeric type. However, that is not a reliable technique. For example:

DECLARE

You likely have something else at play than just...

Kristen-173977 (9/14/2015)

---

I agree. I'd diverted to start worrying...

Kristen-173977 (9/14/2015)

---

Naive question but does that include Index Rebuild, as well as CHECKDB?

krypto69 (9/14/2015)

---

I do manually...

Ed Wagner (9/11/2015)

---

Markus (9/11/2015)

---

Not sure if this will help or not... worth trying..

try backing up to multiple files... 3...4... instead of 1 file.

Also, if you are SQL2008R2 or greater use...

Just to confirm, it's running without errors but not actually replacing any characters?

Might be something like this: https://connect.microsoft.com/SQLServer/feedback/details/385082/replace-function-does-not-work-with-valid-unicode-characters-above-65500

Try using the explicit binary collation as in that workaround, i.e.:

UPDATE TABLE

SET DS...

Hugo Kornelis (9/11/2015)

---

Jacob Wilkins (9/10/2015)

---

Well, I tested it multiple times in 2008 R2 and that was the behavior I saw. Perhaps that behavior is different than in other versions,...

There are a lot of factors involved in how to reduce the size of log files and whether you even should.

Ideally, I would say make a priority of reading this:...

Should be able to REPLACE the NCHAR(65533).

Something like this:

DECLARE @UnicodeString NCHAR(100);

SET @UnicodeString=NCHAR(65533)+N'Hey, what''s that at the beginning?';

SELECT @UnicodeString;

SELECT REPLACE(@UnicodeString,NCHAR(65533),'');

Cheers!

Jacob Wilkins (9/10/2015)

---

Hugo Kornelis (9/10/2015)

---

Jacob Wilkins (9/10/2015)

---

Queries that already have a plan cached that uses the nonclustered index will...

Hugo Kornelis (9/10/2015)

---

Jacob Wilkins (9/10/2015)

---

Queries that already have a plan cached that uses the nonclustered index will throw an...

Queries that already have a plan cached that uses the nonclustered index will throw an error.

The bit of...

The number of rows in the table and whether the query is parallelized are both completely irrelevant to lock partitioning. Microsoft's example to illustrate lock partitioning is on a table...

Ah, thanks for posting that. I'd been having more trouble finding a 2008 instance than I'd expected.

So it seems 2008 (not R2) is the same as the others I've tested,...