Viewing 15 posts - 37,036 through 37,050 (of 49,552 total)
I called this evening to ask if there were any known problems, because I've been having intermittent problems since yesterday morning. Help desk replied that there were no issues and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 12:35 pm
Gotta love an ISP that depends on their customers to tell them that a portion of their network infrastructure has been offline for 2 days.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 12:13 pm
Sharepoint provides a whole bunch of web services for retrieving data from the sharepoint DBs. You're not supposed to be querying it directly. Maybe ask that in one of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 12:09 pm
See - http://www.sqlservercentral.com/Forums/Topic770808-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 12:05 pm
Might be worth asking on a Sharepoint forum, like this one - http://social.msdn.microsoft.com/Forums/en-US/sharepointadmin/threads
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 12:03 pm
Might have been added in SQL 2008. You can use the script instead.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 12:01 pm
team (8/14/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 9:27 am
Drop database is a bit extreme. Personally I'd try an index defrag on the cluster with LOB Compact first. If that doesn't work, then rebuild the clustered index
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 9:19 am
and, if you move the creation of the indexes to after the population, do you still get this error? If not, that's possibly a good workaround. It also means you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 9:18 am
kwilt (8/14/2009)
I was under the impression that the only way to shink a log file is to have two consecutive log file backups and then the shrinkfile will work.
No,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 8:12 am
alex (8/14/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 8:06 am
No. The GUI runs the same script you'll run. Could be there's an open transaction of something preventing the shrink. Maybe wait a few hours and try again. It often...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 7:43 am
kwilt (8/14/2009)
I have a transaction log that I am unable to shrink, as the recovery model is Simple on the database.
Having the DB in simple doesn't stop you from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 7:28 am
Jan Van der Eecken (8/14/2009)
GilaMonster (8/14/2009)
Is that legal? I thought licence plates were tied to the cars, not to drivers....
Not in the case of personalised plates, after all you could...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 7:17 am
Best to let SQL manage the locks itself. No matter what you specify, an update (any data change) must take an exclusive lock while the data is been changed. This...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2009 at 6:04 am
Viewing 15 posts - 37,036 through 37,050 (of 49,552 total)