Answer Questions

• Hossam Abdel Wahab Named sets and Existing

  I have a very large Account dimension (> 2,000,000 members). I would like to create a named set for the top most profitable accounts. I plan to use this named set in the SSRS Report Builder to compensate for its lack of aTop N feature. The problem is that the user can change the fiscal period and SSAS needs to reevaluate the set. Using Generate function won't work for performance reasons. So, I'm trying to use Existing to force the set generation. e.g. CREATE SET CURRENTCUBE .[Top 5 Profitable Accounts] AS Order ( TopCount ( ( EXISTING [Account].[Account].[Account]. Members , [Period].[Period]. CurrentMember ), 5, [Measures].[Profit]), [Measures].[Profit], DESC ); However, this gives me " The Period hiera ...Show All

• mariap Sorting SSIS packages in SQL Management Studio

  Hi, Is there a way to sort the SSIS packages in the SQL management Studio It seems like the list under MSDB is sorted by the date which the package was originally imported. Look for Darrens response in below link http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=748034&SiteID=1 ...Show All

• Gondore How to access data in a SQL Command in the OLE DB Destination editor

  Instead of blindly inserting all my data from a previous task into a table using "Table" as the Data Access Mode in the OLEDB Destination editor. I would like to join this output with a reference table and insert only qualifying rows. Question is "how do I access the data from previous task so that I can do a meaningful equijoin" I know I have to use the "SQL Command" data access mode, but what next Thanks. chiraj If you are using an OLE DB Source compoennt then you can sort the data in there which means you can get rid of the SORT component which is a serious performance hit. You'll still have to set IsSorted=TRUE on the output of the OLE DB Source - but ...Show All

• Phantom208 Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000

  Hi, Recently we have migrated our application from MSDE 2000 to SQL Server Express 2005(SP 1). This has significantly reduced the performance of our Windows.NET application which is developed using C#. For example : While logging in to the application two databases are being attached. Time taken in MSDE: 16 secs Time taken in SQL Server Express 2005 : 58 secs Also note performance is degraded for normal screens where data is retrived from database using inline queries. Questions: 1) Is there any special(optimum) configuration(installation parameters) while installing the SQL Server Express 2005 setup 2) Is there any query optimization to be done w.r.t SQL Server ...Show All

• Alessandro Camargo Converting a HEX string to its binary representation

  I am trying to take a hexadecimal representation of a binary number and convert to the true binary representation so that I can compare it against a binary field in one of my tables. After reading the documentation it seems I should be able to do this with the CAST or CONVERT function. However it does not appear to be working correctly. Can you tell me why this T-SQL code produces the wrong binary value: DECLARE @value binary(16) SELECT @value = CONVERT(binary, '0764DE49749F274EB924E1552FFE09EC') PRINT @value This prints out: 0x30373634444534393734394632373445 That is not correct it should be: 0x0764DE49749F274EB924E1552FFE09EC Thanks Thank you very much. I have to support SQL ...Show All

