Viewing 15 posts - 5,866 through 5,880 (of 8,753 total)
Frankie-464050 (4/1/2015)
SUCCESS 🙂The offender was on an XP box
It was a custom entry in the host file
C:\Windows\System32\drivers\etc\hosts\
That was pointing to a retired server
What a hair puller
I would rephrase...
April 1, 2015 at 11:00 pm
Bill-89778 (4/1/2015)
It is on Windows 2008...
April 1, 2015 at 10:26 pm
Little bit of giggle but more like crypto 101 with some artificial complexity sprinkled on top;-)
😎
April 1, 2015 at 1:05 pm
Jack Corbett (4/1/2015)
I don't need a special day to be Fool. I can accomplish that anytime:-P
Point taken and I must say that I appreciate the honesty :hehe:
😎
April 1, 2015 at 1:01 pm
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
April 1, 2015 at 12:57 pm
djj (4/1/2015)
Ed Wagner (4/1/2015)
Revenant (4/1/2015)
Steve Jones - SSC Editor (4/1/2015)
SmileHeart
Valve
Steam
Ship
April 1, 2015 at 12:55 pm
Quick thought, this is NOT a tuning task, this demands a complete rewrite! Anything with the cardinality in excess of 10^12 going through both HASH MATCH 8 times, apart from...
April 1, 2015 at 12:52 pm
Few more questions (bear with me), When was it moved to ESXi 5.5.0? Windows OS version? Recent upgrades/updates? Which drivers does VB use? Was this originally on SQL 7.0?
😎
April 1, 2015 at 12:30 pm
dwain.c (3/31/2015)
CELKO (3/31/2015)
Abend? Jeez, now there's a word I haven't heard since I was using IBM 360 JCL!
LOL! Remember the quote: "OS/JCL makes sense after you have studied...
April 1, 2015 at 11:58 am
Quick questions, have you checked all log files? Are only updates failing while other activities (insert / delete) are working?
😎
Had a similar issue way back, turned out to be a...
April 1, 2015 at 11:07 am
Abhijit More (4/1/2015)
Eirikur Eiriksson (4/1/2015)
April 1, 2015 at 9:14 am
SQLRNNR (4/1/2015)
Who remembered to do an April Fools post today?
Being modest this year, I only posted one question😀
😎
April 1, 2015 at 9:06 am
You can use the free version of SQL Sentry Plan Explorer to obfuscate it.
😎
April 1, 2015 at 9:01 am
djj (4/1/2015)
crookj (4/1/2015)
Ed Wagner (4/1/2015)
crookj (3/31/2015)
Eirikur Eiriksson (3/31/2015)
Ed Wagner (3/31/2015)
Eirikur Eiriksson (3/31/2015)
crookj (3/31/2015)
whereisSQL? (3/31/2015)
Eirikur Eiriksson (3/31/2015)
Ed Wagner (3/31/2015)
Revenant (3/31/2015)
Ed Wagner (3/31/2015)
djj (3/31/2015)
Ed Wagner (3/31/2015)
crookj (3/31/2015)
Ed Wagner (3/31/2015)
TomThomson (3/31/2015)
Eirikur Eiriksson (3/30/2015)
SQLRNNR...
April 1, 2015 at 7:23 am
Quick suggestion, add a clustered index to those heaps and look into indexing them, the table scans are more than 80% of the cost.
😎
April 1, 2015 at 7:21 am
Viewing 15 posts - 5,866 through 5,880 (of 8,753 total)