SQL Server Unit Testing in Visual Studio
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
2020-01-03 (first published: 2017-05-01)
18,077 reads
David Fundakowski
Compress and Decompress in SQL Server 2016
Explore using Compress/Decompress with varying types of data and examine size/storage usage
2018-10-01
3,216 reads
Changing Linked Server Properties
A quick guide on changing the linked server properties and settings.
2018-09-03 (first published: 2016-07-07)
28,875 reads
Additional Data Files and Proportional Fill
Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.
2017-11-03 (first published: 2016-07-25)
3,874 reads
Reclaiming Space After Column Data Type Change
A brief overview of how to reclaim storage space after altering the data type of a column.
2016-08-09
4,709 reads
Diagnosing parallelism-related latching
Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.
2016-05-26
2,560 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
Selecting from a view, base table has a DENY on a column
This is something I've never seen before and I can't think of the right...
JSON data with Pivoted
Hi All, I need some assistance and not sure how to achieve the expected...
SQL Window Functions Series: LAG() and LEAD()
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Ask SSC