Yes you can install multiple instances of SQL Server on the same machine, those would be named instances. And yes each one will need its own database and log...

xsevensinzx (9/28/2015)

---

Andrew..Peterson (9/28/2015)

---

xsevensinzx (9/28/2015)

---

ZZartin (9/28/2015)

---

xsevensinzx (9/28/2015)

---

What makes it 10x worse is that while you can verify everything is good with your end result, someone can take that end result (i.e.:...

Leaf

xsevensinzx (9/28/2015)

---

What makes it 10x worse is that while you can verify everything is good with your end result, someone can take that end result (i.e.: data) and use it...

Tavis Reddick (9/28/2015)

---

For an in-house system with just over 10,000 records in the main entity table, I created a set of stored procedures of the following pattern:

For each entity (table,...

You might be able to use mail merge in Word to generate the documents, you can merge a csv extract or a table or view for that matter into a...

Steve-3_5_7_9 (9/25/2015)

---

Your direct question has already been answered, however the audit will probably turn up a couple of things:

If they stole the diff backup, why wouldn't the full backup be...

Maybe something like,

DELETE FROM [TableName] WHERE id IN(

SELECT id FROM [TableName] GROUP BY id HAVING COUNT(id) > 1

UNION

SELECT id FROM [TableName] WHERE [no] IN (SELECT [no] FROM [TableName] GROUP BY...

Is there a reason to join to the CTE instead of just putting the rank function in the SQL query?

Try taking the AND H1.[Dense Rank] = 1 out of the join on the select and see what happens 🙂

It looks like it might be joining the dense rank 1...

That question is horribly vague, SQL server can stores TB's or PB's of information, depending on what format that data is in that could be enough to hold all the...

Dave62 (9/21/2015)

---

Jack Corbett (9/21/2015)

---

... Even though I'm considered a permanent FTE by HR, I consider myself a contractor with benefits. They can get rid of me...

call.copse (9/21/2015)

---

re: MySQL I'm going to say the licence cost issue is a big one these days, and seems to be more onerous than it has been. I've not had...

IF @QuantityID IS NOT NULL

INSERT INTO @Temp SELECT @QuantityID

IF @LengthID IS NOT NULL

...

Card