Jeff Moden (11/21/2016)

---

I have to do some more research on it but it may be time for me to get ready to retire.

[font="Arial Black"]Microsoft Replaces Command Prompt with PowerShell in...

Quick question, any backup related errors in the error log?

😎

EXEC sp_readerrorlog;

Charmer (11/20/2016)

---

I don't think they gonna use SQL 2016. So I'm not sure, Eirik. But please let me know about your idea. I will take it up to my architect...

hurricaneDBA (11/20/2016)

---

Our RTO is 5 days but they are using EMC backup so the dbs have to stay in full backup mode.

The issue I have is sharepoint has enabled...

Just a thought, do you have an option of using SQL Server 2016 and PolyBase? Just forming an idea, not thought this fully through...

Grant Fritchey (11/20/2016)

---

I would only recommend this switch...

Quick questions, can you use Table Variable Parameter? How wide are the largest values passed? How many values at the most...

Charmer (11/18/2016)

---

Hi Friends,

I have been assigned to a new project where data load s gonna happen from oracle to cassandra through SSIS and then to render the report by SSRS...

Quick question, which version of FreeTDS are you using?

😎

Quick thought, how about changing the logic to logging all errors into a table by i.e. a batch ID and after the package has run then run another task that...

I'm strictly for the full most practical normalisation with one exception, carrying forward a very carefully selected keys such as Invoice-->InvoiceLine-->InvoiceLineDetail(InvoiceID) where, at the cost of a single integer column,...

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