Viewing 15 posts - 166 through 180 (of 832 total)
These queries weren't in views, by any chance? Using SELECT TOP xxxxx (where xxxxx is a number far larger than the maximum possible rows ever expected to be returned by...
September 13, 2013 at 7:35 am
If you think about it, it has to work that way--otherwise, you'd be transferring the uncompressed data over the network in order to compress it, which would largely defeat the...
September 11, 2013 at 8:34 am
darkhelmutis (9/11/2013)
The question in the email defines @i as:
DECLARE @i TABLE( mychar VARCHAR(10));
The question provided on the page where you provide an answer defines @i...
September 11, 2013 at 8:07 am
L' Eomot Inversé (9/11/2013)I didn't bother to run the code when that turned out not to be the "correct" answer, what would be the point in doing that?
I did that...
September 11, 2013 at 3:36 am
Koen Verbeeck (9/11/2013)
Indeed. As if I'm going to count the number of characters in Steppenwolf.
Why not? I did, because I immediately thought the word looked too long for a 10-character...
September 11, 2013 at 2:26 am
krowley (9/10/2013)
But once again work experience is much easier to lie about than a certification. At least with the certification you have Something you can verify about a potential job...
September 11, 2013 at 2:09 am
Stefan Krzywicki (9/10/2013)
You're using a version that few people use. Most people stopped using that version when it changed itself to DBCC HAL9000.
I did wonder what that "missing monolith" warning...
September 10, 2013 at 9:08 am
SQLRNNR (9/10/2013)
What are 3 of the required parameters for DBCC Timewarp?
What are 7 of the optional parameters?
This is a trick question, right? Everyone knows that DBCC TIMEWARP doesn't take any...
September 10, 2013 at 8:58 am
I think the latest information to come out of Microsoft about the MCSM etc. cancellation shows precisely what Microsoft thinks their certifications are for--namely, they're there to help sell Microsoft...
September 10, 2013 at 3:58 am
Koen Verbeeck (9/10/2013)
Which means we have a 5 year anniversary coming up. Exciting!
Doesn't it mean the thread goes to school soon and we have to tearfully wave it away from...
September 10, 2013 at 2:34 am
natalie.ignatieva (9/9/2013)
I totally agree with you about that it's a feature and it's not a hazard.
I would say it's entirely possible for it to be both. Yes, it's a feature,...
September 9, 2013 at 3:26 am
As far as I'm aware, no version of SQL server actually requires Active Directory at all in order to function--you can install them on a standalone server if you wish....
September 4, 2013 at 2:41 am
Greg Edwards-268690 (9/3/2013)
Generally, on 32 bit, no single process can use more than 2GB from what I remember.
Depends. If the app has the LARGE_ADDRESS_AWARE flag set in its header, and...
September 3, 2013 at 8:29 am
Jan Van der Eecken (9/2/2013)
Not so sure about that. Yes, 64 bit Windows machines are able to run 32 bit versions of the same software, but they have to thunk...
September 3, 2013 at 2:59 am
Wow, did not expect that at all--why on earth would Microsoft make a system-level configuration procedure allow any old random garbage to work so long as it happens to be...
August 30, 2013 at 4:33 am
Viewing 15 posts - 166 through 180 (of 832 total)