Viewing 15 posts - 826 through 840 (of 1,170 total)
SQLSteve (10/31/2013)
HI,So you would advise to turn Row Locking off?
I was going to enable page locking either way but wasn't sure whether to have both enabled or not.
No, Row...
October 31, 2013 at 6:30 am
Hi,
Since an index cannot be reorganized when ALLOW_PAGE_LOCKS is set to OFF you cannot perform ONLINE operations over that index such as REORGANIZE for e.g.
The default setting for ALLOW_ROW_LOCKS and...
October 31, 2013 at 5:29 am
Hi,
They arguments are FKs makes de DB to run slow, very slow.
This is not true. Moreover, if the FKs are supported with indexes then they simply bring performance to the...
October 29, 2013 at 5:07 am
Hi,
It depends.
If it’s not cached then it will be recompiled the first time it’s executed. Then it should not recompile, unless some operations that cause recompilation are used.
It can be...
October 29, 2013 at 4:38 am
pchirags (10/17/2013)
sqlnaive (10/17/2013)
With my earlier attempt it...
October 17, 2013 at 8:44 am
Mikael Eriksson SE (10/17/2013)
sp_recompile 'T' recompiles only the queries in the stored procedure that references the...
October 17, 2013 at 8:36 am
nilay.chaudhary (10/16/2013)
I think this is only related to older SQL versions
No, it's true for all versions of SQL from 2005+
You can do a check for the SP calls with this...
October 17, 2013 at 2:14 am
danielfountain (10/15/2013)
According to MS sys.partitions.rows "Indicates the approximate number of rows in this partition"
Hi,
Microsoft recommends to use the new dynamic views instead of some deprecated for future use
The same result...
October 15, 2013 at 2:47 am
Hi,
Why not use
select p.[rows] from sys.partitions p
where p.index_id in (0,1) and p.object_id = object_id('[schema].[TableName]')
to replace count(1)?
You already have the count for every table in sys.partitions view.
Regards,
IgorMi
October 15, 2013 at 1:11 am
GilaMonster (10/4/2013)
IgorMi (10/4/2013)
PLE min values should not go under 300 seconds.
That was a poor recommendation 8 odd years ago when servers had maybe 4GB of memory. These days it's...
October 4, 2013 at 5:39 am
Loundy (10/4/2013)
IgorMi (10/4/2013)
PLE min values should not go under 300 seconds. Fluctuating from 14h to 0.1h is still above 300 seconds, but the behavior itslef is not good for the...
October 4, 2013 at 3:59 am
Hi
PLE min values should not go under 300 seconds. Fluctuating from 14h to 0.1h is still above 300 seconds, but the behavior itslef is not good for the database work.
It...
October 4, 2013 at 3:23 am
Nice article!
I immediately applied the code (with minor changes) on another database, and it worked!
Thanks Jeff.
Regards,
IgorMi
October 4, 2013 at 2:52 am
jason123 (10/3/2013)
Hi everyone,My transaction log file is bigger and bigger every day, can I truncate the file? If it can, does it affect any thing such as performance?
Best regards;
Hi,
You should...
October 3, 2013 at 8:03 am
Viewing 15 posts - 826 through 840 (of 1,170 total)