Greg Edwards-268690 (5/14/2014)

---

Grant Fritchey (5/14/2014)

---

Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not on the...

I'd say show them that error message and let them look it up through Bingle. It's absolutely a hardware related problem and it's very well documented as such out on...

Check the documentation on the BACKUP command. There is no facility for just getting the READ_ONLY file groups. You'll have to go after each one individually. Partial backup documentation says...

Blocking caused by another process doing an INSERT/UPDATE/DELETE which will stop the scan.

It's absolutely an I/O issue. I'd say your disks are being overwhelmed because the issue isn't that a given process is waiting for disk access while another process uses, but...

Ed Wagner (5/14/2014)

---

Koen Verbeeck (5/14/2014)

---

I pretty much laughed with the "I...

Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not on the column) to replace the...

yuvipoy (5/14/2014)

---

If i use NEWSEQUENTIALID() then there will be less fragmentation ok good, but how about the join behavioural ?

for the test of 1000 record on a table with...

Well done. That's great to hear.

Sorry, it took me a little while to write that up and in the mean time others have posted roughly the same stuff. I kept getting distracted. Doggone twitter.

You could UNION the two together, but you'll have to have the text in two columns. So, how about we put the UNION query into a derived table. Something like...

Yeah, you have to set max memory. SQL Server will attempt to use all the memory available to it, so the only way for sure to limit that is to...

Also, be cautious using views in SQL Server. They're a fine way to obfuscate queries and implement security and other functionality. But, people start treating them like tables and joining...

I'm going.

One session on Friday and one on Saturday. I'll be there Thursday afternoon until Sunday morning.

Last Bits was probably the single best event I've ever been to. I'm really...

If you have the file compressed, additional compression is usually not possible. You can either just move the file as is, or try splitting it up and moving the smaller...