Answer Questions

• GS80 SSB scenario, can it be done?

  I currently have a workflow "like" application which uses msmq to pass messages to each step transactionally. I'd like to take advantage to something like SSB to make the app scale. Here's how it works today: Start Workflow WebService puts message on queue. Windows Service has threaded listeners on each queue for the workflow. The listeners do a transactional Receive off the queue. By doing this is in a transaction, we can enforce that only one listener will pick up and process the message. Once they have a message they call a .Net Assembly to perform some work. Once the work is performed succesfully, the listeners put the work context on the next queue using the same transaction as the receive and commit the transaction effectiv ...Show All

• Nayan Paregi Problem with PreComputed Partitions and numeric partition key (HOST_NAME())

  BOL says the following (headed with important): "The HOST_NAME () function returns an nchar value, so you must use CONVERT if the column in the filter clause is of a numeric data type, as it is in the example above. For performance reasons, we recommended that you not apply functions to column names in parameterized row filter clauses, such as CONVERT(nchar,EmployeeID) = HOST_NAME () . Instead, we recommend using the approach shown in the example: EmployeeID = CONVERT(int, HOST_NAME ()) . This clause can be used for the @subset_filterclause parameter of sp_addmergearticle (Transact-SQL), but it typically cannot be used in the New Publication Wizard (the wizard executes the filter clause to validate it, which fails because the compu ...Show All

• LamptonWorm nvarchar(max) gets truncated at 4000 chars(?)

  I’m trying to call sp_ExecuteSQL with a query that exceeds 4000 characters. DECLARE @sq NVARCHAR ( MAX ) DECLARE @from NVARCHAR ( MAX ) SET @sq = N 'SELECT Quite, AFew, Columns' SET @from = N ' FROM NumerousTables WHERE LotsOfConditions=''very big query...''' SET @sq = @sq + @from PRINT @sq -- This appears truncated at 4000 chars in the Messages tab. EXEC sp_ExecuteSQL @sq , @params , @Param1 , @Param2 , @ParamN , @Param10 -- gets errors Any suggestions Thanks. Thanks for all the help. I've dropped back to EXEC (@sq + @end); I figure I want a new query plan every time anyway, since criteria can differ so much that different tables are joined. But can the m ...Show All

• JoshKorn Reporting Services Render issues in IE

  Hi We are having an issue with reporting services when it is viewed in IE. We can design the report in visual studio and it looks fine, however when we upload the report to reporting services it displays the report incorrectly (shown below) http://static.flickr.com/103/298669551_7395fc946d.jpg When it is print previewed it looks like this (which is the correct layout) http://static.flickr.com/104/298669558_cfd56ffd0e.jpg Any advice would be most appreciated! Thanks Ross Ross, You're running into the differences between the renderers. Designer preview and print preview use a GDI-based renderer, while Report Manager uses an HTML-based renderer. There are some pretty significant differences in the way borders and other e ...Show All

• lms07424 Configuration Order

  I am trying to use the SQL Agent to specify the connection properties of the connection manager that supports all of the other SQL Configurations in my packages. It would appear that configuration files specified in the SQL agent job are applied after the other configurations. I have the same package I want to use under different configurations on the same machine. This package is also portable across to other machines. so cannot have any location information embedded in the package. Does anyone have a solution for this Philip Coupar wrote: I am trying to use the SQL Agent to specify the connection properties of the connection manager that supports all of the other SQL Configurations in m ...Show All

• CSharpShooter microsoft decision tree algorithm

  I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian score to split criteria is it true Well, anyone could help me to understand about microsoft decision tree algorithm, please give me details explanation with some example(cases). thanks for anyone help There are links to the appropriate research papers at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/986.aspx Th ...Show All

• ti_m Implementation Question - MODE / MEDIAN - CACHE processing

  Hi, I am about to implement MODE and MEDIAN as - more or less - custom aggregation functions by calculated members. Now I am concerned about the performance of my really big cube. Could I use CACHE to imporve performance An how is CACHE at processing time - if i process only parts of my cube (one Partition of one MG) is CACHE processed only for this part or for the whole cube I expect a Cubesize >= 50GB and never could process at all (and therefore want to be sure that the cache is only processed for the parts I process ) (expect 5 MG and 60 Partitions per MG) Best Regards HANNES MG....Measuregroup Unfortunately CACHE is not currently supported in AS2005. I believe it was available early during the beta cyc ...Show All

