Viewing 15 posts - 1,171 through 1,185 (of 1,240 total)
GilaMonster (2/3/2014)
BWFC (2/3/2014)
I'm personally surprised not one of the auditors has said something like 'about these nolocks...'
No, they won't. Most aren't technical and won't have any idea of the implications....
February 3, 2014 at 7:00 am
GilaMonster (2/3/2014)
BWFC (2/3/2014)
I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did.
If you have...
February 3, 2014 at 6:39 am
I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did. My boss or...
February 3, 2014 at 5:58 am
Jeffrey Williams 3188 (1/31/2014)
The distinct will only...
February 3, 2014 at 5:21 am
ChrisM@Work (1/31/2014)
I hope you can take away a few ideas from it though,...
January 31, 2014 at 10:43 am
ChrisM@Work (1/31/2014)
January 31, 2014 at 7:47 am
Ed Wagner (1/31/2014)
Jeff Moden (1/30/2014)
Ed Wagner (1/30/2014)
Luis Cazares (1/30/2014)
Jeff Moden (1/30/2014)
"JOCC BOOSTR" (pronounced "jock booster")Definition:
Justification Of Crap Code Based Only On Small Table Requirements
🙂
Everywhere
Pervasive
Infectious
Pandamic
Endemic
January 31, 2014 at 6:28 am
No, I mean the difference in row counts between the procedure and view, the problem that we're trying to solve.
Of course you did, sorry, conference call brain fry.
There is no...
January 31, 2014 at 6:11 am
GilaMonster (1/31/2014)
Can't see anything obvious (other than multiple unnecessary DISTINCTs)Is the difference in rowcount consistent?
If you mean 'is the difference in ServiceDays and AverageServiceDays the same every time' then yes....
January 31, 2014 at 4:25 am
Fair enough, although I'm a little hurt you don't trust me.... 🙂
The code to create the dashboard with the proc
set transaction isolation level read uncommitted
set dateformat ymd
select distinct
OrderType =
case...
January 31, 2014 at 3:41 am
I've attached the code now. I've had to do a bit of obfuscation, which I hope doesn't hide the logic. The organisation I work for is quite high...
January 31, 2014 at 3:29 am
Kurt W. Zimmerman (1/28/2014)
Ed Wagner (1/28/2014)
L' Eomot Inversé (1/28/2014)
crookj (1/28/2014)
Ed Wagner (1/28/2014)
BWFC (1/28/2014)
DrinkRestaurant
Jocko's Steak House
Rib Eye Steak
Medium rare
à point
Blue
January 29, 2014 at 1:32 am
L' Eomot Inversé (1/24/2014)
Ed Wagner (1/23/2014)
BWFC (1/23/2014)
JAZZ Master (1/22/2014)
Revenant (1/22/2014)
Ed Wagner (1/22/2014)
SQLRNNR (1/22/2014)
simCity
bestseller
novel
New
Clean
Sterile
Aseptic
January 27, 2014 at 2:02 am
Hi Sean
I've had a tinker with my proc and using the CTE approach works just as quickly as temp tables when using my method to create the combined column. ...
January 24, 2014 at 4:14 am
Viewing 15 posts - 1,171 through 1,185 (of 1,240 total)