Viewing 15 posts - 586 through 600 (of 832 total)
GilaMonster (1/7/2011)
Try them out with statistics IO on and compare the logical reads with the number of pages in the table.
I just did that test and I got 2 reads...
January 7, 2011 at 4:07 am
Confirmed--I get as far as logging in now, but the page that comes up once I've logged in just says "Sorry, an error has occurred".
January 7, 2011 at 3:35 am
The guys who write SQL Server think of everything, it seems!
January 7, 2011 at 2:52 am
Out of sheer curiosity: you mention that a hidden 4-byte column is added to the clustered index key to make it unique in the event that it is not. Let's...
January 7, 2011 at 2:29 am
AD7 (1/7/2011)
Thanks Gail. Brilliant article. Can't wait for part 2 and 3.
You don't have to wait for them, they're linked right there at the end of this one! 🙂
January 7, 2011 at 2:09 am
Yes, but my point was that he made a point about him liking the ability to install MySQL on his XP machine and have multiple different versions installed at the...
January 5, 2011 at 7:37 am
I dunno, I thought that he was deliberately missing stuff out. For instance, if you want a fully-featured Enterprise Edition of SQL Server to run on Windows XP, you can...
January 5, 2011 at 7:31 am
Just tested this from my Nokia e63 (Symbian) and got a 404...intentional, or not?
January 5, 2011 at 1:01 am
sjimmo (12/29/2010)
WayneS
On my system, the last select starts with 328417.
Sorry Wayne,
On my system I get:
SELECT TOP (5) * FROM #Test WHERE RowID > 5000; - 5001
SELECT TOP (5) *...
December 29, 2010 at 6:38 am
Not so sure about the explanation given--smalldatetime doesn't have a "default value" of 1 Jan 1900, it's just that the underlying number that stores the date uses 0 to represent...
December 29, 2010 at 2:17 am
Jeff Moden (12/28/2010)
I just love the way companies like MS force you to upgrade... at gunpoint. They'll still sell you stuff so it's not like they're all holy about...
December 29, 2010 at 1:05 am
Koen (da-zero) (12/28/2010)
We have some other type of alcohol, called "jenever" (no idea what the English translation is) and that type of drink can have many flavours.
Apparently it's known as...
December 28, 2010 at 9:57 am
Will1922 (12/28/2010)
Hmm. Turn off their antivirus for better game performance? Seems like a no-brainer for me. Not just better performance on Steam, but any game would...
December 28, 2010 at 9:54 am
mtassin (12/23/2010)
Just FYI, different Operating systems do it differently anyway.
I'm pretty sure Unix/Linux doesn't put both CR and LF (Carriage Return and Line Feed) characters at the end of a...
December 24, 2010 at 4:27 am
Sometimes there's nobody to ask, though. I work for a small company that has only 3 IT people, and not all of us have the same level of expertise in...
December 23, 2010 at 6:54 am
Viewing 15 posts - 586 through 600 (of 832 total)