Viewing 15 posts - 5,746 through 5,760 (of 8,755 total)
With due respect, this is starting from the wrong end, one should not focus on technical but business quantifiable for overall quantities and sizes, from there its all either division...
April 6, 2015 at 12:07 pm
Quick questions, can you post the actual execution plans for the two queries? Are the statistics up to date?
😎
There are quite few things that can affect this kind of query,...
April 6, 2015 at 12:03 pm
Have you disabled Named Pipe and made certain TCP/IP is enabled? The error is typical of such an issue.
😎
April 6, 2015 at 11:43 am
Quick suggestion, try Adam Machanic's Who is Active
😎
April 6, 2015 at 11:36 am
Ed Wagner (4/6/2015)
Eirikur Eiriksson (4/6/2015)
patricklambin (4/5/2015)
April 6, 2015 at 11:25 am
Luis Cazares (4/6/2015)
SELECT
TB.DiaryID
,TA.MedicalCodeID
FROM dbo.TableA TA
JOIN dbo.TableB TB ON TB.EmisCode LIKE TA.EmisCode +...
April 6, 2015 at 11:22 am
Revenant (4/6/2015)
Ed Wagner (4/6/2015)
Eirikur Eiriksson (4/6/2015)
Ed Wagner (4/6/2015)
Eirikur Eiriksson (4/6/2015)
Ed Wagner (4/6/2015)
Revenant (4/6/2015)
djj (4/6/2015)
crookj (4/6/2015)
djj (4/6/2015)
Ed Wagner (4/6/2015)
djj (4/6/2015)
TomThomson (4/4/2015)
Eirikur Eiriksson (4/4/2015)
Revenant (4/4/2015)
Eirikur Eiriksson (4/4/2015)
TomThomson (4/4/2015)
crookj (4/3/2015)
djj (4/3/2015)
HouseCards
pontoon
Catamaran
Sail
Mast
Pole
Flag
Wave
WAC
1978 (Disbanded)
Grease
Musical
Broadway
Night
Opening
Act
Intermission
Music
Score
April 6, 2015 at 11:11 am
Quick question, are you using Full Text Search / Indexing?
😎
April 6, 2015 at 10:55 am
Ed Wagner (4/6/2015)
Eirikur Eiriksson (4/6/2015)
Ed Wagner (4/6/2015)
Revenant (4/6/2015)
djj (4/6/2015)
crookj (4/6/2015)
djj (4/6/2015)
Ed Wagner (4/6/2015)
djj (4/6/2015)
TomThomson (4/4/2015)
Eirikur Eiriksson (4/4/2015)
Revenant (4/4/2015)
Eirikur Eiriksson (4/4/2015)
TomThomson (4/4/2015)
crookj (4/3/2015)
djj (4/3/2015)
HouseCards
pontoon
Catamaran
Sail
Mast
Pole
Flag
Wave
WAC
1978 (Disbanded)
Grease
Musical
Broadway
Night
Opening
Act
April 6, 2015 at 10:53 am
Ed Wagner (4/6/2015)
Revenant (4/6/2015)
djj (4/6/2015)
crookj (4/6/2015)
djj (4/6/2015)
Ed Wagner (4/6/2015)
djj (4/6/2015)
TomThomson (4/4/2015)
Eirikur Eiriksson (4/4/2015)
Revenant (4/4/2015)
Eirikur Eiriksson (4/4/2015)
TomThomson (4/4/2015)
crookj (4/3/2015)
djj (4/3/2015)
HouseCards
pontoon
Catamaran
Sail
Mast
Pole
Flag
Wave
WAC
1978 (Disbanded)
Grease
Musical
Broadway
Night
April 6, 2015 at 8:42 am
guy3145 (4/6/2015)
when the server is "stuck" the output from your query is:total_mem_mb= 30719
avail_mem_mb=9262
avail_mem_prc=30.15
seems ok, right?
do you have some queries to check I/O latency in sql?
thanks!
guy
Suggest you increase the max mem,...
April 6, 2015 at 5:02 am
patricklambin (4/5/2015)
April 6, 2015 at 4:07 am
guy3145 (4/6/2015)
the minimum memory is set to 0
the maximum memory is set to 10GB. we tried to increase the maximum to 16gb that...
April 6, 2015 at 4:01 am
Steve JP (4/6/2015)
I don't...
April 6, 2015 at 3:41 am
koti.raavi (4/5/2015)
Please see below query
Select ID, ID1,Name, Cname from Customer where ID =(@IDSearch) or ID1 =(@Idsearch)
When i run above query took around 3 mins, i...
April 6, 2015 at 3:36 am
Viewing 15 posts - 5,746 through 5,760 (of 8,755 total)