Further on J L's fine answer, use CTEs if the structures/data types do not match

😎

kevin.obrien 66193 (11/9/2016)

---

Hi, any reason why...

Beatrix Kiddo (11/9/2016)

---

Not quite true- if you work in a bank or other high security...

krypto69 (11/9/2016)

---

Hi,

I created an SSIS package that uses an OLE DB Source - pointed to a DBF file.

Problem is the name of my DBF changes.

The files will always have...

Two thoughts on this one, DON'T use any Maintenance Plan Wizard thingy, secondly DO use Ola Hallengren's Maintenance scripts[/url].

😎

All the stuff you want to backup are stored in the system...

mcfarlandparkway (10/5/2016)

---

I have a question to clear.

We are trying to implement a common package(Generic one) doing everything based on parameters (Which database to go and which source to go etc..)...

John Mitchell-245523 (11/9/2016)

---

Other reasons not to allow users to RDP on to the server:

(1) If users don't have access to log directly on to the server, you have a more...

kevin.obrien 66193 (11/9/2016)

---

The problem I now have is that there are multiple FKs in the Fact table pointing to the one Dim table.

Is this ok? Or is there a better,...

Quick question, have you tried to execute the statement within the first procedure and see if it is returning any value?

😎

Good point Grant, forgot to mention the Red Gate tools, DLM, source control and all the available articles, the tools/source control takes the support for generating differential scripts etc. to...

jporter 4363 (11/9/2016)

---

Hello friends,

Although very new, I have been assigned the task of going through a large (~10,000 line) stored procedure which apparently does all of the calculations for COGS...

You are very welcome.

😎

Packages can easily be edited in a text editor as far as one doesn't change script component's scripts which are build and stored in a compiled form.

😎

I think this is a bug in the very old sp_special_columns_100 procedure

😎

gisles (11/4/2016)

---

In our database we have a table with pdf documents linked as an ole object in a field. The field is not readable. We recently switched servers that the...