Viewing 15 posts - 15,316 through 15,330 (of 49,552 total)
There's no system triggers on the configurations view, and I doubt you can write triggers on a system view, even if you can, you should not.
What are you trying 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
December 10, 2012 at 1:30 am
Jeff Moden (12/9/2012)
GilaMonster (12/9/2012)
No.Page reads != fragmentation.
Do you consider page splits to be a form of fragmentation?
Page splits may cause logical fragmentation (or may not, depending which pages split)....
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
December 10, 2012 at 1:24 am
nitin.varshney (12/9/2012)
@Gila: How can we know the wait type and locking objects ? there is no any blockage in sp_who2 active command.
Query sys.dm_exec_requests. There are several columns relating to 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
December 9, 2012 at 12:21 pm
nitin.varshney (12/9/2012)
is the sp execution plan will be changed for the grouping of small and large data set in the sp ?
Not unless something invalidates or removes the one plan...
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
December 9, 2012 at 12:21 pm
Not enough information.
Could be locks or waits for other resources
Could be bad exec plans
Could be several other things.
When it runs slow, what's the wait type?
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
December 9, 2012 at 10:58 am
First question. Why are you partitioning? What's the purpose, what's the goal?
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
December 9, 2012 at 8:50 am
No.
Page reads != fragmentation. Page reads means swap file usage.
As for the memory, your memory settings look a little high if there's something outside of SQL that is using 5...
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
December 9, 2012 at 8:48 am
Please note: 2 year old thread (reactivated by some spam)
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
December 9, 2012 at 1:48 am
briancampbellmcad (12/8/2012)
Is this a sign of a corrupted database?
No.
This happened just after I manually deleted all records from a table and a few of them gave errors of something...
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
December 8, 2012 at 11:47 am
komal145 (12/7/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
December 7, 2012 at 9:38 am
mani@123 (12/7/2012)
Do we have any separate views to track those changes.How does sql engine know like its time to update stats?
No views that you can access. It's buried in 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
December 7, 2012 at 9:19 am
If that secondary file is in a separate filegroup and you have enterprise edition, then you can do a partial restore and just restore the primary filegroup. If that secondary...
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
December 7, 2012 at 9:07 am
fluffydeadangel (12/7/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
December 7, 2012 at 9:04 am
mani@123 (12/7/2012)
SO on what basis sql engine is automatically updating system created stats by turning ON auto update stats.
20% of the values for that column have changed since the last...
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
December 7, 2012 at 9:01 am
mani@123 (12/7/2012)
It is automatically updated but I wanted it to be done by on my by determing some percentage conditions over the modified count value.
Why?
Have you tested and determined 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
December 7, 2012 at 8:54 am
Viewing 15 posts - 15,316 through 15,330 (of 49,552 total)