300mb of data should load in no time flat, but you seem to be going at it the hard way.

If the input file is to simply be inserted into a...

Jeff Moden (10/8/2013)

---

Matt Miller (#4) (10/8/2013)

---

While I don't necessarily disagree with the discussion - it's important to remember that complex is often a point of view. Jeff , what...

Jeff Moden (10/8/2013)

---

logitestus (10/8/2013)

---

I run into this type of problem everywhere I have worked. Someone states "this is the way to do it" because they saw X% faster performance....

You're looking to use SQL Agent as the scheduler. Just use the following article to decide which way you want to schedule the job:

http://technet.microsoft.com/en-us/library/ms141701.aspx

Sean's syntax would allow you to check to see if the view returns anything. If you're looking to find out if specific columns are not null, you'd have to...

RonKyle (8/21/2013)

---

As a VB Programmer, I developed a lot of processes using disconnected recordsets. I used stored procedures to retrieve the initial sets. However, the additions and changes...

GilaMonster (6/12/2013)

---

It's not a good...

LutzM (6/11/2013)

---

my guess would be the WHILE loop *cough* being the reason for locking.

Depending on the value of @recipientcount it might take a while to perform all those single row...

Kingston Dhasian (6/6/2013)

---

dwain.c (6/5/2013)

---

Stefan Krzywicki (6/5/2013)

---

Don't you hate it when you finally figure out a solution for a difficult problem and it creates 5 more problems that the old way...

Is Business analysis speak, a non-functional DBA would mostly be concerned with performance and security (i.e. the "non-functional requirements"). Of course I...

One more option might be to use CLR integration, to get at the JAR from one of the integration libraries (such as IKVM). This will make the parameter passing...

While SQL Server could no doubt hold that data, it would be only a part of the solution.

The User interface part would have to be provided somehow,...

I think you're looking for something like this.

;with ct1 as

(select

name

,Duration, 2 as rank

from #temp

), ct2 as

(

select

name

, sum(Duration) as value

, 'Duration' as category,

, 1 as rank

from ct1

group...

ejoell 66477 (4/29/2013)

---

Wow. Many issues and comments.

One issue concerning asking applicant how to resolve a situation. That's how I got my first two jobs in the field. ...

Grant Fritchey (4/26/2013)

---

jasona.work (4/26/2013)

---

I just going to hope we don't get mocked on Saturday for wearing our Red Wings jerseys...

As for smuggling back Canucks, do we want the hockey players...