kevaburg (12/31/2016)

---

Phil Parkin (12/31/2016)

---

The reason I said this is because of this statement......

As a general...

Here is a direct quote from the Microsoft recommendations:

Create as many files as needed to maximize...

Jeff Moden (12/31/2016)

---

kevaburg (12/31/2016)

---

I experienced performance regression after a migration project due to differing collations between the source database and tempdb. As I prepared the Server for the Migration...

BOR15K (12/30/2016)

---

ThomasRushton (12/30/2016)

---

y'know, that was my first answer... but I...

This is an interesting one. Please post your solution, Thom, when you manage it (I have confidence ...!)

I've already played around with various Row_Number() ideas to no avail.

Further to Thomas' answer, the flippant answer given by many people here would be 'in the garbage'.

That's because if your table is being updated while a (NOLOCK) query is...

ramyours2003 (12/29/2016)

---

I need to recommend tempdb files how many needs to created , can nay suggest to recommend how many files needs to be there or else...

What do you mean by 'fixed', exactly?

Do you just want to ignore the bad rows, or something more?

An alternative approach to Drew's is to read the file in as a...

guaro5555 (12/28/2016)

---

Hi gurus

I am new to this as you can tell by my postings but trying to get a hang, so go easy on me.

I am looking...

Note also that

CASE WHEN height IS NULL THEN 0 ELSE 1 END

may be shortened to

IIF(Height IS NULL, 0, 1)

Nice, Alan. I saw the word 'split' and I was off like one of Pavlov's four-legged friends. Did not even consider alternatives.

mcfarlandparkway (12/27/2016)

---

Set based approach? How to do this?

How to parse(split) this 9000430944:7|Information

-> 9000430944 - emp number

-- 7 - stud number

--Information - Description

How to split on pipe? and How to...

mcfarlandparkway (12/27/2016)

---

In the stored procedure - I need to implement a loop based logic after update statement ..

Now I have to add a logic in this stored procedure

after update...

mcfarlandparkway (12/27/2016)

---

Hello,

I have data from two different sources - Source1 and Source2 - we have a dtsx package where it loads...

wweraw25 (12/27/2016)

---

Yes you are right. I have a two date fields to compare.

But whats the thing I should do in SSIS to achieve this since it is across different...