Viewing 15 posts - 3,661 through 3,675 (of 9,707 total)
GilaMonster (4/18/2013)
Forum points: A measure of how much time is spend not doing productive work.
Hey! This is productive. (SET @PompousVoice = ON) I'm building my brand and borrowing solutions from...
April 18, 2013 at 7:57 am
Donna, welcome to the water cooler!
I understand your frustration. We try not to be as bad as other help forums, but sometimes things happen and we all apologize. [edited because...
April 18, 2013 at 6:37 am
jasona.work (4/18/2013)
Of course, everyone will then expect the last step to show them how to create a GUI front-end, just because...
Which is exactly what I can't do because I'm not...
April 18, 2013 at 6:11 am
Jeff Moden (4/17/2013)
Steve Jones - SSC Editor (4/17/2013)
Brandie Tarvin (4/17/2013)
April 18, 2013 at 4:24 am
Me too. Congrats, congrats. That's awesome, guys.
April 18, 2013 at 4:23 am
Steve Jones - SSC Editor (4/17/2013)
Brandie Tarvin (4/17/2013)
April 17, 2013 at 12:35 pm
So I have this ridiculous thought of doing a series of articles for my blog on how to build a SQL Server database for a comic book collection.
What do you...
April 17, 2013 at 12:24 pm
Lowell (4/16/2013)
non stop juggling of funds so I could...
April 17, 2013 at 12:22 pm
Stefan Krzywicki (2/15/2013)
Hey Brandie, speaking of your account problems, did you ever get the problem where you can't get DMs fixed?
No. I thought I was about to, but I never...
April 17, 2013 at 12:10 pm
Lewis,
My first thought (without testing) is that trigger might be causing some of your problem. If you have a sandbox / dev server, try disabling the trigger then running your...
April 17, 2013 at 8:23 am
Lewis,
There are several different issues here. The first is caching. SQL Server caches query execution plans for queries it doesn't remember or hasn't seen before, which always causes first-time-run queries...
April 17, 2013 at 7:58 am
opc.three (3/28/2013)
March 29, 2013 at 7:54 am
Sean Lange (3/28/2013)
kk1173 (3/28/2013)
discharged_entered is a date field.Then forget all the convert nonsense. Just compare it to a datetime.
c.discharge_entered_dt >= DATEADD(DAY, -14, getdate())
Sean, This won't necessarily work for him. If...
March 28, 2013 at 12:39 pm
kk1173 (3/28/2013)
Both tables (employer and case1)have the necessary indexes.
Something else to consider.
Are you absolutely 100% positive that the indexes are 1) being used by the query engine and 2) properly...
March 28, 2013 at 12:28 pm
First, try changing the JOIN to a more common version of the JOIN, which may (or may not) help.
SELECT Distinct
c.EMP_ID as ID,
e.name as Display
FROM Case1 c
INNER JOIN Employer e
ON...
March 28, 2013 at 12:23 pm
Viewing 15 posts - 3,661 through 3,675 (of 9,707 total)