Viewing 15 posts - 41,521 through 41,535 (of 49,562 total)
serge.kovacs (1/22/2009)
while the DB itself is taking almost 2 GB now, and is still growing.
That's tiny. 🙂
Do you think it could help to increase the amount of RAM...
January 22, 2009 at 5:37 am
The best way to post the table definitions is as create statements, so that the people who are trying to help you can easily create those tables to test out...
January 22, 2009 at 4:08 am
Hadrian (1/22/2009)
check status in sysdatabases must be suspect for corrupted mdf files
Not necessarily. There are many forms of corruption that won't result in the DB been marked suspect. That's pretty...
January 22, 2009 at 4:01 am
vaibhavi5575 (1/22/2009)
My projects includes working on Java and Ruby on Rails and Ajax. I think Web Services is really cool.
You may get better advice on a forum that caters...
January 22, 2009 at 3:58 am
Run checkDB and see if it gives you any errors. There are a lot of possible errors that checkDB will give back, so I won't try and list them.
Is this...
January 22, 2009 at 3:57 am
I'm not sure I fully understand your requirements.
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 22, 2009 at 3:54 am
Rajesh kasturi (1/22/2009)
Thanks for your reply, While rebuilding the index log file will be used or data file will be used.
Both. The data file because that's where the new...
January 22, 2009 at 3:52 am
serge.kovacs (1/22/2009)
January 22, 2009 at 3:52 am
Suggest to the sharepoint admin that it would be better to take backups to the local disk and later move them to a network share?
If that's not an option, ensure...
January 22, 2009 at 12:37 am
ifila (1/21/2009)
Not looking for an argument, but why does MS offer a shrink capability if it is a bad idea ?
Because there are times when it's necessary. Note that...
January 22, 2009 at 12:36 am
It's used on Vista (and I think Server 2008) to add in an administrative user as, by default, the builtin\admins are no longer automatically sysadmin on those OSs. It's only...
January 22, 2009 at 12:25 am
lucassouzace (1/21/2009)
ok, is Latin1_General_CS_AS
Right. That's case sensitive (that's what the CS shows)
For some strange reason, the hierarchyid data type is case sensitive in some places in a case sensitive database....
January 22, 2009 at 12:10 am
Rajesh kasturi (1/21/2009)
If you run the backup log with truncate_only, I am sure your log file will be...
January 22, 2009 at 12:08 am
Unless you have a good reason not to, every table should have a clustered index.
Tests have shown that with a well-chosen clustering key, all operations are faster on the table...
January 21, 2009 at 1:18 pm
Grant Fritchey (1/21/2009)
I'm inclined to say the second without any data. But I've seen instances where the first can be faster.
If the indexes are good, the stats accurate and the...
January 21, 2009 at 1:15 pm
Viewing 15 posts - 41,521 through 41,535 (of 49,562 total)