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.
-
RC0 RS - Tablix Header Does Not Remain While Scrolling
When creating a new RS Report, you can not set the Column Headers to remain when scrolling after clicking on the appropriate checkboxes in 'Tablix Properties'.
(See attachment 'Tablix Headers1.jpg')Another interseting item: When importing a previously created RS report (here from CTP 6) that already has the columns settings set to be visible when scrolling, you can not reset the tablix headers such that they are not visible when scrolling. If you unclick the 'Show Headers While Scrolling', the report's table will still have the column hears visible when scrolling.
(See attachments 'Tablix Headers2.jpg' and 'Tablix Headers2a.jpg')0 votesUpvotes: 5
<=-=Jul 17 2008 11:20AM=-=>Thank you for reporting this issue. It is a known usability issue we will fix in a future release. 2005 table reports upgraded to 2008 do not contain a group header area. Fixed rows and columns are set with the FixedData property on the relevant tablix member. The “Headers remain visible while scrolling” options only apply if there is a tablix row or column header area. You can see them on the design surface above and to the left of the double dashed lines if these areas are in your data region. Drop a new matrix onto the design surface to see an example, matrix always contains a row and column header area. We will make enhancements to make this easier to set in a future release.
<=-=Jul 17 2008 2:01PM=-=>I see how dropping a new matrix will let you do that now…
-
Visual Studio 2008 freezes when a BI Project is left Idle for some time
If I open a BI project, such as Reporting Services and Analysis Services, and leave Visual Studio idle for some time, Visual Studio 2008 hangs. I am unable to select any items in the project.
0 votesUpvotes: 2
<=-=Jul 24 2008 8:58PM=-=>Thanks a lot Teo for reporting the problem.
This is likely problem with beta version of Visual Studio. We expect you should see this getting fixed with VS 2008 SP1.
Thanks again for reporting the problem.
<=-=Aug 29 2008 6:38AM=-=>
Edward MelomedNot fixed with Visual Studio Service Pack 1. I leave an Analysis Services project open for a while and IDE freezes. The only way to get around it is to shut the devenv process inTask Manager.
<=-=Jan 13 2009 1:04PM=-=>Any Word on this? Is there a hot fix for this bug?
-
Invalid COPY-PASTE-operation behaviour for cyrillic text in scripts in Management Studio
If I copy (CTRL+C) sql-script (from Management Studio) which contains cyrillic comments or strings and script is saved with default (ANSI) encoding or not saved yet then copied text is pasted (with syntax highlighting) into MS Word with wrong symbols instead of cyrillic ones. If I save script as Unicode (UTF-8 with signature) then cyrillic symbols are pasted into Word correctly. Unicode and Unicode (big endian) encoding behave like ANSI (incorrectly). If I paste code into Word or Notepad as plain text (using any file encoding) then cyrillic symbols are pasted correctly.
I believe that it is not MS Word…0 votesUpvotes: 3
<=-=Jul 17 2008 2:06PM=-=>Alexey,
Thank you for reporting the issue. Can you please let us know whether MS word had know issue of displaying cyrillic text on the settings? In the mean time, I will forward it to product team to investigate.
Regards,
<=-=Jul 17 2008 8:09PM=-=>
EricThank you Eric.
<=-=Aug 11 2008 10:21PM=-=>
Unfortunately I din’t realize what you mean speaking about “know issue of displaying cyrillic text on the settings”. Can you please clarify?This also happens with Romanian symbols (a�st): if pasted as plain text they are fine, if pasted normally (as RTF) they show as “����”.
Razvan Socol
<=-=Jun 20 2011 12:47AM=-=>
SQL Server MVPHi Alexey,
This is regarding connect item 356388. We looked into the issue carefully, but unfortunately it is not likely that we will be able to address the issue in the near future. Accordingly we are…
-
one of the Newly Added column's don't replicate NULL value
After adding 3 columns to a Table with the following schema data is not replicated for one of the newly added columns
--commented columns are the newly added.I initially got this in a SQL 2005 64 bit environment and then when I test it with the 32 bit SQL 2008 RC0 same result.
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GOCREATE TABLE [dbo].[TESTTABLE](
…[TESTTABLEID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[ID] [int] NOT NULL,
[Code] [nvarchar](3) NOT NULL,
[ERName] [nvarchar](30) NOT NULL,
[ExCode] [nvarchar](10) NULL,
[TSymbol] [nvarchar](12) NOT NULL,
[INCode] [nvarchar](12) NOT NULL,
[CSCode] [nvarchar](9) NOT NULL,0 votesUpvotes: 1
<=-=Jul 15 2008 2:56AM=-=>remove the timestamp column.
<=-=Jul 15 2008 12:57PM=-=>Thanks for reporting this. We will investigate this issue
<=-=Sep 18 2008 6:14PM=-=>This issue is being fixed in upcoming SQL 2005 service pack
-
Microsoft.SqlServer.BatchParserClient.dll not included in Microsoft SQL Server 2008 Management Objects
We are developing and testing against a SQL 2008 server. The required assembly Microsoft.SqlServer.BatchParserClient.dll is not included in the downloadable feature pack. I had to copy the DLL from a machine with SQL 2008 installed to the client machine. This assembly is not found after trying to use Database.ExecuteNonQuery Method. I believe this required assembly should be installed with the rest of the SMO assemblies.
0 votesUpvotes: 19
<=-=Jul 15 2008 4:31AM=-=>Hi,
<=-=Jul 18 2008 1:42PM=-=>
Thanks for reporting this issue. This issue is already fixed and will be available in next public release of Sql Server.
Thanks,
SravanthiI had the same issue . I my case I installed the 32 bit version of SMO to windows 2003 server and it did not install Microsoft.SqlServer.BatchParserClient.dll which caused a problem during execution.
<=-=Nov 24 2009 10:12AM=-=>It may be fixed as far as the assembly cach install process for smo , but it is not fixed for creating
redistributable setup packages.I have sql express advanced editions with sp1 and vs 2008 with sp1 installed. I have a Report Installer setup
package which uses an imbedded vb.net app as an execution event installer process. I ported this project to
2008. I had to update the vb.net smo refferences to sql 2008, and it did not… -
Ragial gauge range dissappear after calibrating the scale
- Drop a radial range.
- Calibrate the scale.
- The default range disappears from the design image but it�s the Ranges collection
0 votesUpvotes: 1
<=-=Jul 25 2008 10:23AM=-=>Completely agree, and it’s something we plan to address in the next release.
-
SQL Server 2008 Express Advanced Password Expiration Checkbox Grayed Out
After installing a fresh copy of SQL Server 2008 Express Advanced on Windows 2008 x64 Enterprise Edition I found that if I didn't uncheck the box for "User much change password on next login" during SQL account creation I could not uncheck it later because it was grayed out in the properties of that user. I had to delete my test database and test user and recreate them with this checkbox unchecked. I cannot alter SQL Server policies in this edition due to it being crippled, so this was the only workaround I found. Until I did this, no remote…
0 votesUpvotes: 0
<=-=Jul 21 2008 2:25PM=-=>Hello Crumb,
Thank you for reporting this problem. SQL Server will prompt for the user to change the password the first time he/she logs into the server. If you would like to check/uncheck the option after the Login was created but before the user has logged into you could recreate the login. We will look at this issue for a future release of SQL Server.
Thanks,
KarthikMS SQL Server
<=-=Jun 10 2011 6:42AM=-=>Hello Crumb,
Thanks for logging the issue.
We discussed and triaged the issue along with the other issues that have been logged in the SQL Server bug database, and due to other critical issues and resource and time constraints, we are not taking-up this issue for fixing it. We have taken note of this internally, and when we revisit this functionality in the future, we will try and get this…
-
AMO Update Error. Memory error: Allocation failure : Not enough storage is available to process this command.
Hi all,
I have a looping code in C# using AMO which accepts dimension objects, makes some changes such as addition or updation of attributes and hierarchies. It also updates properties for the dimension and the lower objects(Like attribute and hierarchies).
The full Description of the error can be found in MSDN forums at the following link :
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3625890&SiteID=1There is another link in this thread that can be used as a reference. I will attach the trace file to this feedback for reference.
Regards...
Girija Shankar0 votesUpvotes: 0
<=-=Sep 8 2008 6:47AM=-=>I have added a workaround which worked for me. Can you please confirm and close this issue .
Regards..
<=-=Oct 13 2008 11:26AM=-=>
Girija ShankarGirija.
Thanks for findning the workaround. Can you please attach the workaround to this issue.
Currently it doesnt look like it has been added. -
Service account Startup mode during install is available for selection
When installing a SQL 2008 cluster, the Service account Startup mode during install is available for selection. It defaults to Manual but it could be changed to Automatic or Disabled that should not be possible on a Cluster
0 votesUpvotes: 1
<=-=Jul 18 2008 3:52PM=-=>Fabio,
We will look at this for the next release.
We shouldn’t create service accounts during prepare ideally, but we do due to ACL’ing reason during setup (to avoid re-ACL’ing during complete). Ideal fix is to remove service configuration from Prepare for next release (so that we can be fully sys-prep ready).
Worst case, if we do not change the current behavior for next release, we shouldn’t allow user changing the service start up type from Manual on Prepare UI.
But, there is nothing in Windows SCM that prevents user from changing the service start up type anyway. So, even if setup does not allow this, we cannot block Windows SCM from changing it.
Thanks,
Max
<=-=Jun 9 2009 2:51PM=-=>Hi Fabio,
We plan “not to allow” changing the startup type for clustered services for our next major release. We have an existing item…
-
Query plan operators costing more than 100%
For the query below, the overall cost estimate is less than the estimate for some individual operators. As a result, relative costs exceed 100% for these operators. The overall cost calculation appears to be incorrect, because it did not account for both subtree costs.
0 votesUpvotes: 1
<=-=Jul 18 2008 1:32PM=-=>There is some explanation here:
<=-=Jul 21 2008 5:06PM=-=>
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=267530Dear Steve,
Thanks for pointing out this inconsistency. This is a know bug and we’ll link your comment up with the known bug. We’ll see if we can address this in a future release.
Thanks,
<=-=Jul 21 2008 5:10PM=-=>
EricDear Steve,
Thanks for pointing out this inconsistency. This is a know bug and we’ll link your comment up with the known bug. We’ll see if we can address this in a future release.
Thanks,
<=-=Aug 10 2011 1:21AM=-=>
Erichi Steve,
This is regarding the connect item 356913. Occasionally when queries have conditional statements (or more than one execution path) the query optimizer costs those paths too while arriving at the optimal plan. This is because in case of estimated plans, the optimizer really cannot decide which path will get executed. In these…
-
Start Powershell failes when connecting to non default port
When connecting in SSMS to a server configured to run under a different port than 1433 and TCP/IP network library only the Start Powershell command failes to connect to the server. The server is registered as SERVERNAME,PORT. The SqlBrowser service is not running.
It seems that the comma needs to be escaped. The next command isn't working within the SQLPS utility as well:
set-location SQLSERVER:\SQL\SERVERNAME,PORT\DEFAULTWhen you change this to:
set-location SQLSERVER:\SQL\SERVERNAME`,PORT\DEFAULT
it works.I'm know the character needs to be escaped in powershell or enoded. The problem is that the connection is failes when is start powershell within SSMS…
0 votesUpvotes: 2
<=-=Jul 18 2008 7:58AM=-=>Hi Robert,
Thanks for reporting the issue on PowerShell. This is by design. There are certain characters within PowerShell that have special meaning. This is mostly documented here: http://msdn.microsoft.com/en-us/library/cc281841(SQL.100).aspxYou need to escape the special characters and there are a few options for doing so:
1) Escape with a tick `
2) Wrap the text in double quotes “blah,blah”
3) Use the hex equivalent %2C
4) Use the Encode-SqlName cmdletBest of luck,
<=-=Jul 18 2008 12:35PM=-=>
Dan Jones
Group Program Manager
SQL Server ManageabilityHi Dan,
Well, I’m aware of that, as I described connecting in SQLPS works when you escape the character. It doesn’t work when you select Start Powershell from the context menu within SSMS. And I can’t escape the characters there, or can I?
<=-=Jan 29 2009 8:48PM=-=>Hi, Robert! This is a bug and we will fix this…
-
SQL Query Editor Extension Mapping
When I map a the .prc extension to the SQL Query Editor, it is not recognized with a File | Open. However, it is recognized when I drag the .prc file into the editor.
0 votesUpvotes: 1
<=-=Jul 17 2008 8:15AM=-=>Hi Tom,
Thanks for reporting the bug. I was able to repro this but only in a very specific way. After I setup the prc extension I opened the file and it did not recognize it as a SQL file. I then restarted SSMS. When I open the file from the recent files list it doesn’t recognize it as a SQL file. However, if I open it using File-Open it does recognize it. It appears that SSMS/VS is caching some information about the file when it’s opened from Recent files. This isn’t something we’ll be able to address in SQL Server 2008. We’ll keep this on the books and review it again when we start the next release.Thanks,
<=-=Nov 13 2008 3:07AM=-=>
Dan Jones
Group Program Manager
SQL Server ManageabilityVery helpful, was able to apply this to UDF extensions too
… -
Disk usage summary does not display space used for data files
Disk Usage Summary built-in report in SSMS (Data Collection) displays "MB MB" instead of the space used for specific data file.
0 votesUpvotes: 4
<=-=Jul 29 2008 8:12AM=-=>Hi brejk,
<=-=Jun 10 2011 6:20AM=-=>
Thank you for your feedback regarding this report. We are aware of the problem and we’ll use this as the tracking issue so that others can vote on the issue. You can use the Standard Disk Usage report for the selected database to view the correct report as a workaround.
Thank you,
Bill RamosHi brejk,
This has been fixed. Please confirm this in the next available public release of SQL Server “Denali”.
Nikhil
SQL Server Team -
after upgrade to SQL Server 2008 spike on processing time in special regard to the indexes portion
Since the upgrade of our SSAS environment on SQL Server 2008 we have noticed a consistent increase on cube process time.
The picture below shows the time spent during process executing using the two version of SQL Server meanly 2005 and 2008.For your convenience I have attached the excel document that the pictures was derived from; as well as the xmla scripts that is used to process the indexes.
We would like to know what could have caused such a spike on processing time in special regard to the indexes portion.
0 votesUpvotes: 1
<=-=Jul 25 2008 11:07AM=-=>Joseph.
Thanks a lot for reporting the problem.
It is very hard to diagnose it without having exact repro in-house.
We suggest you work with Product support to setup a scenario for us to be able to debug and figure out what is happening.Thank you.
The Analysis Services Team. -
Characters and linebrakes are disappering in a Job with powershell that holds an \
Characters and linebrakes are disappering in a Job with powershell that holds an \
0 votesUpvotes: 2
<=-=Jul 24 2008 9:11AM=-=>Eric Verschoor,
Thanks for the report – we will investigate this issue.
-Richard Waymire
<=-=Dec 1 2011 11:47AM=-=>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.Thank you
Alex Grach[MSFT] -
Transaction log file size will not grow exactly 4GB when filegrowth=4GB.
When I set filegrowth to 4GB , 4096MB or 8GB for transaction log file of any database, after the log fills up, the autogrowth will kick in and then I monitor file growth of the log file. It will not grow exactly 4GB or 8GB. It grows in much smaller chunks. Something like, 248KB.
If I set log filegrowth to 3GB, 5GB, 4095MB, 4097MB or anything that's not exactly 4GB, it will grow exactly the set size for filegrowth.
This also happens on SQL2005 Developer Edition and Standard Edition on x86.0 votesUpvotes: 5
<=-=Aug 12 2008 1:22PM=-=>Thank you for your report. This does seem like an interesting anomaly. We will see if we can reproduce this in the current product and addess it in ongoing development.
<=-=Aug 4 2009 9:44AM=-=>I’m seeing behavior similar to this now with VLF and log files on the latest CUs of SQL 2005 and 2008.
I was attempting to create a 40GB log file in 5 steps of 8GB each and I don’t arrive at 16 × 5 VLFs of the same size. I’m going to do some more testing before I log a bug. -
Many to many dimension query returns incorrect value
I've just been shown a repro of what looks like a bug where a query with a many-to-many dimension and the expression MyM2MDim.MyHier.Children in the Where clause returns an incorrect value. It looks like a case where an incorrect assumption has been made for query optimisation purposes. I can repro on AS2005 SP2 and AS2008 RC0.
0 votesUpvotes: 2
<=-=Jul 24 2008 8:50PM=-=>Thanks a lot Chris for reporting the problem.
Unfortunately it is too late to look at this in 2008 release of Analysis Services.
We will take a look at this in the next release.Edward Melomed
<=-=Aug 1 2008 12:56AM=-=>I think that a good solution would be a different one than simply changing the behavior of the query optimizer. I would add a property to measures (or measure groups) to specify if the evaluation of that specific measure/measure group has to always consider the related m2m dimension and its intermediate measoure group or if this passage can be optimized. This would solve the issue I described in my m2m paper (http://www.sqlbi.eu/manytomany.aspx) related to the distinct count alternative measure.
-
Reporting Visual Studio: ShowGrid is not working
In Visual Studio
Tools -> Option -> Windows Forms Designer -> General the Settings are
LayoutMode=SnapToGrid
ShowGrid=True
SnapToGrid=TrueBut there is no visible Grid.
0 votesUpvotes: 79
<=-=Jul 22 2008 1:26PM=-=>Thank you for providing this feedback. With SQL Server 2008 we replaced grid lines with object snapping and snap lines. We will consider this as feedback that you would like grid lines back. We will consider adding them back in a future release. If this feature is brought back, however, it would not be enabled by this VS option, the Designer would have it’s own command to display or hide grid lines. The VS option you mention is for designing WinForms apps, not directly related to the Report Designer.
<=-=Jul 23 2008 2:04AM=-=>Many thanks for your reply!
Greetings
<=-=Oct 23 2008 12:55PM=-=>
WebfredI would also like the SnapToGrid, DrawGrid, and GridSpacing options back. Report development is so much more cumbersome with the object snapping and snap lines. I could actually see how things lined up when the grid was there. Now I’m…
-
Cannot install 08-040 for SQL 2000 on Vista
According to
http://www.microsoft.com/downloads/details.aspx?familyid=8316BC5E-8C2D-4710-8ACC-B815CCC81CD4&displaylang=en
this hotfix is supported on Vista. However if try to run the install on
Vista, it fails with "There is not enough storage for this
command".I have x64, but I have reports that it fails on x86 as well.
Since SQL 2000 is not supported on Vista, the error may be on the download page.
0 votesUpvotes: 1
<=-=Jul 22 2008 10:40AM=-=>The download page http://www.microsoft.com/downloads/details.aspx?familyid=8316BC5E-8C2D-4710-8ACC-B815CCC81CD4&displaylang=en needs to be corrected as SQL Server 2000 is not support on Vista. I will send the message to the appropiate folks.
Thanks,
Peter Saddow [Microsoft] -
Edit Menu -> Advanced -> Tabbify / Untabbify Selected Lines option is not working
I select 10 lines of code and then selected "Tabbify Selected Lines" menu from "Edit->Advanced", but its not working, similary "Untabbify Selected Lines" as well.
FYI, The uppercase and lowercase converts everything into uppercase, if we have some option to convert only keywords to uppercase then it would make the code look good and also please assign some shortcuts for "Tabbify Selected Lines" and "Untabbify as well, because those are options which we regularly use, so using the menu is time consuming so if we have shortcut it would save lot of time and easy to use as well
0 votesUpvotes: 0
<=-=Aug 27 2008 9:30AM=-=>arunraj_c,
Thank you for reporting this issue. We will mark it as a product issue and request dev team to investigate it.
Regards,
<=-=Jun 20 2011 12:31AM=-=>
EricHi Arun,
This is regarding the connect issue 357143. Kindly note that the function “tabify” converts all tab length white spaces to a tab. So there is no visual indication and tabify does not mean to move selected text by a tab. Say there are 4 white spaces in a tab, then tabify would look for 4 consequent white spaces in the selected text and replace them by a single tab character. Similarly untabify replaces a tab character with equivalent number of white space characters.
I hope this explains the behavior. We are closing the issue as by-design.
thank you
Seshagiri
PM, SSMS
- Don't see your idea?