Viewing 15 posts - 19,051 through 19,065 (of 49,552 total)
Largest number of rows I've heard of in a single unpartitioned table - 100 billion rows.
Largest number I've personally worked with - 150 million rows
Make sure there's enough hardware (memory...
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
April 16, 2012 at 12:11 pm
So to summarise...
Corruption appearing repeatedly in the same table across different databases on different servers?
Corruption 'disappearing' between a maintenance plan running checkDB and a manual run of checkDB with no...
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
April 16, 2012 at 12:06 pm
It's certainly possible. Extremely rare, but possible. I think I'm going to look for an expert to help out here...
Are you absolutely, 100% certain that there was no index rebuild...
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
April 16, 2012 at 11:55 am
See http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
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
April 16, 2012 at 11:52 am
Lynn Pettis (4/16/2012)
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
April 16, 2012 at 11:13 am
donato1026 (4/16/2012)
But then again, I am missing a comma... Although, the SQL parser didn't catch that. Hmm...
No, because this is completely valid (run it and you'll see what happens)
SELECT 1
'a',
2
'b'
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
April 16, 2012 at 11:03 am
This is one area where I and many others disagree with Book Online. Set the max server memory always. See chapter 4 of the book I linked 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
April 16, 2012 at 10:59 am
That's what the 'default' parameter says. Read all rollover files. So the very first trace file (created the first time SQL started up) would have been just called log.trc. 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
April 16, 2012 at 10:08 am
hbtkp (4/16/2012)
i just want to know ,how you select max (date)max is not working as date is datetime
MAX works just fine on a datetime data type.
SELECT MAX(<Datetime column>)...
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
April 16, 2012 at 10:03 am
xgcmcbain (4/16/2012)
Thank you for you feedback! I did not know they slowed down updates and inserts. Hope they dont bring that up.
If you are suggesting indexed views, 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
April 16, 2012 at 8:58 am
Also bear in mind that indexed views are actually materialised and stored. So if you create indexed views across an entire DB, you are doubling the size of the DB...
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
April 16, 2012 at 8:56 am
hbtkp (4/16/2012)
one thing can solve my prob.how to calculate cumulative of any field.
if you know let me know
The SUM function perhaps? Just guessing here, it's not clear (again) what you're...
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
April 16, 2012 at 8:52 am
You can't use a variable for the file name. Use dynamic SQL instead (or just write the code by hand)
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
April 16, 2012 at 8:20 am
GilaMonster (4/16/2012)
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
April 16, 2012 at 7:53 am
My bet: max server memory is at default levels so essentially you've told SQL it can use all the memory on the server if it wants to. SQL by design...
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
April 16, 2012 at 7:34 am
Viewing 15 posts - 19,051 through 19,065 (of 49,552 total)