Viewing 15 posts - 241 through 255 (of 984 total)
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 7, 2017 at 4:48 am
Post your real code because trailing spaces aren't normally considered during character based...
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 6, 2017 at 7:35 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 6, 2017 at 7:21 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 5, 2017 at 5:42 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 31, 2017 at 3:35 am
Hi All
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 31, 2017 at 3:20 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
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...
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 10, 2017 at 5:13 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 9, 2017 at 4:11 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 9, 2017 at 2:21 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 4, 2017 at 9:34 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 2, 2017 at 4:36 am
https://support.microsoft.com/en-gb/help/231347/description-of-support-for-sql-server-databases-on-compressed-volumes seems to cover it.
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 2, 2017 at 4:07 am
Viewing 15 posts - 241 through 255 (of 984 total)