Viewing 15 posts - 241 through 255 (of 984 total)
Post your real code because trailing spaces aren't normally considered during character based...
September 6, 2017 at 7:35 am
September 6, 2017 at 7:21 am
September 5, 2017 at 5:42 am
September 1, 2017 at 2:02 am
DBCC PAGE might give some more information... You'll need to pass in the database ID, the fileID & page ID, and a formatting option (0-3):
DBCC PAGE...
August 31, 2017 at 3:47 am
You could try something like this:
WITH OrderedRanked
AS (SELECT ROW_NUMBER() OVER (ORDER BY value DESC) Sequence_no,
userid,
value,
DENSE_RANK() OVER...
August 31, 2017 at 3:35 am
Hi All
August 31, 2017 at 3:20 am
August 30, 2017 at 9:28 am
Resurrecting this as I've just had the exact same "concern"...
Looks like this "Lazy Log Truncation" is the problem with VLFs not being cleared down on the...
August 10, 2017 at 5:13 am
August 9, 2017 at 2:21 am
August 4, 2017 at 9:34 am
https://support.microsoft.com/en-gb/help/231347/description-of-support-for-sql-server-databases-on-compressed-volumes seems to cover it.
August 2, 2017 at 4:07 am
Viewing 15 posts - 241 through 255 (of 984 total)