Viewing 15 posts - 1,651 through 1,665 (of 3,233 total)
Yes, I'll agree 100%. Not performing periodic restores of your backups is not being diligent. If you don't test the restores, you can't rely on the quality of...
July 9, 2008 at 3:07 pm
This sounds like a possible case of parameter sniffing. Can you post your SP?
July 9, 2008 at 2:58 pm
This sounds suspiciously like homework to me. Whatever the reason for this strange requirement, a number of the solutions listed already will work.
July 9, 2008 at 2:56 pm
Yes, that dynamice management view is specifically created to watch fragmentation. the avg_fragmentation_in_percent represents the percentage of logical or extent fragmentation within your index/table. The closer this value...
July 9, 2008 at 2:53 pm
We have to delete these three keys but I'm stuck. I checked the rights, changed the name and changed the value but no succes.. The original dba is no longer...
July 9, 2008 at 2:41 pm
The UPDATE part looks good. You are attempting to modify the b table value so I'd go with B.Consultant in the UPDATE clause. Are you sure that your...
July 9, 2008 at 2:06 pm
Ah, Michael, you must have posted whilst I was typing....I'll second everything that you've said as well!
July 9, 2008 at 2:02 pm
Fill factor is not a representation of index fragmentation. The fill factor setting tells SQL Server how full to fill the index pages when creating a new index. ...
July 9, 2008 at 2:00 pm
I agree. For those of us who have been following this thread from early on, these hastily posted solutions that aren't even for the correct SQL Server version or...
July 9, 2008 at 9:04 am
Would you mind formatting and posting your solution so that others who come across this thread have the benefit of seeing the solution?
July 8, 2008 at 8:44 am
Yep, not problem. I would like to re-iterate that I would use this method sparingly as SQL Server has other built-in ways to import data from a xls file....
July 7, 2008 at 12:55 pm
OK, we're getting closer but I still can't make anything out of your example because the formatting (and language barrier) makes it difficult to know which columns/values go with each...
July 3, 2008 at 1:54 pm
SQL Server will upgrade it to 2005 for you. You'll need to either restore or attach the DB to a 2005 instance or upgrade your 2000 instance to 2005...
July 3, 2008 at 11:00 am
What kind of jobs are you talking about?
How much space does your server have?
How much available space do you have to work with?
How large is your DB, log?
July 3, 2008 at 10:58 am
Viewing 15 posts - 1,651 through 1,665 (of 3,233 total)