Viewing 15 posts - 3,031 through 3,045 (of 8,761 total)
Hi and welcome to the forum.
The EventTime has to be present otherwise the key doesn't hold. The bigger problem here though is the design, i.e. a full day event would...
October 23, 2016 at 4:49 am
If I understood correctly then this should do the job
😎
SELECT
TB.OYHSSQ
,TB.OYNMTP
,TB.OYNAME
,TB.OYADD1
,TB.OYADD2
,TB.OYCITY
...
October 23, 2016 at 4:39 am
Rechana Rajan (10/23/2016)
October 23, 2016 at 4:26 am
mah_j (10/23/2016)
Currently the index is just on invoiceuid,but because of lookup I test it with other columns too.But for both modes the logical io is high.
The second execution...
October 23, 2016 at 3:56 am
mah_j (10/22/2016)
October 23, 2016 at 2:27 am
GilaMonster (10/22/2016)
Eirikur Eiriksson (10/22/2016)
GilaMonster (10/22/2016)
Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.
This approach...
October 23, 2016 at 2:24 am
MVP_enthusiast (10/22/2016)
October 22, 2016 at 1:38 pm
Jeff Moden (10/22/2016)
Eirikur Eiriksson (10/20/2016)
Gazareth (10/19/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past😎
First line: "Version 4.2 also lets you nest triggers"
I didn't get any further due to blacking out;...
October 22, 2016 at 1:28 pm
GilaMonster (10/22/2016)
Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.
This approach could possibly leave...
October 22, 2016 at 7:43 am
patelxx (10/22/2016)
NUMBERED_INSTANCES AS
(
...
October 22, 2016 at 5:05 am
mah_j (10/22/2016)
HelloHow can I stop the long running query that is run from application?
I want to kill the queries that are running longer than 40 seconds.
Do you want to automatically...
October 22, 2016 at 3:56 am
patelxx (10/22/2016)
October 22, 2016 at 3:10 am
Hi
and welcome to the forum,
is there an option of doing this on the database side?
😎
There are several ways of passing multi value parameters, each has pros and...
October 20, 2016 at 10:53 am
Gazareth (10/19/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past😎
First line: "Version 4.2 also lets you nest triggers"
I didn't get any further due to blacking out; came to 10 minutes...
October 20, 2016 at 9:40 am
First a quick note, please read up on how to post questions on the forums as your data example has few problems, took longer to sort those than writing the...
October 20, 2016 at 7:44 am
Viewing 15 posts - 3,031 through 3,045 (of 8,761 total)