Answer Questions

• karthik asok Price Aggregation Question

  Hi all, I have a cube that has time, product, and location hierarchies. I also have the retail price for every transaction at the leaf level. I am having trouble writing the mdx to get the aggregation the way I need them. In the time dimension, at the non-leaf level, i want the last retail price of the children in the time. ie: if I am at the quarter level, i want to show the price of period 3. In both the Product and Location dimensions, I want the retail price to be averaged at the non-leaf levels such as Product category and Zip code. I don't really know what the right approach is to make this happen, any advice is greatly appreciated. Thanks, Wino... Hi Wino, Based on my understa ...Show All

• Chris Marts Need some initial direction

  Hi all. The company I work for is looking for a new SQL server. Where can I find information and or a tool for sizing information By sizing information I mean how big a pile of hardware am I going to need to run MS SQL for x number of connected users with x size database, etc. I've been tooling around the internet and MS' site but can't find any info on this. Can anyone shed some light for me Excellant! Thank you. That should get me started. To be honest it totally depends. The DB's I manage on my SQL box have about 50 users, the data is <20gig and im running the Dell PowerEdge750 Server with a Pentium4 HT Processor and it really does fly. By saying fly I mean ...Show All

• sapo Autogrowth values keep changing

  Hi! We have 2 dbs on our dw-server and the autogrowth values for both the data- and logfiles on both of these dbs changes about once a month. The data autogrowth value changes from 10megs to a percentage value between 3200 and 6400 and the log-file value changes from 10 percent to a percentage value between 3200 and 6400. Resulting in huge files and filling the drive. What am I missing here BR John We just upgraded to SP2 for that reason (the fix is supposedly in there), but we're still unable to correct the value. When attempting to change the value, the following error appears: Value of ‘32768’ is not valid for “value’. “Value” should be between ‘Minimum’ and “Maximum’ Parameter n ...Show All

• AndrejJ Transmission of compressed snapshots

  I am using SQL2005 merge replication and have pull subscribers on a low bandwidth link I am compressing the snapshot into an alternate folder. Files are not put into the default folder When I start a synchronization, I would expect the cab file to be copied to the subscriber and then the files to be extracted locally at the subscriber in order to apply the snapshot However, what appears to be happening is that the files are being extracted from the cab file on the publisher (in a UNC specified directory) and then copied in their uncompressed form to the subscriber - resulting in an extremely slow snapshot application. Any ideas what I am doing wrong I have read about the options for using FTP t ...Show All

• dlgrasse Slow Report

  As I sit here waiting for a test run of the report to complete, I'm forced to wonder why it's taking over 10 minutes... so far. The query itself, when run through Management Studio takes about 50 seconds, so why would it take over 10 minutes to generate the report   It's the only query being run, and it's not doing anything especially tricky with the data.  It's all actually being processed in the query, returning some counts and displaying them in a simple list. Any thoughts EDIT:  I should mention that the query itself isn't very simple, so I can understand the query itself being slow... just not the report being 10 times slower than the query in management studio. Could you be more specific please Is it an ...Show All

• NoEgo Which SELECT statement is faster

  Again,... hello all mighty exprerienced developers, here is a beginner :) I am working on app with lots of searches. So far i see two options. Having table with cca 40 columns of nchar data type, querring it with sentences like: WHERE '*3*' LIKE '*3*;*4*;*5*' OR '*5*' LIKE '*3*;*4*;*5*' etc. or have table with cca 200 boolean columns and querries like: WHERE field13 =TRUE OR field 15=TRUE etc. Does anybody know what is faster, how sql server works on one hand LIKE is heavy operation on system resources, on the other hand isn't 200 columns too much tanx for suggestions Best regards, Grega well, your like statment will give you syntax errors. Usally Like Operator is slower than the regular l ...Show All

