Viewing 15 posts - 43,081 through 43,095 (of 49,552 total)
On 2005, not easily. You can create an indexed view and put a unique clustered index on that, or you can define a calculated column and put the constraint on...
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
November 17, 2008 at 12:12 am
Maybe.
The database backup backed up data as it finds it on disk. Once it's done that, it backs up enough of the transaction log to ensure that the database can...
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
November 17, 2008 at 12:09 am
What wait type are you seeing on the queries when they run long?
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
November 17, 2008 at 12:05 am
anam (11/16/2008)
Hi GailI tried with query you gave me but it didn't work. the error message i get is
The message is pretty self explanatory. SQL can't take a log backup...
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
November 16, 2008 at 11:56 pm
binu.ma (11/16/2008)
Kinldy help me.
Already have.
If you completely disable mirroring, you will have to restart it from scratch, with a restore of a full backup.
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
November 16, 2008 at 11:51 pm
If you completely disable mirroring, you will have to restart it from scratch, with a restore of a full backup.
Why did you need to check the mirrored DB? It...
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
November 16, 2008 at 11:08 pm
Why do you want to manage locking in the app?
SQL takes locks automatically in the required mode and with the best possible granularity for each statement, nad it will release...
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
November 16, 2008 at 10:57 pm
I'm not sure I understand you. Have you stopped mirroring or are you planning to. First post said you had, second said you needed to do it. If you have...
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
November 16, 2008 at 10:50 pm
Did you pause the mirroring session, or did you completely disable mirroring?
If you look at the servers in management studio's object explorer, do the database still mirrored and principal/mirror?
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
November 16, 2008 at 10:33 pm
Someone tried to log into the SQL server and requested the database ASPState to be the default database. The ogin failed because the DB is inaccessible, or it doesn't exist
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
November 16, 2008 at 10:30 pm
Reindex again with a higher fill factor. Do you have a reason for wanting the data pages to be only 40% full after the reindex?
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
November 16, 2008 at 10:26 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic603443-357-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
November 16, 2008 at 10:25 pm
You can switch a database into norecovery using the backup log statement. It's not possible to switch it into standby the same way.
backup log SomeDB to disk = 'd:\someDB.trn'...
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
November 16, 2008 at 10:19 pm
Wayne West (11/13/2008)
Woohoo! Very much looking forward to the party and meeting lots of regulars here! :hehe:
Likewise.
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
November 16, 2008 at 9:08 pm
Jim in Arizona (11/13/2008)
What actually takes place at one of these 'parties'?
Couple of hours of meeting people that you usually interact with online only, gambling monopoly money and generally having...
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
November 16, 2008 at 9:01 pm
Viewing 15 posts - 43,081 through 43,095 (of 49,552 total)