Answer Questions

• VCplusplus_Neophyte NOT EXISTS optimization

  This is a general question regarding optimization of queries that have a NOT EXISTS subquery. Sample: SELECT * FROM TABLE1 WHERE NOT EXISTS (SELECT * FROM TABLE2 WHERE TABLE1.FIELD1 = TABLE2.FIELD2) Question 1. Is it more efficient in the subquery to specify only one/any field like this SELECT * FROM TABLE1 WHERE NOT EXISTS (SELECT FIELD2 FROM TABLE2 WHERE TABLE1.FIELD1 = TABLE2.FIELD2) Basically, is the query engine actually run ...Show All

• CatalinB Calculating Group Headers

  Is it possible in reporting services to calculate only the headers for each group Reason being, I have a report where I select a list of parts, as well as dates they were purchased, but I only display the most recent entry for a particular part (cost is variable) as well as quantity on hand. My filter works fine, but my subtotals include all the rows for each part (which puts the number way higher than it should be). ...Show All

• jerrylhl Stored Procedure being saved in System Stored Procedures

  We recently upgraded to SQL Server 2005. We had several stored procedures in the master database and, rather than completely rewriting a lot of code, we just recreated these stored procedures in the new master database. For some reason, some of these stored procedures are getting stored as "System Stored Procedures" rather than just as "Stored Procedures". Queries to sys.Objects and sys.Procedures shows that these procs a ...Show All

• rnc3009 Is assembly code replaceable?

  I'm watching a webcast on CLR functions/procs and have a question: If I create an assembly for my database using some .dll, is that .dll now locked by SQL Server I'm concerned of a situation where developer says the assembly code is bad. Developer presents new version of .dll . - Will I get "Access denied, file is in use" when I try to replace the .dll Even if the assembly is used in a derived table column Thanks. ...Show All

• blabla21 Member count limit

  Hi Guys, Is there a limit in the number of members in a dimension I'm having a problem in showing the other members of my dimension in the pivot table. I've queried the dimension table and found out that the records displayed are from 1 - 32000 only. The rest were not shown in the pivot table. Please enlighten me... What version of Analysis Services you are using: 2000 or 2005 But anyhow. It ...Show All

• Lorenz Buchberger Debugging stops without messages

  Have a task that has 120 tables (components) that I am running in debug mode. Just over half of the components run which takes btrieve db and converts into a sybase db. When it stops running there are a few components that are yellow, the components which completed are green and the rest are still white because they have ran yet. The problem is there is not a message to indicate as to why it stopped. I've broken up the task into two tasks and al ...Show All

• Florian_TT SQL Server 2005 Service Pack 1 CTP March 2006 available

  SQL Server 2005 Service Pack 1 - (CTP) March 2006. http://www.microsoft.com/downloads/details.aspx FamilyID=39ebef74-1c29-49fe-8221-c94f2b52f6c6&DisplayLang=en ...Show All

• IsshouFuuraibou report viewer newbie

  hi, i'm a newbie in using report viewer and having a tough time now building a web app in c# and asp.net.. hope someone can help me on this. i'm using VS2005 and RS2005. i've tried looking at the sample RssNewsReader but i have problem running it. error message : Could not find type 'RssNewsReader.ChannelInfo'. i think this is because i don't have system.ComponentModel in the reference and i don't have this dll file in my system as w ...Show All

• Luc123 OLE DB or ADO?? plz give me a suggestion!

  i am learn database access with native vc++, so ADO.NET is not electable for me. i wonder whether i should study OLE DB first or ADO. i've been working with ADO under VB for some time, it's very simple to use. but i dont think it's the best choice for vc++, i think it's OLE DB. but OLE DB is really difficult, too many interfaces, and properties!!! could u give a suggestion should i learn ADO with vc++ first and then OLE DB, or sould i  ...Show All

• Manivannan.D.Sekaran Beginner Q: Pocket PC access to SQL Server 2005

  Hi, I am a total beginner to Pocket PC, and a 2-month beginner to SQL Server 2005 and Visual Studio 2005. I made a database Pillbox.mdf, and wrote a Windows Forms program to access it. It's really easy. I just added a Data Source, chose tables and Stored Procedures, and dragged them onto my forms. It automatically created adapter classes and a DataGrid for me. Next, I wanted to do the same thing for Pocket PC. I did the same drag and dro ...Show All

• Ray1127 Windows Licensing

  If my client purchases SQL Server 2005 Workgroup at per processor license and this is installed on Windows Server 2003 and users login using SQL Authentication (Their IT sections policy), what type of licensing is required for Windows Server thanks ...Show All

• beolijza BOL Package example Errors

  Hi There Ok i realize this may not be exactly the correct place to post this, but i seem to get good advice here. I am trying to follow the SMO Tables DBCC Package Sample in BOL. I have copied the Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SmoEnum.dll to my latest .NET Framework folder as specified in BOL example. Problem is when i try to run the package i get the following error: -------------------------------------------------------- ...Show All

• Bassam Execution Plan display

  I am trying to run some stats on my database and have utilized the Execution Plan. I have run the execution plan and can see the data concerning the I/O for my clustered index scan when I mouse over the plan. How do I get this info into some sort of a table or text format for comparison Thanks J. You obtain the information in a text format if you use the SET SHOWPLAN_TEXT ON and OFF and between them your q ...Show All

• RameshPa Network access to Sql Server 2005 Express

  I have an application written in VB Express and uses SQL Server 2005 Express that runs on my local machine (name JERRY).  I published it onto a CD and installed it on another computer (JKNETWORK) on my home network. I've already modified SQL Server Configuration Manager to enable TCP/IP and Shared Memory . I have also added sqlservr.exe to the exceptions in the Microsoft firewall exceptions list. The application opens with ...Show All

• Broomandan Missing labels in chart bar the X axis

  Hi All I have a report with a bar chart. Within each category of the bar chart I have 3 bars that are compared with each other. The problem is that not all the categories labels are shown, even though there is enough free space on the axis (the font is very small). Can I configure the chart thus all the values will apear Thank you. This action does not seem to work at all... the "Side ...Show All