• sic0198 Formal parameter '@P83' was defined as OUTPUT but the actual parameter not declared OUTPUT.

  We are using SQR for Peoplesoft 8.47 and MS SQL Server 2000. I have a straightforward program that inserts Merit and Accomplishment data from a csv file into 4 tables. The majority of the fields that are inserted for each table are obtained by doing a select on that table. The csv file provides the updated fields to include in the insert. What I have run into is this: If the CSV file has more than 50 rows in it, it bombs with the following error: Formal parameter '@P83' was defined as OUTPUT but the actual parameter not declared OUTPUT. The insert code for '@P83' is this: Begin-sql insert into PS_JOB_JR (Columns listed .....) Values ...... ,&JOBJR.FP_PT_END_DT ...... Etc. The value &JOBJR.F ...Show All

• ryan101 "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)         Messages         * Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - inSsrc_txt" (1).          (SQL Server Import and Export Wizard)      ...Show All

• Ather. Visual Studio 2005 The remote connection to the device has been lost. Please verify the device connection and restart debugg

  Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get The remote connection to the device has been lost. Please verify the device conection and restart debugging. I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back! My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've re ...Show All

• Emy_P OLAP 2005 Calculated Measure using Field/Dimension

  I am building an OLAP Cube off someone else's data model, so i am a bit stuck trying to decision off model decisions already made and being used. They have a field for Satisfaction which has the value Yes, No, and Blank when no survey result was received. I need to make a satisfaction percent based on (count of Yes) / (count of Yes + count of No). So i do not count blank when no result was received. I need the caculated measure to work against all of the dimensions, so i do not want to build such a specific MDX code that it only works with Time, for example. Help will be extremely Appreciated *A If there is a Satisfaction dimension/attribute, with the members above: Yes, No, and Blank, and ...Show All

• Jassim Rahma OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• Mateusz Rajca Can't launch executable from SQL Server Agent Job

  I'm trying to launch an .exe from SQL Server Agent Job and basically nothing happens. I created a job, with 1 step, type is Operating System (CmdExec), run as sql agent service account, and in the command box I typed "start notepad" (no quotes). The job owner is set to administrator. I manually start the job, it processes successfully yet notepad does not launch. I've tried with other .exe's and result is the same. Any advice Thanks! Actually, that's how I have it running now, using Scheduled Tasks :) why do you want to do this anyway..  is this a maintenance task or something thanks joeydj, but I don't think the permissions for xp_cmdshell is an ...Show All

• shivali.sadavarte SSIS Server Agent open the step problem

  I created jobs in SQL Server Agent. Inthe jobs I created steps which name is bankdata.But I am having a problem open the step , Following is the error am getting "Index was outside the bounds of the array. (SqlManagerUI) ------------------------------ Program Location: at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.PopulateGrid(JobStepsData steps) at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.Microsoft.SqlServer.Management.SqlMgmt.IPanelForm.OnInitialization() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.OnBeforeSelection(Object sender, TreeViewCancelEventArgs e ...Show All

• Syco54645 Preview has data but no columns returned

  In my SSIS package, I connect to an external SQL server database. This external database supports a stored procedure that I need to execute to "retrieve data". So in my package, I set the DataAccess Mode property of my OLEDB datasource to "SQL Command" and I provide the command EXEC <proc_name> <Param>,<output_param>. (The proc has an output parameter). The preview shows all the columns and data, but somehow no columns are returned....so when I try to link this data source to a copy column task, I get an error saying the source does not have any columns...any idea why this could be happening. Thanks - Manmeet Unfortunately that didnt work too...this is what I did...I now have this variable that s ...Show All

• Amir_S The item '/' cannot be found. (rsItemNotFound)

  I just installed reporting services standard on windows 2000 sp4; SQL has sp3a. When i first go into the report manager, i get the above error. the current url is: http://ghcacct1/ReportsElite/Pages/Folder.aspx I've looked all over and haven't found any reason why i get this. if there is anyone that can help, i would really appreciate it. thanks, denise I know this was posted about a year and half ago but I had the same problem and was able to fix it. I removed the ReportServer and ReportServerTempDB databases from SQL Management Studio and recreated them using Reporting Services Configuration. Hope this helps anyone having this problem. ...Show All