Viewing 15 posts - 25,366 through 25,380 (of 49,552 total)
No reverse IN, but there's no need to get complex here.
WHERE ColA = 'x' OR ColB = 'x' OR ColC = 'x' ...
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
June 23, 2011 at 11:11 am
There's a massive difference between the two.
The first there's a function applied to the column. That makes the predicate non-SARGable, meaning SQL can NEVER use an index seek operation to...
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
June 23, 2011 at 11:10 am
Lowell (6/23/2011)
gotcha, so in a disaster recovery scenario like that, where the mdf was damaged/lost, you would not be able to do a tail backup...
That's exactly the scenario where you...
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
June 23, 2011 at 11:09 am
Don't restore one by one, that's just plain silly.
MSDB stores the backup history, generate the restore scripts from MSDB, far easier than trying to figure out what order they should...
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
June 23, 2011 at 11:03 am
Asked and answered: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=162075
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
June 23, 2011 at 12:51 am
Nemachtiani (6/22/2011)
Hi allDoes anyone know what would cause data loss on tables after commit with no errors raised neither executed DELETEs?
Is this a symptom of database corruption?
No.
I 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
June 23, 2011 at 12:50 am
The log backup you have is too early, all its transactions are already in the restored DB. Try the next one in the chain.
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
June 23, 2011 at 12:46 am
2005 RTM. (I should have taken the bet)
Patch it to the same level as your servers, then you'll see (likely) a key lookup, not a clustered index seek (which is...
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
June 23, 2011 at 12:44 am
Help->About (as with most Windows apps)
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
June 22, 2011 at 2:34 pm
I'm almost willing to take a bet that if you check the version of SSMS (not the server) it'll be 2005 RTM. So many people forget they have to patch...
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
June 22, 2011 at 1:51 pm
Defined amount always, never a % for any database file.
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
June 22, 2011 at 12:49 pm
TalkToLee (6/22/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
June 22, 2011 at 12:21 pm
If I had to guess, your version of management studio is pre SP2 and what you think is a clustered index scan is a key lookup. Key lookups are always...
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
June 22, 2011 at 12:11 pm
TalkToLee (6/22/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
June 22, 2011 at 11:53 am
The log file is circular. So if the minLSN was in VLF 4 and the current point of writing (the maxLSN) was in 8, then VLFs 9, 0, 1, 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
June 22, 2011 at 11:51 am
Viewing 15 posts - 25,366 through 25,380 (of 49,552 total)