Viewing 15 posts - 2,896 through 2,910 (of 5,685 total)
LutzM (6/24/2011)
One of the (undesired?) side effects: once you have a specific SET DATEFIRST in your batch, any following...
June 24, 2011 at 2:39 pm
This is a lot easier if we had some sample schema and test data to show you proven code. See the first link in my signature for help on that.
Generically:...
June 24, 2011 at 1:51 pm
All the data in the world doesn't have any value if it's not used. In a security context audit data isn't all that useful if it's only examined when an...
June 24, 2011 at 1:24 pm
jvskarthick (6/24/2011)
I have a variable and it’s used in my all stored procedure. I want to replace the variable value with new one. Is there a way we can replace...
June 24, 2011 at 1:08 pm
tfifield (6/24/2011)
Craig,I've ripped off a lot of your code. Nice to see I got one in!
Todd Fifield
:blush: Now, that's a compliment. Thank you. 🙂
June 24, 2011 at 1:06 pm
Hm, favorite drink?
At the moment, that would be a Sake Bomber with Sapporo... at least, that's what I'm looking forward to. I usually drink Stella, Heinekin, or Beck's.
June 24, 2011 at 12:43 pm
BCLynch (6/24/2011)
If my...
June 24, 2011 at 12:38 pm
Oliiii (6/24/2011)
A provider asked us how they could hide all their design from us (dba), the short answer is they can't....
June 24, 2011 at 12:34 pm
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an object...
June 24, 2011 at 12:23 pm
BCLynch (6/24/2011)
June 24, 2011 at 2:15 am
Jayanth_Kurup (6/20/2011)
Try lookup under the DFT
Wouldn't work for this. Lookup is a per-row operator and he needs to collapse the rows. The only way to do that is...
June 23, 2011 at 6:21 pm
GilaMonster (6/23/2011)
ORs are fully SARGable, they just require a very different indexing setup than AND. http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/Also note that the parser/algebratiser expands IN into a series of OR before optimisation begins.
Hmm,...
June 23, 2011 at 6:07 pm
:crazy: Erm, um... no?!
Okay, there's apparently a little confusion here. The log is going to fill, constantly, even over a restart in any recovery mode besides simple. In...
June 23, 2011 at 5:58 pm
I always point folks to this one:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
June 23, 2011 at 5:35 pm
This conversation resparked a curiousity on my part.
The following was tested in a 2k8 R1 environment off my local drives. End result, and if you read the notes you'll...
June 23, 2011 at 5:31 pm
Viewing 15 posts - 2,896 through 2,910 (of 5,685 total)