2020-10-12
1,902 reads
Random Data
How to Get a Random Row from a Large Table
Brent Ozar takes a look at four different ways to get a random row from a large SQL Server table.
2018-03-22
5,124 reads
Blogs
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using dbachecks for CIS Security Checks
Well back at the end of 2019 I finished writing most of the checks...
How to tell if Change Data Capture (CDC) is working as expected
By DesertDBA
I’m not sure how many of you use Change Data Capture (CDC) on your...
Forums
Can secondary data file (.ndf) be created by default during sql installation?
Primary data file, sitting on its own drive, has two files: .mdf and .ndf....
Extended Events stop writing to Ring Buffer in 10 minutes.
It hardly goes over 1000 collected rows, and just stops further logging without any...
left join causing results to be multiplied
Hello, Hello, the query below is giving me some trouble. the results of the...
Ask SSC