Viewing 15 posts - 7,741 through 7,755 (of 14,953 total)
DateDiff returns an integer value. It won't give you fractions.
November 16, 2009 at 1:11 pm
Of course it "should just work", but so should everything else.
My car has an automatic transmission. My wife's has a manual. If I try to drive hers the...
November 16, 2009 at 12:56 pm
Put a break-point on the step, and there's a window at the bottom that'll have the values in it.
November 16, 2009 at 11:53 am
Jeffrey Williams-493691 (11/16/2009)
GSquared (11/16/2009)
If it has multiple peanuts, it's clustered. If it's just one peanut per database, then it's not. Seems simple to me.
What if you have a...
November 16, 2009 at 11:45 am
GilaMonster (11/16/2009)
Looks like someone needs a basic computer theory course.Clustering: http://www.sqlservercentral.com/Forums/Topic819325-146-1.aspx
SAN: http://www.sqlservercentral.com/Forums/Topic819323-146-1.aspx
RAID: http://www.sqlservercentral.com/Forums/Topic819327-146-1.aspx
I would like to apologize for my answers to all three of those... but I won't. 😀
November 16, 2009 at 11:21 am
If it has multiple peanuts, it's clustered. If it's just one peanut per database, then it's not. Seems simple to me.
November 16, 2009 at 11:20 am
Well, since "sans" means "without", "san" must be the singular for "without". So, if you database is running with one "without", then it's on a "san".
Or it could be...
November 16, 2009 at 11:17 am
Jeff Moden (11/13/2009)
November 16, 2009 at 7:22 am
You're welcome.
November 16, 2009 at 7:18 am
Just to confirm, the number of pages below which rebuild/reorg won't do anything is 1,000. Below that size, the whole index is likely to be loaded into RAM, and...
November 16, 2009 at 7:17 am
Ajay, do you understand directory structures and file paths?
If you look at what Gail posted, you appear to be trying to use a directory called "as.mdf" to hold a file...
November 16, 2009 at 7:09 am
There's nothing wrong with keeping people you trust away from data they don't need, and shouldn't have. Even if you have DBAs that you trust implicitly and that are...
November 13, 2009 at 2:19 pm
Rod at work (11/13/2009)
Charles Kincaid (11/13/2009)
Jeff Moden (11/12/2009)
November 13, 2009 at 1:18 pm
dean.rother (11/13/2009)
2. I copied both samples from http://www.asp.net. I assumed MS could code to their own standards and the c#...
November 13, 2009 at 1:14 pm
Viewing 15 posts - 7,741 through 7,755 (of 14,953 total)