Viewing 15 posts - 361 through 375 (of 2,894 total)
Lynn Pettis (5/30/2013)
Okay, rereading everything. The first record that is counted starts the 60 minute window, subsequent records that are overlapping do not extend the window.This correct?
100128138100251211752013-05-16 16:43:51.000
100128138100251332812013-05-23 17:53:46.000
100128138100251332812013-05-23...
May 30, 2013 at 9:52 am
Luis Cazares (5/30/2013)
GilaMonster (5/28/2013)
WangcChiKaBastar (5/28/2013)
our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).
Use one of the snapshot isolation levels. Financial or...
May 30, 2013 at 9:28 am
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...
May 30, 2013 at 8:34 am
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...
May 30, 2013 at 5:19 am
It's a very bad idea to call a batch from a trigger synchronously.
I would recommend using SQL Server Service Broker instead.
May 30, 2013 at 5:14 am
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)
May 30, 2013 at 5:12 am
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...
May 29, 2013 at 11:18 am
...
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...
May 29, 2013 at 10:51 am
Mark Harley (5/29/2013)
Any other combination?
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...
May 29, 2013 at 10:46 am
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...
May 29, 2013 at 10:44 am
Mark Harley (5/29/2013)
May 29, 2013 at 10:23 am
...
Any nice ways to make a empty copy of a table including indexes ?
...
There is one I know.
Develop your own utility to do so.
Here is the link where you...
May 29, 2013 at 10:17 am
Nolock is a way of telling SQL Server that you don't mind if your data is slightly incorrect
...
Yeah, it can for example double count records:
Slightly incorrect in this case would...
May 28, 2013 at 10:29 am
WangcChiKaBastar (5/28/2013)
for sometime now we are experiencing timeouts inspite of NOLOCK hint
I thought with...
May 28, 2013 at 10:22 am
Viewing 15 posts - 361 through 375 (of 2,894 total)