Viewing 15 posts - 286 through 300 (of 341 total)
Paul White NZ (3/20/2010)
Peter Trast (3/20/2010)
Really? How can that be? The idea of...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 4:05 pm
Another lucky guess 🙂
When you pipe the results out to a text file, you get:
StringA,StringB
hello ,hello (one space after first hello)
hello ,hello ...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 3:28 pm
"Dropping and rebuilding a clustered index on a partition scheme may move data to other drives. " ?
Really? How can that be? The idea of the partition is to locate...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 2:45 pm
wbeaton-664441 (3/18/2010)
"Reducing the physical size of a log file requires shrinking the file."
You can truncate a transaction...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 2:31 pm
I cannot tell a lie... I ran the code before answering this one. 😛
I wanted to pick '1234567890' but I wanted to prove I was "right" first. What a surprise!...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 2:28 pm
I got lucky and guessed the one with all of the text... 🙂
I am not seeing why the concatenation of the inserts occurs... can someone break this down further??
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 2:07 pm
Great question Julie, even if the explanation was not exactly right. I was unaware of this behaviour, and THAT is the point of asking and discussing it 🙂
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 10:01 am
vk-kirov (12/17/2009)
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 9:52 am
I had my 14 year old solve it 😛
I gave it to her without the SQL code and she did a standard alphabet/number decode... I am going to try it...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 9:26 am
CirquedeSQLeil (3/20/2010)
Paul White NZ (3/19/2010)
CirquedeSQLeil (3/19/2010)
I'll award back points later for everyone on this one since it's not really a fair question, but thanks for all the comments.
That would be...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 20, 2010 at 8:42 am
It is always a GREAT question when something new (for me) is in it!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 19, 2010 at 5:46 pm
brdudley (3/19/2010)
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 19, 2010 at 10:14 am
🙂
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 19, 2010 at 10:07 am
Always pick the first choice when you have no idea 😀
I hate that too...!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 18, 2010 at 6:47 pm
Viewing 15 posts - 286 through 300 (of 341 total)