Yep, it's definitely not advisable, but various people in management have their own SA-level accounts attached to the server, and then there's the main SA-level account for management. Not...

Ah, gotcha! The majority of my post above can thus be discarded 😛

If you've got a table of only 10 rows, it depends quite heavily on what sort of...

This may bear correcting by someone more knowledgeable, but here's my understanding of your situation :-D.

First, were you using multiple threads for the update procedure on the application side, or...

... You know, now that I think about it... 😛

But eh, frustrating though it may be, I'll just have to get some climbing gear out and start scaling...

Oh geez. I feel quite operatic in the sense of this article lately 😛

The sysadmin here decided a few weeks back that the CPU usage of the SQL Server...

Oh goodness! Certainly, I'd be willing to speak with you about it :-D. Granted, it's all still very tentative in my head, but I'd gladly discuss my ideas...

Jim P. (7/29/2014)

---

Andrew Kernodle (7/29/2014)

---

Haha, I'm actually kinda giddy to take a shot at this now :-P. Well, planning, setup, and budgeting come first, so I'll try to cast...

(Note: This answer may need some correcting by others with more knowledge!)

Basically, by casting the date math as REAL, the subtraction being done is calculated with each date being...

Oh, definitely! The local college actually has quite a few conference rooms, ranging from holding 6 people to holding 400. One of my roommates was close with the...

Steve Jones - SSC Editor (7/29/2014)

---

That's an easy place to organize something.

There are Memphis and Nashville SQL groups that hold events and they'd come support you (I think). Huntsville,...

I'm in Chattanooga, Tennessee. There's actually a .NET usergroup that meets here monthly, and this month they had Kevin Boles here presenting. Missed the session entirely, unfortunately, thanks...

I attended my first SQL Saturday just this May, and it was quite the grand event :-D. Furiously scribbled a good two pages of notes, and sorely regretted not...

Hrm. It's been quite some time since I had to work on this issue; I believe this MSDN article may have some pointers:

Article

There's two different ODBC Data Source clients...

Gah. Yep, that sucks. Our company uses vendor software, and the vendors insist the same thing about my commentary on NOLOCK being added to everything in the coding...

Hrm. I wouldn't think that enabling forced parameterization would fix a table scanning issue; from my understanding, that helps in cases where your workload is almost entirely ad-hoc queries...