You may want to...

andis59 (11/20/2016)

---

I have inherited a project that uses MS Sql Server 2014 and some Stored Procedures.

In one of the Stored Procedure there is this select

IF(SELECT Max(rowcreateddt)

...

hurricaneDBA (11/20/2016)

---

Dear Members

We have implemented SP with Filestreaming + RBS

I came and found the transaction log file for the Crawl Store database at 47GB where it increased from 7GB...

One possible solution with an index added to the temp table which eliminates the hash match join

😎

The data seems a little strange though as there are overlaps which results in...

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...