Viewing 15 posts - 25,861 through 25,875 (of 49,552 total)
Nope. Standby is only an option if both servers are the same version. For logshipping up-version (which is not a supported scenario) only NORECOVERY can be used.
Why is replication not...
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
May 30, 2011 at 6:04 am
Syed Jahanzaib Bin hassan (5/30/2011)
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
May 30, 2011 at 6:04 am
Syed Jahanzaib Bin hassan (5/30/2011)
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
May 30, 2011 at 5:52 am
Syed Jahanzaib Bin hassan (5/30/2011)
how many drives not partition you have and how many cores of CPU you have in a machine
What's that got to do with the number of...
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
May 30, 2011 at 5:38 am
Restoring from backup is the recommended way to resolve a suspect database. If the backup strategy was correct, the DB can be recovered right up to the point of failure.
It's...
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
May 30, 2011 at 5:07 am
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
May 30, 2011 at 3:47 am
Not clear.
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
May 30, 2011 at 2:41 am
Syed Jahanzaib Bin hassan (5/30/2011)
On every Full Backup , previous Differential and Log backups will be...
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
May 30, 2011 at 2:24 am
In SQL you should almost never iterate row-by-row. Nothing you've said so far indicates there's any need to do operations on individual rows.
What exactly are you trying to do?
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
May 30, 2011 at 2:10 am
This series may be worth reading: http://www.sqlservercentral.com/articles/Indexing/68439/
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
May 29, 2011 at 11:57 pm
Barkingdog (5/29/2011)
(Of course, if the DB itself has been found corrupt I hope the trans...
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
May 29, 2011 at 11:55 pm
When you have an identity, it must not be specified as part of the insert statement, as SQL handles the value. Change your insert statement to
INSERT INTO Course (Name, Abbrev,...
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
May 29, 2011 at 11:42 pm
Not sure what you're looking for...
The mdf (and ndfs if present) store all the data that's within the DB. That's all tables, all indexes, etc
The ldf stored the records of...
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
May 29, 2011 at 4:23 am
SQL was restarted and a large transaction had to either roll back or roll forward.
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
May 29, 2011 at 3:43 am
Table definition (the create table statement) and the insert statement please
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
May 29, 2011 at 3:42 am
Viewing 15 posts - 25,861 through 25,875 (of 49,552 total)