• B M E Date Range Issue

  I've been trying to find a good way to do this and it seems every idea I come up with or find only accomplishes the desired result in one scenario. Here is my issue. I'm designing reports with SQL Reporting Services 2000 and many of these reports need to show values for a dynamic date range such as the last full month, last full week, etc. similar to the built-in functions in Crystal Reports. To accomplish this, my first effort was to filter my results by looking only at results where a specific date parameter matched the current week or month -1 or -2 or whatever was needed. The following example would look at records for the previous month only: SELECT * FROM tbExample WHERE MONTH([Entry Date]) = MONTH(GETDATE())-1 AND YEAR([Entry ...Show All

• Indigo Cowboy Unnatended uninstallation

  Does anyone knows how to Uninstall SQL Server Express from command promt in unnatended way I've already achieve the unnatended Installation but i try the reverse steps to uninstall and they didn't work. Any information wolud be helpful Hi, I've been trying the unnistallation following the steps from the page but seems that they don't work, I'm trying to unninstal de Express Edition in a pc that works only as a local server where the Instance is SQLExpress when y try to run start /wait "C:\Program files\Microsoft SQL Server\90\Setup Bootstrap" setup.exe" /qb REMOVE=ALL it shows a messages that indicates that to install or configure system components I have to use the control panel. ...Show All

• oNe_Child Installing AdventureWorks DB in SQL Server 2005

  Where do you have problems In installing the SQL Server service or the database With the successfull installation of the installer package of the Adventureworks database you will only get the file written to the specified folder. YOu will need to attach them / or execute the db creation script on your own. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Banthor wrote: Adventure Works did not come with my installation DVD. Is it available online Google to the rescue download sample databases here http://www.microsoft.com/downloads/details.aspx familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en Walk-through http://msdn2.microsoft.com/en-US/librar ...Show All

• Eivind Gussiås Løkseth count(*) for Indexes?

  Hi guys, Just wondering if there's a way to do count(*) for indexes to get the total number of the indexes in a table. Cheers, Justin No slap from me, that's for sure. But be careful with the settings as some of them can make the indexes not what you are expecting. In 2005: Use AdventureWorks go select name, type_desc, is_unique, is_primary_key, is_unique_constraint,is_hypothetical from sys.indexes where object_id = object_id('Person.StateProvince') This returns: name type_desc is_unique is_primary_key is_unique_constraint is_hypothetical -------------------------------------------------------- ----------------- --------- -------------- -------------------- --------------- PK_StateProvince ...Show All

• Andrew Buyan Error during install of SqlServer 2005 64 Bit edition - please help!

  Hi Folks,    I'm receiving an error when i'm trying to setup a maintenance plan. I'm getting weird errors (and cannot continue) and i'm thinking it's related to a 32 bit error i received during installation on a 64 bit edition.    Background    We have a sql server behind hosted on a dedicated 64 bit box out of SanFran. The hosting company installed the 32 bit version of SqlServer 2005 standard on the box and I requested them to remove it and put the 64 bit edition on. They removed the 32 bit edition and installed the 64 bit edition. So far so good. I installed sp1 and that was fine. I then tried to start a MAINTENCE PLAN and was denied -> the component was not installed. I've asked them to install th ...Show All

• EnigMa_AnGeL Sharepoint Beta2 Office Server Serach

  Hi, Sharepoint Search doesn't return any Results. Eventlog Shows: Event Type: Error Event Source: Office Server Search Event Category: Gatherer Event ID: 10027 Date: 05.09.2006 Time: 13:42:14 User: N/A Computer: SAxxxxx Description: Failed to update committed transaction in SQL, DocID is 23647. Context: Application 'SSP_CORE', Catalog 'Portal_Content' Details: Value violated the integrity constraints for a column or table. (0x80040e2f) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Does anyone know about this Problem install Technical Refresh SD Admin Backup of Web App's delete Web App's incl DB delete SSP incl. Content and Search DB recreate ...Show All

• DVaro Relationshiptype in type 2 Slowly Changing Dimensions

  Hi, I've got a cusomer dimension buil on a type 2 slowly changing dimension with following attributes: customer group customer name customer number (business key) surrogate key I've got one hierarchie: customer group -- customer number and defined a one to many relationship between customergroup and customer. What I am not sure about: Can I choose relationshiptype = Rigid for this relation When a customer is moved to another customer group, a new record in the dimension table will be added. Before change Group A nr. 12345 surr. key 1 after the change, a second record was added Group A nr. 12345 surr. key 1 Group B nr. 12345 surr. key 2 So the relationship ...Show All

• Dirk Haest Service Broker end conversation

  Hello people I am new to service broker and would like a little help please. I have a SP which gathers information from a collection of tables. Depending on the data gathered it may or may not begin a dialog conversation with a service broker queue. What i'm needing to know is should at the end of the SP once the required message has been sent should i end the conversation or not Many thanks in advance, Michael No, you should leave the conversation active untime it has finished. If you send only one message then the destination should end the conversation when it has processed the message. This will result in an EndDialog message being sent to the FROM SERVICE of the dialog and when the ...Show All

• rad9k call db2 stored procedure

  Are there any examples of aclling a db2 stored procedure with input and output parameters from sql 2000 tsql Thanks use linked server.. example: EXEC sp_addlinkedserver @server='DB2', @srvproduct='Microsoft OLE DB Provider for DB2', @catalog='DB2', @provider='DB2OLEDB', @provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;' EXEC sp_addlinkedsrvlogin 'DB2', 'false', NULL, 'DB2User', 'DB2Password' Then use OPENQUERY function to call your target DB2 objects.. See more on online book about Linked Server. Thanks for the update. I see examples of using openquery with db2 select statements b ...Show All

• billqu How to create a report using multiple databases

  Hi, I am a beginner of Reporting Service. I am trying to create a report using multiple databses. For example, I want to create a report called RevenueByCustomer, so I need to get data from the Customer Table of CRM database, which contains customer information, and I also need to get data from Transaction table of Sales database, which contains all the revenue information. In order to get data from both database, I have created two dataset. One is Customer dataset, which get all required customer data from CRM database, and the other is Revenue dataset, which gets data from Sales database, they used seperate datasource (because each datasource only contains one database connection). Now my problem is how can I make them be displayed in on ...Show All