2018-07-09 (first published: 2018-07-04)
366 reads
2018-07-09 (first published: 2018-07-04)
366 reads
2017-12-05
941 reads
With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.
2017-11-13 (first published: 2017-10-27)
287 reads
2016-10-04 (first published: 2016-09-19)
405 reads
The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.
2016-02-16 (first published: 2016-02-02)
339 reads
2009-01-22
4,634 reads
By Rayis Imayev
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
I have two datasets, where I would like to join and then group by...
Hi I am looking to select the output of the data that I plan...