Viewing 15 posts - 1,306 through 1,320 (of 49,571 total)
June 9, 2017 at 3:52 am
June 9, 2017 at 2:26 am
No, that CU is for instances that are running SP2, so service pack first, then CU
June 8, 2017 at 2:10 pm
User B starts the update immediately, but will probably be blocked until User A's session releases locks, which will be when the transaction commits.
June 8, 2017 at 1:57 pm
Yup, case-sensitive is the cause (and that's why I'm allergic to case-sensitive databases).
The name of the dmv is sys.dm_db_index_physical_stats, all lowercase. You'll have to fix the casing of...
June 8, 2017 at 1:56 pm
I never clear caches, and run queries twice before measuring to ensure caches are hot.
Reason: my application doesn't run with cold caches.
June 8, 2017 at 7:42 am
June 8, 2017 at 6:07 am
Ah, I just noticed what you're doing.
You're never updating that long column name, you update NbCum, then try to alter the long column name, and it still has the char(160)...
June 8, 2017 at 4:21 am
You're not running in a transaction, so no, you don't need a COMMIT (and you wouldn't even if this was in a transaction)
It's possible that the whitespace character...
June 8, 2017 at 3:59 am
Could be that the full backup file was damaged in some way. Do you take your backups WITH CHECKSUM? Can you try a fresh backup?
June 8, 2017 at 2:52 am
DBCC SQLPERF
and not SQLPREF (which is...June 8, 2017 at 1:36 am
WhiteLotus - Thursday, June 8, 2017 1:03 AMlower down the fill factor
Fragmentation is not typically a huge problem,...
June 8, 2017 at 1:15 am
June 7, 2017 at 4:42 pm
June 7, 2017 at 1:51 pm
Viewing 15 posts - 1,306 through 1,320 (of 49,571 total)