Just curious but what other databases are on that server? That sounds like a lot of hardware for only a 50GB database.

Not that that would be related to bad...

My reaction is totally "Meh". It might be fun to spin up a linux VM and install express to mess around with or do some minor website things.

I'm sure...

There's certainly nothing stopping you from using columns in one able to reference another table without making it an official foreign key. You would just have to rely on...

dranostaj (1/10/2017)

---

In recent years, justifying the cost vs the benefit of Oracle is becoming increasingly harder, which is why I believe MS SQL is taking off. If I was...

Bowl

Is this more what you're looking for? This will keep the first set of records within the earliest hour for each Id on one day.

WITH TEMP_CTE AS(

SELECT *,...

mcfarlandparkway (1/4/2017)

---

we have a job(ssis package) where it load data from different source and destination is temp table. from temp table I have to move to main table.

selecting rec from...

Just out of curiosity why are you doing this,

insert into main table( col1,col2)

select col1,col2 from temp table

In a cursor where you're setting from the same temp table?

Eric M Russell (1/4/2017)

---

The key to job security is insuring that you're never just a cog in a process. If you're just a cog in a specific process, then your...

Terminator

I find it hard to believe you could open a second session and start it at exactly 10 seconds after the first query was executed.

Gary Varga (1/4/2017)

---

I feel that security by financial institutions are not keeping pace. I can understand caution and not implementing every security idea that comes along, however, many of the...