Val Urban (9/11/2015)

---

I would consider BULK INSERT command to use in such trivial cases.

It could be automated to populate many tables in parallel instead of running sequentially SSIS packages.

Thanks! Nice...

I just used BIML for the first time in a new project. Pretty pleased with the results except for one thing:

It's really hard to get help! I got...

Important

The ORDER BY clause...

Edward.Polley 76944 (3/6/2013)

---

I am a big fan of the 2 temp table approach and wrote about that on a previous article published at SQL Central. The difference here is...

David Walker-278941 (3/6/2013)

---

But!!!!!

ORDER IS IGNORED IN A VIEW, starting with SQL 2005. Even with Top 100 Percent specified, starting with (I believe) SQL 2008. See Books Online and...

jims-723592 (3/6/2013)

---

Why keep counts at all?

Let all logic live in the view, then while any entry in the view, remove

ALTER PROCEDURE [dbo].[usp_VTrickleDeleteEvent]

AS

SET NOCOUNT ON

SET QUOTED_IDENTIFIER OFF

BEGIN

WHILE exists (Select 1...

P Jones (3/6/2013)

---

Itzik Ben-Gan teaches

WHILE 1=1

BEGIN

DELETE TOP (5000) FROM table WHERE .....

IF @@ROWCOUNT < 5000 BREAK

END

and you can add a WAITFOR to delay between iterations

Adjust the 5000 to suit your...

Hey Perry,

Any general recommendations on network latency vs synchronous/asychronous AOAGs? e.g. if the link between two dbs has a network latency of 10 ms, is that too long...

joepacelli (8/31/2015)

---

One of the items I know I am tasked to perform will be designing the backend database, creating the SSIS scripts to extract the data from existing xls and...

joepacelli (8/31/2015)

---

I've start a new job as a contractor for a company for a new project.

I'm setting up my development PC and everything here requires you to request software you...

Eric M Russell (8/28/2015)

---

g.britton (8/28/2015)

---

Eric M Russell (8/28/2015)

---

g.britton (8/28/2015)

---

SQL Server has been tightly integrated with various forms of NoSQL data...

Eric M Russell (8/28/2015)

---

g.britton (8/28/2015)

---

SQL Server has been tightly integrated with various forms of NoSQL data storage and query access...

xsevensinzx (8/28/2015)

---

David.Poole (8/27/2015)

---

Hive and Pig both generate map reduce code under the hood. Where optimisation is required you can grab the output code and adjust it to your needs.

Hive...

Found the problem: As simple as a typo in the servername!

Fixed the typo, all works as designed. I can configure the SmtpServer, the ConnectionString or both.

Pity that the...

yup!