2019-04-27
158 reads
2019-04-27
158 reads
This week, Brent is demoing SQL Server 2019 features that he's really excited about, and they all center around a theme we all know and love: parameter sniffing.
2019-04-26
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
679 reads
Two new tools will be making an appearance in SQL Server 2019, a dynamic management function (DMF) and the other a function, will be making an appearance, namely sys.dm_db_page_info and sys.fn_pagerescracker respectively.
2019-04-05
SQL Server 2019 will bring more than graph query languages. We will be able to use a document query engine and a specific JSON engine.
2019-04-01
3,197 reads
Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!
2018-12-25
2,797 reads
2024-04-12 (first published: 2018-12-20)
9,975 reads
Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this article, Greg Larson tests the new APPROX_COUNT_DISTINCT function for performance and accuracy.
2018-12-13
4,741 reads
Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!
2018-12-11
2,386 reads
Greg Larsen offers detailed instructions on how to install SQL Server 2019 CTP 2.0.
2018-11-20
2,371 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
This is one I haven't seen before. I'm trying to drop a database user...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers