Answer Questions

• wms103006 Why cant we create a partition for Dimension?

  Hello, Dimension also has data.So Why cant we create a partition for Dimension AS 2005 doesn't support partitioning dimension data. This feature will be considered for future versions of the product if there is a popular demand. ...Show All

• enric vives SQLServer Performance to Queries

  Hi, During my working with SQL Server 2000 sometime back in a enterprise application development, we found some performance bottlenecks and tried to resolve the same by following some rules. 1.Having GUIDs as objectIds(primary key) was slowing the queries so we used int datatype instead. 2. Limit the joins in a query to 3 or 4 and denormalise the table if it needed more joins 3.Stop using Dynamic queries and use Stored procedures instead. Are they still valid in SqlServer 2005 too Should I follow the same rules here also Is there any improvement in these rules None of these three have changed from SQL 2000 to SQL 2005 Using GUIDs for your PK is generally a bad idea, since it will cause ...Show All

• Kieron Lanning Replication: periodic initial snapshot not yet available

  I have a push subscriprion (publisher sql2000, distributor 2005, subscriber sql2005) that periodically (twice per month) changes it's status to " ... initial snapshot not yet available ...". Then I need to mark it as for reinitialization and start the snapshot agent (starting the snapshot agent without marking it for reinitilization doesn't starts the subscription to initilize itself). There is nothing important in the logs. Any suggestion why this may happen The network connections between distributor and subscribers sometimes are broken (it's over VPN), but there is a couple of other replication that goes the same way and they are fine... Hi, I'm having the same problem, did anyone managed to resolve this Thanks! Milan ...Show All

• bszom Inserting data from text file to SQL ME table

  Hello, I have an application taht requires the use of a table. The device that this application works on, has a local memory that does not allow me to insert the 800,000 records that I need. Therefore I have two approaches: 1. To insert less records into my local memory database e.g 40,000 but not row by row, bulk insert is better. How do I do the bulk insert 2. This is the most prefferable way: To find a way to insert all 800,000 records into a table on the storage card which is 1GB. What do you suggest Will using threads be helpfull Any ideas I use C# from VS 2005, SQL ME, compact framework 2.0 and windows 4.2. Thanks in advance, John. SQLCE doesn't support bulk inserts. In my opinion ...Show All

• PostMeridian Drillthrough returning sets of duplicate rows

  Drillthrough appears to be showing multiple rows for each single record that should be displayed. For example, in my fact table, there is a single record for each trip. The following MDX query returns a single cell with a trip count of three. SELECT NON EMPTY { [CP Date].[Date by Month].[Year].&[2002] } ON COLUMNS , NON EMPTY { [Commodity].[Commodity by Type and Group].[Commodity Type].&[Other] } ON ROWS FROM [Barge Trip] WHERE ( [Measures].[Trip Count] ) 2002 Other 3 If I drill through on that cell, exactly three records should be returned. However, in actuality, 12 rows are returned - three sets each having four identical rows. To drill through, I am simply adding the D ...Show All

• Murre Create the package on the server, and execute through sql server agent

  Hi, Some of you guys seem to be gurus with the new Integration Services technology, so I hope someone can lend me some advice, as I haven't worked much with integration before. Ok, here we go. What I want to do is select some data from my database and export the result to a flat file (really a .csv file with values delimited by semicolons). Sounds like a simple thing to do Well, I'm sure it is when you know how to do it :) I know I could manage the same thing by writing a C# class that creates that .csv file, but the decision has been made to use Integration Services for these kind of operations. I created an SSIS project in Business Intelligence Development Studio, and created a package (I defined the task flow etc.). By choosing ...Show All

• scribework MS Access Memo field to SQL Server text field

  Hi all, i've a reasonable amount of experience with MS Access and less experience with SQL Server. I've just written an .NET application that uses an SQL Server database. I need to collate lots of data from around the company in the simplest way, that can then be loaded into the SQL Server database. I decided to collect the info in Excel because that's what most people know best and is the quickest to use. The idea being i could just copy and paste the records directly into the SQL Server database table (in the same format) using the SQL Server Management Studio, for example. Trouble is, i have a problem with line feed characters. If an Excel cell contains a chunk of text with line breaks (Chr(10) or Chr(13)) then ...Show All

• wuhuashouce Interval/Bucket Dimension

  I am trying to find the most efficient way of handelling discreet buckets over continuous/discreet set of values. In english I am looking to have a dimension that says if age is between 0 and 5 they are an infant, 6 to 18 child and > 18 adult. I know I can do this in a case statement but I have similar senarios that require multiple levels of nesting and the ability to easily change the banding criteria with many fact table sharing the same banding information. I have done this in the past by preprocessing the fact table and updating the key value based on between joins, but this is very inefficient on large datasets (upwards of 30 million rows). I also need to be able to do this across continuous values such a monetary amounts ...Show All

