100128138100251211752013-05-16 16:43:51.000

100128138100251332812013-05-23 17:53:46.000

100128138100251332812013-05-23...

Luis Cazares (5/30/2013)

---

GilaMonster (5/28/2013)

---

Use one of the snapshot isolation levels. Financial or...

Cursor/loop based solution given by Mister.Magoo is fine, but will suffer performance issues if you need to process large dataset at once.

As I have said before "quirky update" would do...

Is it one off task?

There are few ways to speed up deletes. You can choose one depending on your exact circumstances.

1. Copy records you want to leave into new...

It's a very bad idea to call a batch from a trigger synchronously.

I would recommend using SQL Server Service Broker instead.

For a start you better to do following two things:

1. Format your query into more readable form - use indent, otherwise code looks like noodles.

2. Remove NOLOCK hints (http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx)

It's easy to do in SQL2012, harder in 2008.

You didn't specify what determines a patient type, so I took that it is a "endcallcd", as you did partioned by this.

The...

...

Took a quick look at it, don't like it as it uses the INFORMATION_SCHEMA views. The MS SQL system views provide much more information that is valuable to fully...

Mark Harley (5/29/2013)

---

These are the possible combinations:

[1-6][A-Z]

[1-6][A-Z][A-Z][A-Z]

[1-6] + [1-6][A-Z][1-6][A-Z]

I'm beginning to wonder if this is something that should be handled in the application, and then passed through to...

I prefer to use calendar tables for these sort of thing (as it may be required to count in bank holidays and other off-days):

Example of small dedicated calendar table dedicated...

Mark Harley (5/29/2013)

---

I have a variable that gets set by a user on a web form, and the user can set that value to something along the lines of '2K...

There is one I know.

Develop your own utility to do so.

Here is the link where you...

Process large xml in chunks.

Yeah, it can for example double count records:

Slightly incorrect in this case would...

WangcChiKaBastar (5/28/2013)

---

we have a high activity transactional database and we have put NOLOCK hints on all SELECT statements...

for sometime now we are experiencing timeouts inspite of NOLOCK hint

I thought with...