I have long lost count on how many posters on the forum have gotten solid and good advice from other members when handling PII and other sensitive data. My concern...

Can you post the DDL (creat table) script for the SUMMARY and the JASPER_REBATES_SUMMARY tables, the full code of the stored procesure and the actual execution plan please?

😎

Luis Cazares (11/18/2016)

---

Dear Santa,

I know you won't be able to bring me a new laptop this year, but could you just bring more RAM (and a new HDD) for my...

jasona.work (11/18/2016)

---

Grant Fritchey (11/18/2016)

---

jasona.work (11/18/2016)

---

So someone dug in to how MS has SQL2016 working on Linux[/url], only to find that *horrors* they're using essentially a containerization type solution. Just...

planetmatt (11/18/2016)

---

Another weird thing to throw in the mix.

When examining the raw data in SQL, SELECTing the row in question with a SELECT * does not show the "?". ...

Firstly, I strongly recommend changing from Maintenance Plans to Ola Hallengren's Maintenance Solutions[/url], much better.

😎

Have you tried to send mail from the troubled server? Do you capture any send mail...

I think that the ? could be a representation of a strange character, have you tried to reproduce the error by entering a ? in front of a phone number...

Quick question, after the upgrade, did you update all stats etc.? Are the server platforms identical? Same server settings (maxdop, cost threshold for parallelism etc.)?

😎

an0nemus (11/18/2016)

---

1) host file has just the 'usual' entries

2) problem server has been rebooted

3) I'm not sure what sqlcmd is, but SQL Server Mangement studio will also have issues, though...

Quick thought, could this be a permission problem?

😎

Benki Chendu (11/18/2016)

---

Eirikur Eiriksson (11/18/2016)

---

Benki Chendu (11/18/2016)

---

Hi All,

A customer of mine has huge number of sql 2012 databases but he doesnt know which data sits where. he needs me to...

Benki Chendu (11/18/2016)

---

Hi All,

A customer of mine has huge number of sql 2012 databases but he doesnt know which data sits where. he needs me to help me in creating...

BWFC (11/18/2016)

---

TomThomson (11/17/2016)

---

BWFC (11/16/2016)

---

Sean Lange (11/15/2016)

---

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish...

WilburSmith (11/18/2016)

---

Hi,

I run into a problem while loading data into DataVault. I create my dv key with HASHBYTES('MD5', <business key>)

The load failed due 'Duplicate data' error and the duplicate key...

I'm not aware of any proper query re-writing tool that can handle anything more than relatively basic queries.

😎

If you can get the actual execution plan then that is a good...