Viewing 15 posts - 23,701 through 23,715 (of 49,552 total)
h.tobisch (9/6/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
September 6, 2011 at 3:25 am
hl6a (9/5/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
September 5, 2011 at 11:49 am
hl6a (9/5/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
September 5, 2011 at 10:26 am
Adiga (9/5/2011)
Your restore script does not have "WITH RECOVERY" option in it. Hence the database is in Recovering state.
Errr, RECOVERY is the default if nothing is specified. To get...
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
September 5, 2011 at 10:23 am
Is it not better to learn the latest version unless there is a huge difference between both and this has an effect on training for the exam?
With the exception 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
September 5, 2011 at 9:41 am
ananda.murugesan (9/5/2011)
what is perfected values for elapsed time and IO? I think both should be 0.0 seconds.
For a query that does absolutely nothing, queries no tables, returns no data that'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
September 5, 2011 at 9:31 am
The exams are based on SQL 2008, not SQL 2008 R2.
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
September 5, 2011 at 9:29 am
ahmed_b72 (9/5/2011)
One related question: is there a way to force the optimizer to use an index in a select statment?
Yes, there's a WITH (INDEX = <index name>) hint. However, unless...
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
September 5, 2011 at 2:26 am
paul.knibbs (9/5/2011)
GilaMonster (9/4/2011)
I'd love to commute some other way, but in a city with no good, reliable, safe public transport that's a dream. It's walk, bike or drive, or don't...
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
September 5, 2011 at 12:50 am
Depends on the selectivity of the predicate - what percentage of the rows the query returns.
http://www.sqlservercentral.com/articles/Indexing/68636/
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
p.s. To attach, see the box right under the Post Reply text field. There's an...
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
September 5, 2011 at 12:38 am
In very simple terms, the old version of the row goes into the version store until it's no longer needed by any active statements/transactions (depending which of the optimistic concurrency...
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
September 5, 2011 at 12:31 am
Tom.Thomson (9/4/2011)
As for raisins in bobotie, wouldn't a green apple be better? Or maybe okra?
Yuk, No way. Raisins, ground or chopped almonds (I prefer ground), chutney and enough curry...
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
September 4, 2011 at 4:35 pm
The first error is just telling you that you're about to restore a different database over one you have. Use RESTORE ... WITH REPLACE to remove that warning. However, if...
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
September 4, 2011 at 2:28 pm
kp_kumar (9/4/2011)
You can reduce the backup time by specifying multiple files instead of single file.
Only if those files are on separate drives (not separate partitions of one drive)
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
September 4, 2011 at 2:26 pm
Great, now fix your backup strategy and make sure you're running regular integrity checks.
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
September 4, 2011 at 1:02 pm
Viewing 15 posts - 23,701 through 23,715 (of 49,552 total)