Viewing 15 posts - 3,661 through 3,675 (of 9,705 total)
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
Most monitoring tools at my workplace is stuff we built ourselves. Part of that is due to budget / corporate approval constraints. Part of that is the need for things...
March 28, 2013 at 12:17 pm
Did you say you ARE or ARE NOT able to open the server in SSMS and import the package that way?
Steps would be: Open SSMS, connect to Integration Services with...
March 28, 2013 at 12:12 pm
Viewing 15 posts - 3,661 through 3,675 (of 9,705 total)