Viewing 15 posts - 27,736 through 27,750 (of 49,552 total)
Same reason. R2 is a different version, it has a different internal database version and hence cannot be downgraded. It is not a service pack.
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
February 16, 2011 at 3:05 am
The join in where clause is an older style and is not much in favour any longer.
Regardless of which way you do it, you need to list the location table...
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
February 16, 2011 at 1:12 am
Suvendu (2/15/2011)
A clustered index is a special type of index that reorders the way records in the table are physically stored.
The clustered index enforces the logical storage order 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
February 16, 2011 at 1:11 am
LutzM (2/15/2011)
GilaMonster (2/15/2011)
In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is not.
Wouldn't index 1 be used if a query...
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
February 15, 2011 at 10:30 pm
In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is 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
February 15, 2011 at 3:37 pm
The size cap on express is per database, not per filegroup, so if that's what you're running into, another filegroup won't help at all.
If that is what you're running into,...
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
February 15, 2011 at 3:36 pm
Meet George Jetson (2/15/2011)
Since you have the transaction log backups scheduled to run on the hour, the forty minutes after the last log file is lost.
Not necessarily. Depending on what'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
February 15, 2011 at 3:29 pm
Restore will recreate the database exactly as it was at the time of the backup. Free space and database file size included.
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
February 15, 2011 at 1:48 pm
GilaMonster (2/15/2011)
Before deciding on a method of recovery, we need the database state (state_desc from sys.databases) and all errors relating to the DB from the SQL error log.
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
February 15, 2011 at 1:46 pm
Brandie Tarvin (2/15/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
February 15, 2011 at 1:19 pm
Why do you want it to go away? Have you identified the hash join as a major bottleneck?
Table definitions, index definitions and execution plan 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
February 15, 2011 at 11:24 am
Ken McKelvey (2/15/2011)
I cannot remember if SQL2000 gave a specific exception if you tried to restore a backup produced by a more recent version of SQL server.
It was a very...
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
February 15, 2011 at 11:21 am
The backup is toast, get hold of a new one.
There's nothing surprising about verify only succeeding and restore failing. Verify only does not guarantee that the backup is restorable, 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
February 15, 2011 at 11:19 am
Jeff Moden (2/15/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
February 15, 2011 at 11:15 am
In the restore syntax, you can specify the file number. To restore the first, FILE = 1, to restore the second, FILE = 2
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
February 15, 2011 at 7:24 am
Viewing 15 posts - 27,736 through 27,750 (of 49,552 total)