On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first public preview of SQL Server 2019 (community technical preview (CTP) release of SQL Server 2.0).This new release of SQL Server is packed with many new features to improve performance, integrate your increasing volumes of corporate data, beef up security, and more.
In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.
Thanks for improving the string or binary data truncated error message.
I use Reporting Services to provide my users with parameterised reports specific to their department. I have set up a simple system whereby all users have access to all reports (no custom roles). Windows authentication is used for report access and I have a windows group with appropriate rights assigned to browser role.Now here's the […]
Hey all, got a query here that was reverse ported out of an Oracle app before I arrived out on customer site and the structure leads me to believe it's behaving more like a nested subquery arrangment than straight-forward joins. Here's an idea of how it is structured:select <RETURN LIST> from Table1 t1 inner join Table2 […]
Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.For more info on how to work with sql server dates you might want to look at these articles: http://www.sql-server-performance.com/fk_datetime.asp http://www.karaszi.com/SQLServer/info_datetime.asp