Viewing 15 posts - 16 through 30 (of 81 total)
PHYData DBA (4/29/2014)
April 29, 2014 at 7:34 am
April 29, 2014 at 7:24 am
Yep, it left a bit to the imagination. Sadly I imagined wrong. If In-Memory wasn't relevant it really shouldn't have been mentioned because the question came across like it was...
April 29, 2014 at 5:27 am
I don't understand. I chose the last option, 'Alter all queries to use the trace flag 9481', which this page says will force use of the old version 70 optimiser....
April 29, 2014 at 4:22 am
Also if I paste either result into Notepad GO is on the same line. I had a feeling this would happen, but had no idea the engine wouldn't care for...
April 9, 2014 at 8:36 am
Thanks Jeff, makes sense. If someone asked me to right justify some text I think the quicker solution would be closer to what I would have attempted anyway as i'm...
January 7, 2014 at 7:13 am
Sorry if I'm just being dense by asking this, I've never used STR() either so this is new to me. The article says many people use STR() for its ability...
January 7, 2014 at 4:27 am
With regard to the badges themselves, our badges used to contain the company logo etc on them, in addition to the person's name and photo. Now they just contain the...
October 17, 2013 at 11:48 pm
I'm firmly on the side of this sort of thing not being being something you can patent. Patenting the means to snip, maybe. Patenting what has been snipped, no. That...
April 24, 2013 at 8:12 am
I have none 🙁
Feel free to send me one though 🙂
September 14, 2012 at 5:47 am
I think it's a terrible system. This means you could have a room full of the best and brightest, all of whom would be a '5' in a random sample...
July 20, 2012 at 2:42 am
Thanks for elaborating on the complexities of this issue. I do appreciate any resolution that I would class as a fix would have negative side-effects as parameter sniffing is,...
March 7, 2012 at 9:26 am
Eugene Elutin (3/7/2012)
March 7, 2012 at 5:12 am
Lynn Pettis (3/6/2012)
March 7, 2012 at 2:32 am
Eugene Elutin (3/6/2012)
...Dynamic SQL is not an option as the industry I work in is quite security conscious, so I am not allowed to code for that
Are you allowed...
March 7, 2012 at 2:26 am