Viewing 15 posts - 38,566 through 38,580 (of 49,571 total)
I don't think it matters much. Unless you're very careful pseudonym's not going to hide who you are. Just need one place that links pseudonym with real name. If you...
June 9, 2009 at 11:26 am
Krasavita (6/9/2009)
Thank you,but how can I find out if it is already installed
If what's installed? Books Online?
Start - Programs - Microsoft SQL Server - Documentation and Tutorials - Books Online
If...
June 9, 2009 at 11:24 am
How much data can you afford to lose in the case of a disaster? That's the main question that identifies the frequency for log backups.
June 9, 2009 at 11:12 am
Gee Barry
RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of the length of...
June 9, 2009 at 11:11 am
Personally, if it were me, I'd create indexes to support the two or three most run queries, and then later re-evaluate to see if more were needed.
My standard technique:
June 9, 2009 at 11:08 am
jcrawf02 (6/9/2009)
GilaMonster (6/9/2009)
Chances are here that I wouldn't find anything.And yet you'd find you. Maybe you should reconsider that?
Last interview I did was just over a year ago. Don't...
June 9, 2009 at 10:35 am
Drop the angle brackets. I meant replace <Format code> with the format code. Angle brackets designates a placeholder. something to be replaced with an actual value.
June 9, 2009 at 10:33 am
I'm getting them anything from 1 hour to 2 days late. Got a notification this morning for a post made on Sunday.
June 9, 2009 at 9:51 am
Steve Jones - Editor (6/9/2009)
June 9, 2009 at 9:46 am
GSquared (6/9/2009)
Besides, it's necessary, since the indexes point to actual disk locations, and having them point to incorrect sectors isn't a good thing.
?????
As far as I'm aware, nothing within a...
June 9, 2009 at 9:40 am
Just one additional point. Not all SQL usergroups are PASS chapters (mine isn't yet). So if there isn't a PASS chapter in the area, ask around and see if there's...
June 9, 2009 at 9:36 am
fbonneville (6/9/2009)
But if you rebuild your indexes after shrinking the data files, won't this force the data files to grow again during the rebuild essentially negating all of your work?
It...
June 9, 2009 at 9:33 am
GSquared (6/9/2009)
Indexes need to be rebuilt after physical defragmentation, per Microsoft.
Ref please?
I can't see why. Index fragmentation is about the order of pages in the data file, shouldn't be affected...
June 9, 2009 at 9:30 am
dallas13 (6/9/2009)
sql will create 100 different...
June 9, 2009 at 9:18 am
Viewing 15 posts - 38,566 through 38,580 (of 49,571 total)