chewychewy (12/17/2016)

---

Hi Guys,

Understand that subscriber/publisher is deprecated.

There is a product from MS -Change Data Capture for Oracle by Attunity that does replication from oracle to sql server.

Is there any good...

allenjoey24 (12/18/2016)

---

LOL that is what I thought! But the textbook I'm reading wants me to query and "modify it somehow so that it uses base tables only". I'm not really...

This...

I prefer simply letting the log grow naturally and leaving it there........after all, how often does an SQL Server really Need...

Something I would like to add to my previous remarks is this:

If the transaction log really is that big, then now is definately the right time to figure out why....

New Born DBA (12/13/2016)

---

Experts, we have decent amount of servers and hundreds of users accessing DBs on those servers. It gets painful time to time to manage users and their...

prafullaahirrao (12/12/2016)

---

Hi All,

I have one table Employee which has 2 columns EmpId and EmpName with thousand's of rows in it.

Table does not have any key as of now.

If I execute...

Sorry, your code isn't really that easy to read.

Is there a reason you aren't ROUNDing the decimal numbers you want to format?

GilaMonster (12/14/2016)

---

Austin_123 (12/13/2016)

---

In our day to day operation If I restore a database from PROD to QA with same SQL edition and version then should we not required to...

dave hants (12/14/2016)

---

We looked at Robocopy and Powershell here and tried various implementations but found them not totally 100% reliable and secure.

In the end we went with a third party...

Igor Micev (12/13/2016)

---

If you install SQL Server 2016 then you'd be much better. The Standard is very close to Enterprise. Find them here https://msdn.microsoft.com/en-us/library/cc645993.aspx

For SQL Server 2014 find this reference...

I have done a little research and not found any setting that can keep this under control. From what I have read up until now though the records contained...

MattF (12/13/2016)

---

There is no SSISDB catalog - and no SSIS activity other than the Data Collections. Its clear that the MDW is generating the millions of rows - the values...

Hi Matt,

are you using the SSIS Catalog? If so it may be worth having a look at the Catalog Properties.

The standard value for Retention Days is 365 and when...

I think there are far too many complex solutions to a relatively simple Problem here.

Why not simply create a COPY_ONLY backup on the prod System and ROBOCOPY it to the...