SQL Server

Microsoft SQL Server 2017 powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server 2017 brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.

More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Stack Overflow or MSDN.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  2. OPENJSON WITH is missing ability to get [key] index value

    OPENXML allows selection of id of document node.
    This affords using it as internal key when parsing xml, which allows linking of nested nodes by using "parentid". See OPENXML for more

    for example, see id generated from @mp:id. it can be used to create sequence id as well with ROW_NUMBER, in other words very useful for many purposes

    BEGIN TRY

    DECLARE @docHandle int
    DECLARE @xml xml = N'<root>
    <r>a</r>
    <r>a</r>
    <r>b</r>
    <r>b</r>
    <r>c</r>
    <r>d</r>
    <r>e</r>
    </root>'

    EXECUTE sp_xml_preparedocument @hdoc = @docHandle OUTPUT, @xmltext = @xml

    SELECT *
    ,ROW_NUMBER()OVER(ORDER BY id DESC) Ix
    FROM OPENXML(@docHandle, N'root/r', 8)
    WITH (
    s nvarchar(50)…

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Bring Filter on Database Node Back

    I downloaded the latest version of Microsoft SQL Server Management Studio (18.4) and the filter option is no longer available on the databases node. It is still there on the tables node of the databases, but I don't use this one. I use the database filter EVERY SINGLE DAY. I downgraded and went back to Management Studio 17 so that I can still efficiently work.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Geography Reduce Aggregate

    We have the Reduce functionality on a LineString which reducing the point in a linestring.
    it would helpfull to have this functionality returning the results as rows.
    And also we should have a Aggregare Agg_PointsToLineString(Point) to create a LineString out of multiple Points.

    Now we need todo something like this:
    declare @g geography

    set @g = Geography::STLineFromText('LINESTRING ('+
    (select
    stuff((select ','+replace(replace(Punt.ToString() ,'POINT (',''),')','')
    from dbo.tmpAISPos
    order by idke
    FOR XML path('')),1,1,''))+')',4326)

    --select @g

    DECLARE @g2 geography = @g.Reduce(300)

    declare @g2string varchar(max)= replace( replace(@g2.ToString(),'LINESTRING (',''),')','')

    select *
    FROm
    (select geography::STPointFromText('POINT('+[value]+')', 4326) Point
    from string_split(@g2string,',')
    )spl
    inner join dbo.tmpAISPos t on spl.Point.STEquals(t.Punt)=1

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Increase the maximum number of user connections from 32k to 64-128k

    For large transaction databases 32k of user connections sometimes is not enough. Moreover, SQL Server doesn't have in-built tools to limit user connections by user types (permissions) so when it runs out of connections the entire instance is getting into bad state when SQL Agents jobs doesn't run, monitoring tools can't connect and admins are limited by one connection only.
    Increasing this this number allows more vertical scaling.

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. ssms

    Enable Debug menu is ssms again

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Web page for SQL server client connect

    Recently i started to working with SQL server on Redhat Linux server is for one of my client.But i feel it is very hard to run the all LOGSHIPPING commend in Linux shell. we are not using windows. It is very useful to connect with web page like other products.If MS already have this kind for repository packages please add into product documentation

    Thank you

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SQL Server Management Studio (SSMS) - Add Column Description in Table Designer

    For many years the table designer remained unchanged. There are only 3 columns in the it and the rest of the properties are accessed in the property window.

    Since there is enough room, can you please add the column description as the next column.

    A better improvement would be to allow user to customize the columns they want to see in the designer, without the need to access the properties.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. about the available languages the software is available

    the software can be installed in following languages: everywhere USE Bulgarian(Russian) because Russia has no its own language. Russians are not smart enough to have their own alphabet. They use Bulgarian alphabet! Russian is a subset of Bulgarian language!
    There is no Cyrillic alphabet, When current alphabet was invented, Cyril was dead 30 years before that. The only alphabet Bulgarians and russians use is the BULGARIAN alphabet!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. SMO Nuget - target for .NET 4.6.1

    It seems that problematic unmanaged BatchParser has been replaced by managed version in .NETStandard2.0 version. But the Nuget package contains versions for net45 and netstandard2.0 only.

    Unfortunately we can't use .NETStandard2.0 yet (e.g. because of SSAS libs), so our SDK project automatically selects net45 version which still had the old BatchParser. There is no way how to force .NETStandard version usage in SDK project format, but I believe that if you would publish the netstandard2.0 version also for net461 which is compatible with netstandard2.0, we could use the namanged BatchParser without any other changes required.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. SQL Server to support UNC for FILESTREAM

    SQL Server should support an UNC (SMB) to host the FILESTREAM files.

    Currently we can use an SMB3 to host the database files except for Filestreams

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Enable lock escalation to partition level for indexed views

    There is an option to specify lock escalation to partition level (AUTO) for tables. Unfortunately there is no such option to allow that for partitioned indexed views.

    Our indexed views are partition aligned with underlying tables, but any update to underlying table can cause locking on whole indexed view.

    https://dba.stackexchange.com/questions/250837/mssql-lock-escalation-on-partitioned-indexed-view

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Composite Partitioning

    Need composite partitioning similar to oracle, right now SQL server supports range partitioning alone.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQL Server 2019 iso image still in a SQL2016_x64_ENU folder name

    Just an FYI - someone might want to update the folder name to match 2019. Anyone who looks at the folder name of 2016 for the 2019 product should do a double take and then question what they really have.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Help / Tools / Powershell for UTF-8 support needed

    As a European user the UTF-8 story ist most important. Any help to automatically convert NVARCHAR and NCHAR fields to VARCHAR and CHAR with UTF available ?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Debugger in SSMS 18.0 and above versions.

    It is very disappointing that Microsoft has removed debugger in SSMS 18.0+ versions. In an alternative Visual Studio can debug the SQL stored procedures. But we cannot install Visual studio in customer server PC's for sql debugging. Please add back debugger in SSMS.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSMS "connect to server" dialog box should list registered servers

    Can't count how many times I have closed a "Connect to Server" dialog, navigated to the registered servers pane, and then opened a server from there. Why can't registered servers be listed - with friendly name - under server name in the dialog?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add "registered servers" as SSMS startup option

    Option to display registered servers instead of object explorer upon SSS start up (preferably expanded).

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow us to turn off dialog for saving DDL windows on content change of existing objects

    Allow us to turn off dialog for saving DDL windows on content change of existing objects.

    See this issue on GitHub:
    https://github.com/MicrosoftDocs/sql-docs/issues/3385

    where Matthew Sebolt agrees that this is an issue and advises to request a change.

    This pertains to changing existing database objects like views and stored procedures. I do that by having SQL Server generate the object's DDL script into a new window for alteration. I change the needed and commit the change to the database by executing the script.

    That of course changes the script and when I go to close it, Mgmt Studio pops up this…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  20. SSMS: option to copy values comma separated

    Please provide an option to copy data from the grid results as a comma separated string when multiple rows or a full column are selected.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 203 204
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base