• KrazyMGA DTS 2000

  Hi, I am having a dts 2000 package which is accessing oracle source and loading data into sql server .The package runs fine when ran individually or from designer. But when it is scheduled into a job, the job is being shown as ran successfully whereas the package is not run or for sure the data is not loaded. I looked into microsoft articles regarding this problem and found that this job will be run under the profile who started the SQL Server Agent.There is another job which is running properly whose owner is xxx. So i changed the owner of my job into xxx. But still the same condition is prevailing, job is being shown as ran successfully while the data is not loaded. Kindly help me on this. Thanks and Regards Arobind ...Show All

• djenerate Is there a load event or run event?

  Is there a load event or report run event for a report that can be accessed I need to have my report jump to a certain url whenever it is run but I cannot use the jump to url because that has to be clicked. I need this to occur automatically. Any suggestions Thank you Ian. I appreciate your response. Is there some way once I use this code that I can make it fire a url I tried the exact same thing Protected Overrides Sub OnInit() Dim request As System.Net.WebRequest = System.Net.WebRequest.Create("http://www.example.com") Dim response As System.Net. WebResponse = request.GetResponse() End Sub And that did not work, So I tried putting a msgbox in the routine and the msgbox did not pop up. So i am no ...Show All

• SDavis7813 Cross-dimension Security Dilemma

  Here are my simplified security requirements: 1. The cube has a Customer dimension (some 150,000 members) and Account dimension (over 1 mil members). A customer can have one or more accounts. 2. Complex security rules in the operational database dictate which customers the user can view based on her identity and application role membership. Therefore, I need to implement dynamic security to retrieve the allowed set of the customer members from the source database. 3. Instead of retrieving the allowed members for the other dimensions, I would like to propagate the security filter of the Customer dimension, e.g. to the Account dimension, so the user could only see the accounts of the allowed customers. What ...Show All

• Tankko Using SELECT...INTO

  Is there a way to maintain all of the indices and constraints when copying the structure of one table to another I used this command to copy the table, but it does not bring over all of the indexes and constraints... SELECT TOP 0 * INTO rft_CPT4_DES FROM rft_CPT4_bak Nope, directly not in T-SQL that is. You need to script the object to build this new object. This is not a practice that is generally considered a "good thing" in building databases (if you are doing this as part of a regular routine, and not just rebuilding the table for some reason.) Table structures should be designed, a script built, and then it applied to create the object. That is how SQL is oriented. If you want ...Show All

• Jon Braganza SSIS Deployment

  Hello, I would like to know how to set up the SSIS package with the DATABASE, SERVER NAME and Connection String into variables, so that I can change these parameters of the deployement, on another name of server and database (and connection string). Thanks a lot for your advices ! Marie-Therese hi, Creating variables from Control Flow layer and defining its scope for example, if you're inside a Script Component you can call a variable previously defined as Dts.Variables("Database").Value HTH Thanks a lot Matt ! Hello Marie, You don't need variables the realize this. Within SSIS you can use Package Configuration to make Database, Server name and connection string configurable. In the Package Config ...Show All

• nate-d-o-double-g SQL Statement Schema

  Hi, I'm trying to return the schema of a SQL statement (using SQLServer 2000) i.e. the column headers that are returned. I've determined that one way is to create a temporary table and to then query sysobjects and sysColumns Select 'Test' Col1, 'Test2' Col2 INTO #Test Where 1 = 0 Select Sc.Name from Tempdb..sysObjects SO join Tempdb..SysColumns sc on so.id = sc.id and so.name like '#Test%' Order By sc.ColID Result: Name Col1 Col2 Which is fine unless a temporary object with the same or similiar name has been created i.e. #Test2 etc... So im not sure if this is best way, alternatively can I use the 'SET FMTONLY ON' option but then how do I get the column headers into a variable. Any pointers or alternati ...Show All

• ibrahimK Placement of sys.conversation_endpoints and sys.transmission_queue

  Is there any thought going into moving these two tables to a file group that we can control Putting this in Primary with the rest of my system tables is quite problematic, and hinders my ability to manage space usage on my files. Traditionally, we didn't have to consider a primary file group that could grow to large proportions, but now with these two tables it can. If a large volume of messages gets sent through and the system can't keep up, then these tables and my primary file group will grow sometimes enormously. The connect item has been closed https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=249443 but no comment on why it has been closed. Operator error, t ...Show All