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. "Edit Query Text" query text doesn't match the actual query in 2017 RTM

    In 2016 & prior versions, when looking at a stored procedure's execution plan, if you right-click on the plan and click Edit Query Text, you get the full text of a stored procedure. In 2017, it's clipping out parts of a stored procedure, and formatting the query differently.

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

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. ENABLE_PARALLEL_PLAN_PREFERENCE

    Document and make it officially supported a new ENABLE_PARALLEL_PLAN_PREFERENCE query option, released in SQL Server 2016 SP1 CU2

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSDT Schema Compare

    SSDT Schema Compare does not provide an option when generating a script to perform IF EXIST. This would be a nice enhancement to allow for scripts to be re-run if necessary.

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Dark theme ignored in Object Explorer

    Dark theme created from Settings file attached.
    All windows except object explorer have dark background.

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

    We’ll send you updates on this idea

    6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. Port Microsoft Connect Upvotes

    Now that Microsoft Connect is gone, and all of the suggestions have been moved here, why didn't the upvote count move as well?

    Is this just Microsoft's way of sweeping the old suggestions under the carpet, by ignoring the previous upvotes and restarting allof the items back to 0?

    6 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 →

    UserVoice didn’t have a way to “set” upvotes during an import. So we didn’t have a choice. To help mitigate that, we did add the UpVote count into the comments. Although unsearchable, we did what we could to preserve that data.

    As for preserving the names, that would have meant exporting user information from a system owned by Microsoft and importing it into a system owned by a 3rd party – which goes against our Privacy Statements. As much as we would have wanted to preserve acknowledgements and credit, we needed to scrub those out.

  6. Make a MacOS version of SQL Server Management Studio

    I really like SQL Server Management Studio but I strongly wish there was a version of it for the Mac OS.

    5 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. data compression SMO bug

    Setting the datacompression to 'None' for indexes doesn't work. Objects are left with the compression setting they had prior.

    Reproducible with the following code

    $server = Connect-DbaInstance -SqlInstance server1
    $table = $server.Databases['test'].Tables['table']
    $index = $table.Indexes['CL_table']

    $index.PhysicalPartitions[0].datacompression = 'Page'
    $index.Rebuild()

    $index.PhysicalPartitions[0].datacompression = 'Row'
    $index.Rebuild()

    $index.PhysicalPartitions[0].datacompression = 'None'
    $index.Rebuild()

    The SQL executed (captured with xevents) is below:

    ALTER INDEX [CL_table] ON [dbo].[table] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100, DATA_COMPRESSION = PAGE)
    ALTER INDEX [CL_table] ON [dbo].[table] REBUILD PARTITION = ALL WITH (PAD_INDEX…

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

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. SQL Server Management Studio 18 GA (15.0.18118.0) not compatible with .NET Framework 4.8

    Windows 10 1903 - SSMS 18 does not start.
    Windows Server with .NET Framework 4.8 - SSMS 18 does not start.

    AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml:
    ...Could not load file or assembly <Microsoft.VisualStudio.Shell.Interop.8.0, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a>...

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

    We’ll send you updates on this idea

    closed  ·  17 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. SSMS RESULT GRID TIP: Add Excel like quick tip for SUM, COUNT, MIN, MAX, AVG

    in next update kindly add Excel like quick tip feature to show SUM, COUNT, MIN, MAX, AVG on SSMS status bar for selected ROWS, COLS, or CELLs.. This feature would be a great help!

    4 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 →
  10. SSMS Automatic Updates

    When there is a new update for SSMS, notifications pop up on the desktop and following the notifications through leads to the SSMS update window, then the user has to download a whole new package (~800mb) before reinstalling over the current (older) installation of SSMS.

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

    We’ll send you updates on this idea

    4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  11. SSMS 17.2 error launching 'Analyze Query in Database Engine Tuning Advisor', 'Object must implement IConvertible. (mscorlib)'

    SQL Server 2016, 13.0.4435.0, SSMS 17.2, database is SQL 2012 compatibility
    ===================================

    The argument type 'server type = Sql, server name = SomeName, timeout = 30, database = inSight_10x, protocol = NotSpecified, workstation = , integrated security = True' cannot be converted into parameter type 'Microsoft.SqlServer.Management.Common.SqlConnectionInfo'. (mscorlib)

    ------------------------------
    Program Location:

    Server stack trace:
    at System.Runtime.Remoting.Messaging.Message.CoerceArg(Object value, Type pt)
    at System.Runtime.Remoting.Messaging.Message.CoerceArgs(MethodBase mb, Object[] args, ParameterInfo[] pi)
    at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

    Exception rethrown at [0]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ISessionController.CreateSessionFromQuery(SqlConnectionInfo connectionInfo, String sqlQuery, String batchSeparator)
    at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnDatabaseTuningAdvisor(Object sender, EventArgs a)

    ===================================

    Object must implement IConvertible. (mscorlib)

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

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. SSMS restore files to wrong locaton

    When adding a replica to an availability group using Full backup option generates wrong code. The database restore on the destination server is generated with the Move option, and database files are restored to the destination sql-server default file location instead of the original files location of the source server.

    This seems to be a "new feaure" in SSMS 17.2 and onwards as older SSMS' do it right.

    All documentation still says that filepath must match on all replica servers!

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your patience. I have created a tracking item in our content VSTS issue tracking system. For the most part, feedback can be made directly to our topics as our new documentation platform supports comments directly on the topic.
    https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation

    As well as you can edit the topic yourself by clicking the “Edit” button on the topic. For help in editing, see https://docs.microsoft.com/en-us/sql/sql-server/sql-server-docs-contribute.

  13. SSMS tab history

    SSMS 17 - Add option to NOT autoconnect restored query editor tabs, or at least background them so that SMSS is usable sooner.

    On startup, restoring previously open query editor tabs is great. However, if there are many, it can hang the startup procedure for minutes. It would be great to disable or background the autoconnect of these restored tabs so that we can get working sooner.

    2 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 →
  14. Include 64-bit Import and Export Wizard in SSMS release

    Currently, the 64-bit version of this tool is only available if you install SQL Server. The 32-bit version is included with SSMS already.

    I'm unable to install the 32-bit Office Drivers because of an existing 64-bit Office installation. I can install the 64-bit Office Drivers, but don't have the 64-bit Import/Export tool available.

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

    We’ll send you updates on this idea

    closed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Please release documentation on data classification categories (GDPR)

    It would be great to have all the corresponding "Information Type" and "Sensitivity level", and their associated GUIDs documented.
    With this, I would be able to add these classifications directly in my DACPAC model as extended properties.

    Examples :
    57845286-7598-22F5-9659-15B24AEB125E / Name
    989ADC05-3F3F-0588-A635-F475B994915B / Confidential - GDPR

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for your suggestion. We’ll review this and take your request under advisement. I’m closing this request since we’re retiring the Documentation category in UserVoice (documentation update requests should now be made on the doc page itself).

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

    We’ll send you updates on this idea

    closed  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Column Aliases to be used in Where clause

    I often find that I have to write some complex calculated columns to obtain a value that I would like to filter on. There is no easy way to filter on these in a Where clause without a copy and paste of the original formula. If you are using a Window function this is not possible. I understand that using a Window function within a Where clause could cause confusion and ambiguity within the engine as window functions are part of the non-relational layer. It would be nice however to be able to reference aliases from the Select statement in…

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

    We’ll send you updates on this idea

    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Make the FIRST_VALUE() and LAST_VALUE() functions more clear that they are not opposites by default.

    FIRST_VALUE() and LAST_VALUE():

    1) Modify the top-line descriptions to make them _not_ sound like exact opposites.
    2) Add a very basic example comparing the two, much like the example comparing the ranking functions.

    Please see the following forum post for a longer explanation:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/29adf6a3-330a-422a-8f26-c01fcfdff285/

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. sqlmaint.exe missing in SQL Server 2016

    According to the documentation (https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016), sqlmaint.exe is included in SQL Server 2016 and will be removed in the *next* version.

    However, after installing SQL Server 2016 Express I noticed that sqlmaint.exe is not present in the Binn directory.

    Thus,
    * if sqlmaint.exe has already been removed in SQL Server 2016, the documentation is buggy and should be fixed, or
    * if sqlmaint.exe should be included, the SQL Server 2016 installer is buggy and should be fixed.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your patience. I have created a tracking item in our content VSTS issue tracking system. For the most part, feedback can be made directly to our topics as our new documentation platform supports comments directly on the topic.
    https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation

    As well as you can edit the topic yourself by clicking the “Edit” button on the topic. For help in editing, see https://docs.microsoft.com/en-us/sql/sql-server/sql-server-docs-contribute.

  20. managed_backup.sp_backup_config_schedule days_of_week parameter does not accept multiple days for a weekly backup

    I am unable to schedule a managed backup with a custom weekly schedule to occur on multiple days. The documentation says that the days_of_week parameter will accept a comma-separates list of full day names, but when you actually try to execute the proc, you get this error: "The value specified for parameter @days_of_week is not valid. A valid scheduling parameter is required."

    This can be easily reproduced by running this script:

    EXEC managed_backup.sp_backup_config_schedule
    @database_name = 'state_your_db_name'
    ,@scheduling_option = 'Custom'
    ,@full_backup_freq_type = 'Weekly'
    ,@days_of_week = 'Tuesday,Saturday'
    ,@backup_begin_time = '07:00'
    ,@backup_duration = '02:00'
    ,@log_backup_freq = '00:05'

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your patience. I have created a tracking item in our content VSTS issue tracking system. For the most part, content feedback can now be made directly to our topics as our new documentation platform supports comments directly on the topic.
    https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation

    As well as you can edit the topic yourself by clicking the “Edit” button on the topic. For help in editing, see https://docs.microsoft.com/en-us/sql/sql-server/sql-server-docs-contribute.

← Previous 1 3 4 5 9 10
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base