Answer Questions

• kkmick SQL 2005 Reporting Services on Load Balanced web servers

  Is the any issues running SQL 2005 Reporting Services on Load balanced web servers Here is a link from MSDN http://msdn2.microsoft.com/en-us/library/ms157293.aspx ...Show All

• sachin303 Unable to connect if mirror down

  We have an application running with a principal, mirror, and witness. If we bring the principal server down, it looks like failover occurs successfully, but the application is not able to access the database. If we bring the server back (so it is now functioning as the mirror), the application is now able to connect to the database. Why isn’t the application able to connect without the mirror up Any suggestions We solved the problem by setting the timeout on the connection string to 60. When the Primary DB is taken off line, the Mirror becomes the Principal. The web application must use the fail over partner (specified in the connection string) to connect. The initial connection takes 40+ se ...Show All

• infomax FK Position

  Does it make any difference where we define the FKs in a table I mean, do I speed up the query if I define it as the second field or the last one What about the other fields, the ones that are not FKs, but are used as filters in a query Column position is virtually meaningless in defining PK's. Column position is virtually menaingless except: 1. In UNIQUE and PRIMARY key constraints, and all indexes, order of columns has meaning. 2. In relatively rare cases, order of column conditions in a WHERE clause is involved (and only when the criteria is so large as to make it impossible for SQL Server to check all possible uses in a timely manner) The position of a column in a table has no little if any bearing on performance, ...Show All

• SGraham1985 How do I find the server name?

  I need to deploy a multi-user application to several different customers. My app was built on VB.net and uses SQL Server Express. For remote client to connect to the server I understand that I need to use a connection string something like this: “Server=ServerName;Database=myDB;Trusted_Connection=True;” My question is, how will I know what the server name is Can that be different for different customers When I test this on my PC, I use (Server=.\SQLEXPRESS;), but what do I use for deployment Thanks. Thank you Andrea for your response. I would like to make the installation an automated process using InstallShield. I will have two install packages - one for Server and the other for Clients. How ...Show All

• Mowali Cumulative aggregation over time

  I want to do cumulative aggregation similar to "period to date", but not to a specific period in the past, but to the earliest record in the fact table. The problem is that I have 20 million accounts that I want to follow up on a daily basis, but they change rarely. After a year, perhaps half a million have changed. What I have done is to create a fact table that stores the balance when the account is opened, then only keeps track of the changes, so that when anyone deposits money a row is added with the increment. After a year that would give me about 20.5 million rows in the table. As an analyst I would like to enter a specific date, say 2005-08-20 and see the balance of all the accounts at that time. To do so, I simply need to ...Show All

• Samuel369 Can't change TCP Port using configuration manager for x64 SQL 2005 SP1 virtual instance

  Hi, I hope someone can help me!   I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!   My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in, after a restart of the instance it comes up with this in the IP Addresses tab for TCP/IP Properties and SQL Server won't start: IP1 Active   Yes Enabled   No IP Address  aaa.bbb.ccc.111 TCP Dynamic Ports TCP Port  0 IP2 Active   Yes Enabled   No IP Address  ...Show All

• Mike Greenway Inserting Dummy Data

  No one answered this question, how do people normally insert dummy data into tables I mean, where does the data typically come from what process is used to insert the data Note: This is for testing purposes, eventually to be tested in a Web-based front-end which I know nothing about. thx, Kat hi kat, I usually enter my ex-girlfriends name in the customers or employee table for testing hahahaha. kidding Aside i generate scripts to fill my DB at least with 20 millioon records or more using loops in the  scripts. that how  i realize how fast sql server is. regards, joey     hi kat, Please find my contact details at my sql blogs published below thanks ...Show All

• Pankaj11 Error when attempting to backup to a second disk file

  In SQL Server 2005, via the GUI, I wish to backup a database to an additional disk file (there is already an existing backup disk file for this database), so that I can have more than one backup. I've added the new disk file name, highlighted it, and clicked OK. I get an immediate error (see below). Note, the 2nd error message is specifying the existing backup disk file, not the new one I'm attempting to create. "Backup failed for Server 'WCS-DEV-TPA'. (Microsoft.SqlServer.Smo)" "System.Data.SqlClient.SqlError: The volume on device 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\WCS_ADV_Longmont.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.S ...Show All

• maxtothemax Percentage/Proportion

  I'm new to Analysis Services 2005 and MDX. I'm trying to create a calculated member that contains the proportion of cases (using [Measures]. ) for each dimension in the cube. The following code gives me the percentage of the total number of members in each dimension. This is what I need for attribute hiearchies (single-level), but for user-defined hiearchies (multi-level) I want the percentage of the above level. For example, in a time dimension, I want the proportion of cases in each year (this works) and the proportion of cases in each quarter of a given year (this doesn't work). CALCULATE ; CREATE MEMBER CURRENTCUBE .[MEASURES].PercentCases AS CASE WHEN IsEmpty ([Measures]. ) THEN NULL ELSE (( [DimLocati ...Show All

• RandomLick Trying to use the AdomdConnection Class, without success

  Hello All, I am attempting to use the AdomdConnection class in my SSIS package, inside of a "Script Task". However, i cant include the reference to the adomdclient.dll (required for the AdomdConnection class). This DLL is in the C:\Program Files\Microsoft.NET\ADOMD.NET\90 folder. I have included the reference to the Microsoft.AnalysisServices.DLL inside the C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\ but this reference doesnt have the AdomdConnection class. Does anyone knows how to include this reference or another way to access the cube status using the Script Task ( or something else ) Thanks in advance. Regards, Thiago > Does anyone knows how to include this reference Microsoft ...Show All

• rwbta Full text search installed but no languages supported :(

  Hi, I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!! Did this resolve the issue Mike Hi Mike, Yes, I know i installed the Fullsearch text but still i do not get languages. I follow the same step's in my other computer and it worked in that one, the only difference between the two systems is that i installed the SQL sever 2005 beta in the one that is failing. ...Show All

• RGLloyd SQLDiag on 2005 64bit

  Hi All, I am working on a performance issue on SQL Server 2005 Ent. SP1 x64-bit cluster. I am lack of available tools I used on 2000. How do you handle performance issues on 2005 64-bit PSSDIAG : not supported SQLDIAG on 2005 x64: giving me an error and I cant find sqldiag.xml file. C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqldiag /O J:\PSS\ /B 200612 20_132100 /E 20061220_132300 2006/12/20 13:21:27.98 SQLDIAG Error creating script file . Function result: 2. Message: The system cannot find the file specified. 2006/12/20 13:21:27.98 SQLDIAG Error unpacking files. Aborting Read80Trace: not supported Blocker script: Thanks, Ada Performance issues ...Show All

• AFTAB Trying to update multiple row

  Hi. I am trying to update multiple row with different value. Is this possible w/ query or should I create a procecure Suppose I have two table A and B, I need to update values of A_b = B_b, A_c = B_c where A_a = B_a below query somewhat shows what I am trying to do... UPDATE A SET A_b = B_b, A_c = B_c WHERE A_a IN (SELECT B_a FROM B) Thank you. Puff: Are you looking for something like this:' use tempdb go drop table dbo.A go create table dbo.A ( a_key integer not null primary key nonclustered, b_value integer, c_value float ) go insert into A (a_key) values (1) insert into A values (2, null, -6.0) insert into A (a_key) values (3) ...Show All

• JPATEL 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

• Kamen 64 Bit SQL Server try to access 32-Bit

  Hi All, I have a scenario where today we are migrating the existing code to new production server which is 64 Bit server. The SSIS packages are put on new server and we are trying to run. I tried to run a simple select query to fetch data from a 32bit remote server from cmd prompt usings a .sql file and it gives me error. But this is the known issue of ‘a 64-bit SQL server trying to communicate to a 32-bit sql server’ and the error message is The error message is similar to the following: The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator. Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset "DBSCHEMA_TABLES_INF ...Show All