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...
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)....
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...
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...
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?
December 9, 2012 at 10:58 am
First question. Why are you partitioning? What's the purpose, what's the goal?
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...
December 9, 2012 at 8:48 am
Please note: 2 year old thread (reactivated by some spam)
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...
December 8, 2012 at 11:47 am
komal145 (12/7/2012)
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...
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...
December 7, 2012 at 9:07 am
fluffydeadangel (12/7/2012)
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...
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...
December 7, 2012 at 8:54 am
Viewing 15 posts - 15,316 through 15,330 (of 49,552 total)