• bigmac7669 Working with a Package is Extremely Slow

  I have a package that reads the contents of 11 Excel files into various tables. Opening this package in the designer, or with DTExecUI is extremely slow. In both cases when I open the package is takes over 10 minutes to do anything. Visual Studio gives the "Visual Studio is Busy" message for 10 minutes and DTExecUI just hangs. DTExecUI actually hangs twice, once when opening the package and a second time when clicking "Execute" (totalling over 20 minutes). It seems like no matter how I try to run the package it will always hang for 10 minutes before running with no status message or anything. Once it runs it completes quickly with no errors. The various tasks in the package are fairly simple, most being Source > D ...Show All

• matthew pearson Page Number

  I haven't been able to find anything on this. I need to reset the page number when printing invoices. This is something that is available in Crystal Reports. Does Anyone know how this can be accomplished. ex. customer # 1 will have 5 pages so on each page you would see page 1 of 5 , 2 of 5 etc, when customer changes it would start over. I have tried this post but can not get it to work. I was also told by Microsoft that this wasn't supported. Ask if it might in future and person I was working with couldn't find anything in database. hi, report can be grouped by customer number and page number can be reset on new group. plz refer to the site below. http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.a ...Show All

• AlexReg Monitor SQL Server status through Notification Services

  Hello, I am new to Notification Services. My question is can notification services be used to monitor the status of sql server 2005 (stopped/started) and databases (online/offline). Thanks I probably wouldn't use NS for this. Use the Microsoft Operations Manager with the SQL Server MOM pack. The MOM pack is available at http://www.microsoft.com/downloads/details.aspx familyid=79F151C7-4D98-4C2B-BF72-EC2B4AE69191&displaylang=en . Or, you can use SQL Trace and event notifications to receive notifications of SQL Server events. See the Montioring Events section of SQL Server Books Online for more information. See http://msdn2.microsoft.com/en-us/library/ms190378.aspx . -Diane Lars ...Show All

• GS80 Giving permission to view CERTAIN records

  I've been looking through permissions to see if it's possible to grant a user permission to see only certain records from a table. For example: I'm granting users to view records in the table 'Sales', but I only want the users to see their respective data. User A should only be able to see Sales where Sales.Location = 1 User B should only be able to see Sales where Sales.Location = 2 ... and so on. I believe I've read this is possible, but in looking through the permissions you can define, I've only found where you can limit the columns a user sees, not records. Anyone have any ideas or did I just remember something wrong You don't really need a view for each user, you'll need one fo ...Show All

• PsychUK Running value

  Hi In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***% For the Row % under total i write like this: =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2) For the *** % under cumulative total the expression is: =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100, sum , "AgeByGender" ) But i am getting this error: The Value expression for the textbox '* ...Show All

• A.Russell performance tuning on high volume server

  I am looking to improve the performance of my sql server databases. I currently have a dual location system, the database server setup is basically a quad xeon with 4gb at my office and a double xeon with 4gb at a remote webhosting location. There are separate application/web/intranet servers at each site. The two databases servers are replicated with the local server publishing to the remote server. The relational database holds circa 26 million records, growing by a volume of 10,000 per day, there are approximately 50,000 queries performed per day. My theory is that the replication of the two databases is causing a slowdown; despite fast network connections (averaging 200ms between servers) the replication seems to place a ...Show All

• Rraj Passing parameter to query from main form

  I'm creating a report in SQL Server Reproting Services which requires start date and end date as parameters. These date values are keyed in by the user on a form and I need to pass these date values to the query (or dataset) that will use to filter and obtain data from the database. How do I pass the date parameters from a form to the query Should I create report parameters for the dataset in the report Yes. Create two report parameters, one named StartDate and the other EndDate. In the query you'll refer to these two parameters as @StartDate and @EndDate. Do this for any parameter you want to pass into your query. You can use report vi ...Show All

• Mach1 Expression to Parameter

  I would like my header text not to be hard coded I took a very big table which include texts i need from my DB to DS How can i pick a single row with single data in it to be bind to my Paramter Could you explain this in more detail HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All