SQL Server

Microsoft SQL Server 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 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. The query processor ran out of internal resources and could not produce a query plan with WHERE in and several thousand values

    The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information. (SQL-42000)

    SELECT DISTINCT value FROM sometable WHERE id IN (several thousands of values)

    Hardly complex.
    For SQL 2005 http://support.microsoft.com/default.aspx/kb/946020

    However this does not appear to be fixed for SQL 2008

    A workaround is to build a C# CLR Tabular function…

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

    Upvotes: 34

    <=-=Dec 23 2009 4:50PM=-=>

    Thank-you for taking the time to post this issue. Whilst we will not make a change to SQL 2008 to increase the limit of elements in an IN list, we are working to improve such limits generally in a future release. Please be aware however that with such queries, better performance is likely to be achieved by inserting the constant values into a temp table and performing a join with the underlying permanent table.

    Sincerely,
    Campbell Fraser
    SQL Development

    <=-=Dec 27 2009 11:32PM=-=>

    Inserting into a temp table is impractical when dynamically generating statements based on previously queried results sets where the WHERE data used orginally can not longer be used, such as after an UPDATE. Or when the process is the result of a dynamic process in a external application. In the case where I ran across this a the values being…

  2. datetimeoffset breaks sys.extended_properties

    On SQL Server 2008, adding an extended property w/ type DATETIMEOFFSET via spaddextendedproperty breaks sys.extendedproperties.

    Extended properties are still visible through SSMS -> Table -> Properties -> Extended Properties.

    Reproduced on the following systems:

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

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

    Upvotes: 1

    <=-=Dec 30 2009 2:53PM=-=>

    Hi Peter,

    Good catch. This bug is now assigned over to the Dev for further investigation and fix.

    Thanks,

    Jim Hogg

    <=-=Mar 23 2010 2:50AM=-=>

    Hi Peter,

    We investigated this particluar issue and the fix for this will be part of our future releases. There is a similar bug that we are tracking for this issue – http://connect.microsoft.com/SQLServer/feedback/details/379631/ssms-partition-functions-with-datetimeoffset-cause-error-crash . Given this, I am going to resolve your issue as duplicate of the other issue.

    Thanks for catching this issue and reporting to us.

    Thanks,
    - Vikrant Arora

  3. SP1 CTP Cube Designer freezes when trying to access the Calculations, Perspectives and Tranlation Design Tabs

    Clicking on these tabs results in the BIDS indicating it's loading the definitions you want to see for these tabs, but never returns.

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

    Upvotes: 1

    <=-=Mar 24 2006 11:40AM=-=>

    Dave, in our initial attempts we were unable to repro this in house. We are going to continue investigating. To help us, could you please check the versions of these binaries: programFiles\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ msmdgsrv.dll and programFiles\System\Ole DB\msmdlocal.dll.?

    <=-=Mar 24 2006 12:44PM=-=>

    We have been unable to reproduce this in house. Without such repro, I’m afraid we cannot investigate the issue any further. More information might help us, such as the version of the binaries mentioned before, how much RAM you have, a history of SQL installations on this machine, whether you made changes to the AdventureWorks DW sample, etc. Thank you for your help!

  4. Using "+" instead of aggregate

    Results are inaccurate when using "+" to define calculated members inside cubes.

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

    Upvotes: 1

    <=-=Apr 19 2006 11:32AM=-=>

    Dear customer: I couldn’t repro your problem by repeating the repro steps on a simple cube. Could you please provide the AS project or the AS database? You can send it to hfeng@microsoft.com. Thanks. Hanying Feng

    <=-=May 1 2006 5:40PM=-=>

    Dear Customer, I can not reproduce your problem by following the repro steps. Please provide more info. Thanks

  5. [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x04A3AD14.

    Using the Visual Studio product to modify/test dts package that run daily on SQL Server 2000, I receive the following error:
    [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x04A3AD14.


    1. what component?

    2. the only file name referred to is a file that is validated(correctly) in a later step

    The point being that this is an initialize global variables step.

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

    Upvotes: 2

    <=-=Feb 23 2006 11:56AM=-=>

    Not able to repro this issue.
    I try to repro using:
    1) Migrated the DTS package to SSIS. Migratd, edit and execute correclty.
    2) By using the Exec2000packageTask in BIDS able to edit and execute the DTS2000ActiveX package
    Did you migrate the DTS 2000 ActiveX package?
    Are you edit the ActiveX task in BIDS using the Exec2000PackageTask
    Thanks

  6. arithmetic overflow while in the Tasks Summary Report

    arithmetic overflow while in the Tasks Summary Report.

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

    Upvotes: 0

    <=-=Feb 1 2006 4:28PM=-=>

    Hi Brian,
    Thank you for your feedback. Would it be possible for your to send the dump for this crash? Please attach to this feedback/bug.
    Thanks,
    Ramesh Singh

    <=-=May 2 2006 3:00PM=-=>

    The repro steps provided do not repro the issue on SQL Server 2005 SP1. Could you please provide additional repro steps or configuration settings if this is still an issue for you in SP1?

    <=-=May 30 2006 12:04AM=-=>

    This bug is not reproducable on Sql server 2005-RTM and Sql server 2005-SP1. Could you please provide additional repro steps or configuration settings if this is still an issue for you in SP1?

  7. Severe performance degradation accessing AS2K cubes with ANONYMOUS USER and Yukon OLAP provider

    When our product, ProClarity 6.1, accesses AS2K cubes using ANONYMOUS USER access and the Yukon OLAP provider, creating a connection takes approximately 15 minutes. If I use the AS2K OLAP provider instead, connection takes less than 5 seconds. During the establishment of the connection, our product identifies a collection of unique member names that it can use as query scoped members in an MDX query. To do this we construct a potention member unique name. We then perform a MDSCHEMA_MEMBERS lookup with a restriction set to our potential name. The purpose of the lookup is to confirm that the member…

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

    Upvotes: 0

    <=-=Jan 27 2006 4:44PM=-=>

    Please try including “ConnectTo=8.0” in the connection string, and let us know if it fixes the problem?
    Thank you

    <=-=Feb 10 2006 4:58PM=-=>

    I tried setting ConnectTo=8.0 The setting had no effect. A connection still required 15 plus minutes.

    <=-=Apr 24 2006 2:36PM=-=>

    “Dear gbraach, We have been unable to repro this issue. Could you please provide additional information or repro steps?”

    <=-=May 1 2006 4:41PM=-=>

    I reproduced this problem using SQL2K5 SP1

    <=-=May 18 2006 5:24PM=-=>

    Thank you for reporting this issue. Our investigation shows that there is no difference in the schema retrieval time (Proclarity connection) between Yukon provider and Shiloh provider connecting to AS 2000. This means, we are not able to repro the following: “If I use the AS2K OLAP provider instead, connection takes less than 5 seconds”. The reason of the performance degradation might be in the way Proclarity…

  8. MDX - NON EMPTY clause combined with Crossjoin() function removing calculated members from axis when they actually resolve to a n

    When the non-empty clause is added to an axis that has a dimension (other than the measures dimension) that has calculated members and is crossjoined with another dimension, the calculated members are excluded from the result set.

    0 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 →
  9. Microsoft SQL Server Management Studio Express raises errors on inline comments.

    Microsoft SQL Server Management Studio Express raises errors on inline comments on lines like:

    CREATE PROCEDURE SampleStoredProcedure
    P1 int, -- Param 1
    P2 int -- Param 2

    AS
    ...

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

    Upvotes: 1

    <=-=May 27 2006 1:25PM=-=>

    This code worked for me:

    CREATE PROCEDURE SampleStoredProcedure
    @P1 int, — Param 1
    @P2 int — Param 2

    AS

    SELECT P1 = @P1, P2 = @P2
    go
    EXEC SampleStoredProcedure 47, 11
    go
    DROP PROCEDURE SampleStoredProcedure

    Could you supplement the bug report with a complete repro that demonstrates the problem?

    <=-=May 30 2006 2:44PM=-=>

    Hi Andy,
    Thank you for your feedback. We are unable to reproduce this in build 09.00.2047 – the SSMSE RTM build that we shipped with SP1.
    Thanks,
    Ramesh Singh

  10. SSIS Data Mining Query Task: Prediction Join "erased"

    After a given user creates a Data Mining Query Task in SSIS and saves the package or project, when another user opens the package or project, the contents of the "Query" tab in the Data Mining Query Task (the prediction join) is erased.

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

    Upvotes: 0

    <=-=Jun 27 2008 7:03PM=-=>

    Hello Paul.

    Thank you a lot for reporting the problem to us.

    Unfortunately it is too late for the current release of Analysis Services to take any action on this matter.
    We are going to take a look at this in the next release.

    Thanks.
    The Analysis Services Team.

  11. Management Studio DMX Query crash

    When trying to execute an DMX Query within Management Studio 2008 RC0, I get an error is produced:

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

    Upvotes: 0

    <=-=Jul 25 2008 12:33PM=-=>

    Lachender.

    Thank you for reporting this problem to us.
    Unfortunately it is very hard to say just based on the information in this case on what is happening with the SQL Management studio. Or whether the problem is with Analysis Services.
    To troubleshot some more we suggest you try and run SQL Server Profiler against Analysis Server.
    See if you get any server errors as responce to your query.

    The Analysis Services Team.

  12. MSFT - Maddog: PDW doesn't report scale data always on charts

    Sometimes the PDW server activity history reports don't include scale on all the charts, thus making the chart fairly useless.

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

    Upvotes: 1

    <=-=Jul 6 2008 10:06AM=-=>

    Hi Josh,
    We understand the problem and how to fix this. We are looking to include this in the first CU for 2008.
    Thank you,
    Bill Ramos

    <=-=Jan 2 2009 8:10PM=-=>

    Hi Josh – The issue is fixed in CU2 – I have download instructions in my latest blog at: http://blogs.msdn.com/billramo/archive/2009/01/02/case-of-the-missing-database-name-in-activity-monitor.aspx
    Thanks,
    Bill Ramos

  13. SSMS: Single column results to text: Regression and nvarchar/varchar inconsistency

    SSMS inconsistently space-pads string results for single-column result sets. Varchar-type results are padded to the column alias or maximum display length, but with a minimum width of 4. Nvarchar-type results, on the other hand, are not padded. This is both an inconsistency and a change in behavior from previous versions.

    Because of this behavior, it is impossible to produce in the results pane (for cut and paste where needed elsewhere, for example) the exact result of executing one or more single-column string-type selects. Saving results to a file retains the spurious padding.

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

    Upvotes: 5

    <=-=Jun 30 2008 12:15PM=-=>

    Steve,

    The issue is understood in the use scenario. It could be a regression introduced from a fix for right-to-left scripting languages. In column aligned mode, it is by-design but other modes such as comma, tab and space separated modes, it should preserve the original behavior. I will escalate it to the product team.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=Aug 30 2011 3:42PM=-=>

    Hi Steve Kass

    Thanks for writing in to report this issue. We have added this to our backlog of approved fixes for a future release. I’m resolving as “won’t fix” for accounting reasons on our side.

    Thanks
    Sam Hughes (Product group PM)

  14. SSMS : URLs are underlined, why?

    SSMS underlines URLs, and does so in confusing ways (it doesn't always stop underlining when the URL ends).

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

    Upvotes: 2

    <=-=Jun 30 2008 12:26PM=-=>

    Aaron,

    Thank you for reporting the issue. IntelliSense parser ignores content of string but it seems like coming from VS editor module that SSMS QE uses. We will investigate the reason.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=Jun 28 2011 11:20AM=-=>

    Thanks for your feedback. This particular problem should be fixed in the next release of SQL Server.

  15. KPE - JHU - SSMS throws OutOfMemory exception on large result set

    Running a query with a large result set from SSMS results in an System.OutOfMemoryException in SSMS

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

    Upvotes: 3

    <=-=Jun 27 2008 11:05AM=-=>

    capnsue,

    Can you please provide us more detail on the issue? Was it running on Result to Text mode or Result to Grid mode?

    Thanks,
    Eric

    <=-=Jun 30 2008 11:21AM=-=>

    The described behavior happens when you are doing Results to Grid.

    I just tried the same query with Results to Text and found different behavior

    Query returns some number of rows (can’t tell how many because the “rows” indicator at the bottom of the results pane remains at 0
    and then returns with an error that says “could not replace text”

    Results to file produces: (104831923 row(s) affected) and no errors

    <=-=May 28 2011 12:20AM=-=>

    Hi,

    This is regarding the connect item 353243 you previously filed. Given that there is a workaround for the issue (save to file) and comparing other higher priority issues, we are triaging not to fix this issue. Please feel…

  16. Role Security at different levels of hierarchy

    I have two roles that specify dimension security at two different levels of the same hierarchy. Visual Totals are specified on both roles. Each role works fine individually, but when a user is assigned to both roles, the visual totals don't work as expected. You see the grand total at the parent level.

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

    Upvotes: 0

    <=-=Oct 13 2008 11:18AM=-=>

    BIHunter.

    Thanks for reporting the problme.
    The issue looks to be �by design� (though could look like not immideately intuitive ):

    If at least one role has visual totals disabled, then the user will see real totals even if other role enable visual totals (this is also for compatibility with Shiloh).

    In this particular case, the per-attribute visual totals settings are:

    Role1 Role2

    State Yes No
    City No Yes

    So no visual totals get applied on any attribute.
    We believe the solution is to enable visual totals for both State and City in both roles.

    Hope this helps.
    The Analysis Services Team

  17. CREATE GLOBAL CUBE does not support cascading many-to-many dimension relationships

    The CREATE GLOBAL CUBE statement does not support cascading many-to-many dimension relationships. It gives an error even if all measures and all dimensions are included. A single many-to-many dimension relationship is supported, but if more m2m relationships are chained together, the CREATE GLOBAL CUBE doesn't work.

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

    Upvotes: 5

    <=-=Oct 13 2008 11:19AM=-=>

    Marco.

    Thanks a lot for reporting the problem.
    The current version of Analysis Services does not support what you are trying to do. We will take a look at your suggestion for the next release.

    Thanks again.
    The Analysis Services Team

  18. ClosingPeriod Function in Analysis services does not utilise partiton pruning

    I have an Inventory cube with a time hierarchy where the days roll into weeks and weeks into months and months into years.
    I have a base measure for inventory.
    the cube is partitoned by week
    When I select weeks 1-4 (which make up month 1) and select month 1 simulataneously and look at the trace in profiler, 4 partitons are accesed.
    I then created a calculated measure using the closing period funcion and again ran a similiar query for the same time period. This time all partitons in the cube were referenced and the query was much slower.
    I…

    0 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 →
  19. Modify Stored Procedure from Object Explorer

    Create a procedure/function with commenting a Comment and try to modify the procedure by selecting the procedure in object explorer and clicking modify.

    Funny thing someone submitted the Bug last Year as per this forum thread still not fixed it.( what a ...)
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=862972&SiteID=1

    0 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 →
  20. sp_helptext output loosing format of the code when displayed in grid...

    To get and edit a stored procedure source code I use the sp_helptext which sends the output to result pane. If the result pane is in text mode the code that is printed is retaining the the original format with tabs and spaces etc.

    But when the results pan is in grid mode (CTRL+D) and if I do select all rows and copy and paste the code into a new code window the code is loosing it's format. All the tabs are getting converted into a space.

    Regards,
    Ashok Guduru

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

    Upvotes: 2

    <=-=Jul 9 2008 8:37AM=-=>

    AshokGuduru,

    Thank you for the feedback. This feature will be tracked as a feature candidate of future release.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=May 18 2011 10:35PM=-=>

    Dear AshokGuduru,

    We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

    Thanks for writing in to Microsoft.

    Sincerely,
    Deepesh Srivastava

    <=-=Feb 15 2012 11:40AM=-=>

    Eagerly looking forward to the fix,

    Krishna
    date: 02/15/2012

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base