Viewing 15 posts - 2,611 through 2,625 (of 5,356 total)
I don't know the world Oracle exists in, but here in SQL Server land (and the rest of those RDBMS out there) NULL is not the same as an empty...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 12:59 pm
Yes, that's what I meant earlier. Here's a sample usage of dbcc page.
use pubs
go
dbcc traceon(3604)
go
dbcc page(5,1,88,1)
This is the result
DBCC-Ausführung abgeschlossen. Falls DBCC Fehlermeldungen ausgegeben hat, wenden Sie sich an den...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 12:43 pm
Well, rather than complaining on and on, we should wait for Brian Knight's post. Maybe there is a rationale ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 12:34 pm
As has been said before, copying a db while it is online is a bad, bad idea.
I once tried this, burned a CD to take it home and spent...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 8:54 am
Not sure if I understand you.
Do you mean the 16 byte root pointer in the data row or the actual size of the b-tree structure that stores the BLOB?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 8:50 am
Maybe this article will help you
http://www.sqlservercentral.com/columnists/RDyess/ospr.asp
Because of the formatting it is somehow difficult to read.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 8:16 am
We should have more of such questions...
I can't remember any other thread having such a huge number of first-time posters. ![]()
As for pseudo topic-related:
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 7:40 am
But may I suggest a balance: statistics are not completely manipulatable (is this in the dictionary?). But those who are proficient with them and understand how they were derived can...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 6:06 am
Can't you buy special support when having Windows 2000 Datacenter Edition that guarantees 99,9%+ availability. Think I read this somewhere.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 5:35 am
I'm sure you'll find what you need when searching through the script section. ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 5:32 am
Does this help?
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=246
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 4:39 am
You know when you are trying to teach your kids to behave properly part of it is getting them to speak properly (and the rest is teaching them when to...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 4:23 am
Hey, I'm at the office.
Sure I'm confused right now. I always argued the equities have a higher implicite risk than bonds or the german type called registered bonds. So...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 3:25 am
Bear with a slow german, Dave. What does this mean? ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 2:38 am
I like statistics ![]()
Especially those I have manipulated myself ![]()
It depends on whom you present your statistics to....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2004 at 1:18 am
Viewing 15 posts - 2,611 through 2,625 (of 5,356 total)