Viewing 15 posts - 22,546 through 22,560 (of 49,552 total)
raotor (11/3/2011)
Great. Do you have any idea what sort of across-the-board performance increase I might expect by going 64-bit?
Little to none. 64-bit isn't about raw performance, it's about...
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 3, 2011 at 6:51 am
Artoo22 (11/3/2011)
Is it really more efficient to scan 4,367,682 rows and perform a merge join than it is to perform 40,371 seeks
Probably yes.
40371 seeks requires at least 80742 page reads...
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 3, 2011 at 6:48 am
dva2007 (11/3/2011)
again the confusion is if clustered index puts the data in the physical order?
No. It enforces the logical sort order. SQL will try and create the index so that...
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 3, 2011 at 6:45 am
No. Restore the entire database from 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 3, 2011 at 6:44 am
It depends. Really, this is not a question that has a hard and fast answer. Depends on data types, access patterns and a whole lot more.
A table should always 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 3, 2011 at 3:54 am
Call Microsoft customer support. They're the ones that have the tools to debug crash dumps. The Exception Access Violation has nothing whatsoever to do with disk or network, it'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
November 3, 2011 at 3:52 am
You've got poorly performing queries.
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 3, 2011 at 3:16 am
aggarwal.nitesh 52650 (11/2/2011)
I required SQL Server 2008 dumps of following 70-432, 70-450. Kindly mail me on <removed> asap
Braindumps are cheating. They are actual questions taken from the exams in violation...
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 3, 2011 at 3:10 am
It's possible, but you have to declare and assign the variable in the dynamic SQL.
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 3, 2011 at 3:09 am
captcooldaddy (11/2/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
November 2, 2011 at 3:46 pm
As for monitoring...
http://sqlinthewild.co.za/index.php/2010/07/27/hit-and-miss/
http://sqlinthewild.co.za/index.php/2010/08/31/come-and-gone/
http://sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/
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 2, 2011 at 12:44 pm
The procedure will use the cached plan. The dynamic SQL, because it runs as a separate batch and in a different scope has its own execution plan.
In this case, the...
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 2, 2011 at 12:43 pm
jjmanthei05 (11/2/2011)
Gail,I'm not sure if I'm missing something but I don't see a difference of what you posted as compared to what I did.
Your from clause:
from AdditionalInfo inner join...
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 2, 2011 at 12:23 pm
btw, depending on what storage you have, that may not even be enough...
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 2, 2011 at 12:06 pm
Export the data from every table
Script all the objects
Detach the database
Use a secure delete program to delete the data and log files, overwriting them so that the sectors on the...
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 2, 2011 at 11:53 am
Viewing 15 posts - 22,546 through 22,560 (of 49,552 total)