Viewing 15 posts - 166 through 180 (of 205 total)
Ah, I see.
It's not so much that you're teaching me something new as you give me new/different ways to look at it and I thank you for that.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 18, 2009 at 8:49 am
Gail,
Did you mean that at 50% your index would take twice the space on disk, rather than the table?
I use the general 90% fill factor on all tables because I...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 17, 2009 at 10:27 am
The plan is for busy DBs to get their indexes defragmented once a week, by a scheduled job. Just part of maintenance.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 17, 2009 at 6:38 am
I am a contractor here and do not have much knowledge being passed to me. I have to hunt most o fit down. I see no maintenance plans or third-party...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 17, 2009 at 5:57 am
Well, thanks for teaching me something.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 16, 2009 at 6:09 am
In my testing with BackupExec, several years ago, I found myself in the same boat as Lynn Pettis was saying. The tapes are too slow and tie up SQL Server...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 13, 2009 at 8:37 am
I understand, but it just seems like it would be so simple, with small indexes, to just rewrite the index in the correct order so that there would be no...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 13, 2009 at 5:23 am
Yeah, so I have been reading, since you mentioned pages in your last post. I vaguely remember reading smoething about that many moons ago but seldom run into an index...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 12, 2009 at 1:15 pm
5 pages in that index.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 12, 2009 at 12:03 pm
Turned out to be an oops on my part. It was a misspeling in the DB name and my eyes ain't what they used to be. The third time I...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 12, 2009 at 12:00 pm
Connection string. Dunno why I forgot that the first time.
data source=MGCAPSQL01\Develop;initial catalog=CBOCDiscrepancyReport;integrated security=false;persist security info=False;user id=cbodr;password=******;workstation id=MGBG1086;packet size=4096
I will work on getting a Profiler trace now.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 12, 2009 at 10:23 am
Sorry, apparently I confused some of the code. I am using DBREINDEX, not INDEXDEFRAG, and it wil not accept an objectID.
After more research though, I don't think I am going...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 4, 2009 at 10:46 am
It helps, but doesn't fox the problem. The problem is the Showcontig output, which gets pumped straight into the FragList table, then the data from that table is pulled out...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 3, 2009 at 12:01 pm
The individual objects, like when you need to duplicate a table real quick. Used to be simple to do with SQL 2000, you got the same window as if you...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 3, 2009 at 8:38 am
I ran into this myself last week. Practically the same symptom you have, except I didn't reboot anything. The problem cleared up on it's own. In my case it's a...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 27, 2009 at 5:52 am
Viewing 15 posts - 166 through 180 (of 205 total)