Viewing 15 posts - 3,676 through 3,690 (of 9,712 total)
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
Please be more detailed on where the error is coming from and what the error says.
What type of configuration are you trying to create? (XML, Table, etc.) and where...
March 13, 2013 at 8:21 am
AEdel (2/25/2013)
[25-Feb-2013 01:10:17] PHP Warning: odbc_connect(): SQL error: [Microsoft][SQL Native Client]Named Pipes Provider:...
February 26, 2013 at 4:19 am
Abu Dina (2/14/2013)
Maybe this?
SELECT ordertotalFROM #MoneyTest
where ordertotal - round(ordertotal, 2) > 0
Oh. You want me to use the SIMPLE solution. 😀
<headdesk>
Really? I had to make things THAT difficult for myself?
Thanks,...
February 14, 2013 at 9:48 am
Why can't you just change your IF statement?
February 14, 2013 at 9:22 am
Grant Fritchey (2/14/2013)
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
February 14, 2013 at 5:04 am
Viewing 15 posts - 3,676 through 3,690 (of 9,712 total)