Viewing 15 posts - 10,036 through 10,050 (of 49,571 total)
Benki Chendu (2/12/2014)
GilaMonster (2/12/2014)
Benki Chendu (2/12/2014)
February 12, 2014 at 11:22 am
jungnaja (2/12/2014)
When I use run select statement, it's about 1K logical reads, and 0 physical reads
So that's 1000 pages read to get the 10 rows. If it's starting with row...
February 12, 2014 at 11:21 am
Now, given that data you just posted, what do you want to happen? What must the end result look like?
February 12, 2014 at 9:23 am
Benki Chendu (2/12/2014)
February 12, 2014 at 9:21 am
Does the update use an index? How many does SQL have to read to identify those 10 rows?
February 12, 2014 at 9:20 am
Benki Chendu (2/12/2014)
Current PLE is set at 300 seconds/5 minutesTotal memory on the instance is 64 GB
300 is insanely low for that. 300 was a too low recommendation when...
February 12, 2014 at 9:14 am
Eugene Elutin (2/12/2014)
GilaMonster (2/12/2014)
Eugene Elutin (2/12/2014)
...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be...
February 12, 2014 at 9:10 am
chandan_jha18 (2/12/2014)
February 12, 2014 at 9:08 am
Eugene Elutin (2/12/2014)
...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through procedural...
February 12, 2014 at 9:05 am
Essential. Absolutely essential.
There's no procedural or application code that will stop someone from updating a table directly if they have permissions, or stop a newly written app from putting bad...
February 12, 2014 at 9:04 am
February 12, 2014 at 8:52 am
Why do you say using the SSMS window will cause lots of blocking?
February 12, 2014 at 8:46 am
EricEyster (2/12/2014)
February 12, 2014 at 8:22 am
Windows logins shouldn't be able to be orphaned, their SIDs come from the AD.
Those logins exist and have matching users on the log shipping primary?
February 12, 2014 at 8:16 am
Drop the logins. Recreate them with the same SID (security identifier) as they have on the log shipping primary.
February 12, 2014 at 8:10 am
Viewing 15 posts - 10,036 through 10,050 (of 49,571 total)