SQL Server 2019

External Article

SQL Server 2019 is Here

  • Article

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.

2018-10-30

4,429 reads

Technical Article

RS Internal Error !

  • Topic

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 […]

2005-05-29

6 reads

Technical Article

Nested JOIN''s behavior

  • Topic

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 […]

2005-05-27

1 reads

Technical Article

RE: help with date parameters

  • Reply

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

2005-05-25

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Multiply time by hourly rate

By pedroccamara

Hello all, I have this table with time for each row. It shows hh:mm....

Compare 2 tables and highlight where the column values has been updated

By Ravi

Hi All, I have a requirement to compare data from same table with different...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers