Answer Questions

• JHagan SQL Server 2005 Indexing

  1) Most of our PK's are non-clustered. In this case when should we go for a clustered index. 2) Apart from Primary Keys which are indexed by default, I am going for single column indexes for foreign keys & other columns which are involved in WHERE, GROUP BY, HAVING & ORDER BY. 3) When is a covered index good to have i.e. a composite index on entire select list. 4) When should we go for a index on HERE, GROUP BY, HAVING or ORDER BY columns followed by select list columns. 5) Are functional indexes allowed in SQL Server i.e. when column is in function like ABS/MAX etc. If so, what is the DDL 6) When data has been encrypted and we decrypt while selecting, how to make sure that index gets picked. ...Show All

• LynnOoi Buildind a report builder.

  Hi all, Does anyone have information on coming up with the report builder The Microsoft bookonline do not help to much. Thanx in advance. If you want to play around with some samples, you can use the new BOL samples (which are renewed within the new July release of the BOL) or this link here: http://msdn2.microsoft.com/en-us/library/ms345268.aspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• R.Tutus Another Mysterious issue in SQL 2005 & SSIS

  Explain this: Package runs successfully from BIDS It runs successfully in SSIS store It runs successfully when I manually execute the Job JOB FAILS EVERY FREAKING NIGHT Jamie Thomson wrote: s Have you installed SSIS on the server that SQL Server Agent is running on Yes - SSIS is installed It'd be easier to explain if you provided more information. Such as an error message. I would imagine this is something to do with the user that SQL Agent is running under. I also can't recommend this article highly enough: Scheduled Packages http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html -Jamie TheViewMaster wrote: Message Executed as user: MyDomain\Administrator. Th ...Show All

• Ali Katouzian Migrate 2000 to 2005 with Index Move

  I will be migrating many databases with a great many indices from an old Win2K/SQL2K box to a new super-duper Win2K3/SQL2K5 box. The old box had a single raid 5 array and I will configure the new box with 2 raid 5 arrays. My plan is to put the data on one array and the indices on the other, thereby splitting the I/O work. I have 3 questions about this. Can the Copy Database Wizard perform the indices move in the same operation as the copy I found a T/SQL script http://www.sqlservercentral.com/scripts/viewscript.asp scriptid=1541 to recreate the indices on the [SECONDARY], but if the wizard can do it in a single pass it would be preferrable. If I have to use the T/SQL script, it does not move the Primary Key index. Is there a reason for t ...Show All

• Idanz Programmatic export to Excel file

  I would like to call reporting services p rogrammatically and save the report to disk in Excel format. I do this now via calls to Crystal Reports from VB .Net. Is there anyway to do this with Reporting Services I still would be using VB .Net. Yes, you can access a report server from another application using the web service. Here's a pointer to using the web service: http://msdn2.microsoft.com/en-us/library/ms154699.aspx ...Show All

• Eissing Using IDTSEvents interface when running a Package

  I am running a package from a C# application. I would like to use the IDTSEvents interface to capture events from the package such as OnPreExecute, OnWarning, OnError, etc. I created a class (PackageEvents) that implements the IDTSEvents interface. I pass a PackageEvents object into the Application.LoadPackage call that creates the package. The package runs successfully as usual, but nothing happens in my PackageEvents class. None of the breakpoints hit (I put one in every function). What do I need to do to get the class that implements IDTSEvents to be called All the properties of the package object seem reasonable at runtime. Here is a code snippet that shows what I am trying to do: // Class that implements the IDTSEvents i ...Show All

• Whoisit How to Send a T-sql data along with notification.

  My SSNS sends an email with the following details. Attention sales team: Order ID : 47 Order Date : 8/26/2006 8:40:23 AM Customer ID 2005e4 This is an auto mail.Please do not reply to this message** ========================= I want the following data is also append to the above message which is returned by a T-sql query. Product ID ProductName OldQuantity New Quantity 1 Glucose 677 509 2 Anotopozin 167 159 3 Clotimazole 456 450 4 Citrin 30mg 77 23 5 Avil 4mg 8000 5678 6 Becozules Z 4567 2469 So,where i have to write the T-sql query so that i ...Show All

• David Sadler Advice???

  hellooo I have an Accounting system(vb.net 2003, SQL server 2000), every new year data is cleared, but i may use some data from previous years (such as liabilities) whats the best way to that -Shall I create programmatically a new clone DB every year (new DB with same structure as previous year) OR -Shall I add a "year field" for tables in DB knowing that data will keep growing every year whats the best solution, knowing that i dont want the end user of my application to do anything manually, such as creating DB ...... Thank you ohh sorry i forgot to tell you SQL Server 2000 Enterprise Edition Have a look at SQL-DMO. You find the ...Show All

• Alan Zhou Sql Report???

  I can view my pdf for my report but when i am debugging my application i see the URL for my report but the Server tells me that my report does not exsist....How do I create the report on the server so that it can find it...I am using Sql Server 2000 and VS.Net 2005 any help ...Show All

• msv6 Images

  When you have a column property set to image, does it link to or does it embed the image in the table Davids Learning Hi ! If you are in SQL Server 2005, I would prefer the VARBINARY(MAX),as the IMAGE and the TEXT are tro be deprecated in further versions. If you are on SQL Server 2000, I would prefer using either the IMAGE or the TEXT (in common it makes no difference, because they are nearly implemented the same way, beside that the TEXT type has some extra function which on work on that type). In this case, as you appearantly will need no functions of the TEXT type, I would choose IMAGE. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- If you specify ...Show All

• Tom_Liu Excel Numbers format

  Hi all i'm having an issues when i trying to do a report: i make a report and there is a field which contains data that can be numeric and numeric with letter: "77756" or "345WS" when i export my report to excel i and i open it i get like a make in the upper left coner of the cells that have only numbers asking me to convert this to numeric format, but this think is that i need this values to be string so i can apply filtering. is there a way that i can format my cell to string so the excel take it like that and allowme to do the autoifilter. I would really appriciate your Help Thanks If you can provide an example of what you a trying to accomplish in the generated sp ...Show All

• Fenghus Problem while navigating Report on server

  Deploying to http://localhost/ReportServer Deploying data source '/Report Project1/cnt_SDS_REQUEST'. The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file.   When I try to update the Web Service Identity field, it is greyed out and does not allow updates. Currently set to "NT Authority\Network Service" Are you reusing an existing report server database You get this error when the report server does not have access to the symmetric key that we use to protect sensitive data in the report server. After a default installation, you should have access.  I ...Show All

• Alex Levin Calculated Measure with MDX query

  Hi All, I need an MDX Tuple Expression that calculates and return the value based on two values to a dimensional parameter. select [Measures].[WA Quantity] on rows , {[TIME DIM].[CALENDAR MONTH MMMYY].&[6-Sep] , [TIME DIM].[CALENDAR MONTH MMMYY].&[6-Aug] } on columns from [Demo Cube] will give me two columns on measure "WA Quantity", but my requirement is to get to know the difference between the value of WA Quantity in 6th Sep and 6th Aug. How to do this. Any thoughts/solutions will be really helpful. Regards, kart Thanks Paul. It worked Regards, kart Hi Kart: I think you can accomplish the difference calculation with a calculated member. The fol ...Show All

• Amir Goodarzi Drill to detail in ProClarity

  Hi, This is from a previous post I had put, http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=973310&SiteID=1 ProClarity gives a "Drill-To-Detail" by default. When you click on that it shows the key columns for the fact tables. It uses Drillthrough for this. I tried defining drillthrough actions in ssas 2005, but they come up seperately as actions in proclarity. The "Drill-To-Detail" is still displayed on right-click at proclarity. The actions are working in ssas 2005, but according to the definition, if a drillthrough is executed, if no return columns are specified, then it picks the return columns from the action that resembles similar query target. This does not seem to work for me! if nothi ...Show All

• ronks AMO - Memory Error !!! PLEASE HELP

  based on the Adventure Works example i decide to create the DSV, when i call the method ' AddTable ' as follows: ------------------- private void AddTable(Microsoft.AnalysisServices.DataSourceView dsv, OleDbConnection connection, String tableName) { OleDbDataAdapter adapter = new OleDbDataAdapter( "SELECT * FROM [dbo].[" + tableName + "] WHERE 1=0", connection); DataTable[] dataTables = adapter.FillSchema(dataSet, SchemaType.Mapped, tableName); DataTable dataTable = dataTables[0]; dataTable.ExtendedProperties.Add("TableType", "Table"); dataTable.ExtendedProperties.Add("DbSchemaName", "dbo"); dataTable.ExtendedProperties.Add("DbTableName&q ...Show All