Answer Questions

• Andre Odendaal Sorting Vs Indexing

  what is the difference between sorting and indexing.. Sorting: 1.Query Operator 2. Applied on the incoming row results 3. No exrenal storage on Sorting operation 4. Primary task is ordering the result set Indexing: 1. Object   2. The process of converting a collection of data into a database suitable for easy search and retrieval 3. External storage used to store the index keys for future references 4.Primary task is arranging & maintaing the data.. Both uses Collation for Character Strings It depends. It is a performance and diskspace issue. The general answer for a database that is constantly being modified is never sort it, and always index it. Sorting is only valid with a fixe ...Show All

• Ken Pergola Extremely Slow Package Runtime Execution

    I have a developed a project with a master package that calls 7 child packages. If I run the master package from the IDE and point the child packages to the ones on MSDB, then each one of the packages takes about 2 minutes to complete. But, when I execute the master package from MSDB, then the execution time of each one of the child packages increase more than three time the original execution. I need some workaround or solution for this. Do you know how to get a better execution time or a similar time to the one from the IDE Any advised would be appreciated. ...Show All

• wDiechmann SQL Query Analyzer: Open a new query window with script

  I'm trying to figure out how to open a SQL Query Analyzer window from another window. Yes, I know about Ctrl-N and Ctrl-O. However, we have 25+ SQL servers running upwards of 1,000 databases. I want to write a user-defined function (or something similar) which will read configuration information out of one specific database that describes all of our other databases, and open a Query Analyzer window directly connected to that box. I should be able to be sitting in Query Analyzer and open another window, but I can't figure out how to do this. We've written a simple C program that uses OLE to open a Query Analyzer window, but it's a pain to have to launch a separate program to read the database and then have that open another Query Analyzer w ...Show All

• imdqa Replicating structure only not data

  I have a SQL 2005 database that I am using with a website. This basic website will be sold to other companies and ran on their servers with different URLs. Since, All of these databases will store different data, I'm not sure how I can make updates to original database and replicate those structure changes to the other DBs without changing the data also. Is there a way to automate the replication of structural DB changes without replicating the data along with it Thanks, Kirk I think the following would be a good start General info on transactional replication http://msdn2.microsoft.com/en-us/library/ms151176.aspx http://msdn2.microsoft.com/en-us/library/ms151706.aspx Creating create public ...Show All

• CoderD update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget CaseNumber is Varchar(50) CaseNumType is Int Hi, is the CaseNumber of type non-integer Then you will have to provide the between conditions with single quotes. WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN '199999' AND '600001'; HTH, Jens K. Suess ...Show All

• Prabu. Could I Resolve a KPI's Data Value in a SSIS Script Task?

  Hi, thanks. I could rosolve a KPI's Data Value by ADOMD.net from any .net application. Now I want to do the same thing from the SSIS Script Task. Could I do that SSIS Script Task use a VBA Script. I could use ADO.net in it, by imports the XML.dll. Thanks. ivanchain wrote: But How I don't know how to use any ADOMD.NET functions in SSIS Script Task. Because in the common VS, we need to imports the ADOMD.NET.dll into the projects if we want to use it. But in SSIS Script Task's imports list, I cound not find the ADOMD.NET.dll. Anyone know this Thanks! Aha. Yes, you're absolutely right. I should have realised this before - sorry. Read this: VSA requires DLLs to be in the Microsoft.Ne ...Show All

• IamHuM File growth problem in 2005

  Have a database, one filegroup with one datafile and one log file. However, restarted the box and saw that the growth settings for the datafile was changed from 100Mb increments to 25600%. The logfile is still the same at 200Mb as required. Both have unlimited growth. Looking at sysfiles in the database, growth is 25600 for the log and data file. In Management Studio I cannot change the setting for the data file (log file still shows 200Mb growth increments), Studio tells me "Value 25600 is not valid for Value. Value should be between Minimum and Maximum. Any thoughts Cant really have a database sitting with this growth rate, and cannot change the value in sysfiles either (even with sp_configure etc). Any ideas Thanks ...Show All

• FletchB Column compression

  Hi, I was looking for a column compression functionality in SQL Server Compact and it seems that it doesn't exist (maybe I'm wrong ). I wonder if the SQL Server Team plan to implement column compression and if yes, when can we expect it Thank you for your help! There is compression functionality for SQL Server 2005 (http://www.codeproject.com/cs/database/blob_compress.asp ). The problem with SQL Server CE is that it does not support stored procedures and you will not be able to use this functionality. If you don't need to update the LOBs in your mobile device you can compress them in SQL Server, replicate them and decompress them at presentation time... but to answer your question we (the SQLCo ...Show All

• pawelek Script Component - Timeout Expired

  Hello, I have a script component inside one of my packages that performs a calculation on the fields and then does several insert statements on SQL 2005 database for each row inputed. During the execution, when the data is a bit large ~ 3000 records input that produce around 20,000 insert statement, a "Timeout Expired" message pops up several times from the script component. Although the data enters in the database, but I have to manually click "ok" on each of the messages during run-time. Any idea as to why I am getting this error or how to fix it Below is the code of the script component that does the insert. Thanks for your help. Grace Part of Script Component Code: Try connMgr = Me .Connectio ...Show All

• MueMeister List of Stored Procedures

  How do I get a list of the stored procedures currently in the database Is there a quick way to edit them Thank you! select * from sys.objects where type = 'P' Thanks Laurentiu Hi, if you just want to use a query you can use the INFORMATION_SCHEMA.Views to get the information. If you want to retrieve the data programmtically and as typed objects you should have a look on the SMO classes. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• jakeohara Problem with Transaction Logs

  Hi, I have a big problem with transaction log. I need to reduce the transaction log file becouse, the have 25 GB, but when i run the statement for BACKUP LOG with TUNCATE_ONLY, dont work, becouse i have database mirroring installed. Please is very urgent. Oh I also got this big problem, and I amazing that no MS SQL supporter answer this question clear. Perhaps this has been explained scattered in Ms SQL help. There is 2 way: 1. Take the SQL server model to: simple and schedule 1 daily database backup 2. If the model is: full recovery: must schedule two job after check on: auto shrink database option a./ Backup transaction log file b./ Backup database file And after that you have just enjoy the workin ...Show All

• Sestrin Dynamic Stored Procedures

  Hi everyone, My question is how can i set a var with a table name to use it in a SELECT statement for example. EX: Declare @table varchar Set @table = 'mytable' Select * From @table I've got 1 stored procedure wich i want to use to get and update 2 tables. For that reason i want to know how to do this because having 2 stored procedures when the only difference are table names its not a good solution. Thanks :) Declare @sql varchar Declare @table varchar Set @table = 'mytable' set @sql = 'Select * From '+ @table execute(@sql) visit this link for more info http://www.sommarskog.se/dynamic_sql.html Tiago: You can do what you ask with something like: exec ( 'se ...Show All

• kstus Customised totals

  Hi, I am creating a report using matrix. The reporting services subtotal, sums up the data on all rows. The data in rows contains numeric & percentage values. I need the total for numeric value as sum and for percentage values as weighted average. Does anyone know how to do this or is this limitation of RS. Thanks. You mean you want to have different calculation done in the subtotal as oppose to the one used in detail cells If so, you can use the InScope function to do it. http://msdn2.microsoft.com/en-us/library/ms156490.aspx ...Show All

• J-Pixel Date format

  Hi, I have a date format problem with the AS 2005. I have a Data Mart dimension with a field of the type smalldatetime. I have created a AS2005 dimension with the hierachy "Fulldate" which is based on this field. Due to the language settings of the os and of the cube I would expect that the hierachy would display the date like dd.mm.yyyy Unluckily it appears as mm/dd/yyyy Under the DataItems there is a property format which I tried to use to get the correct displayed datetime ...but whatever I use i always display US datetime format. What can I do to get the dateformat like dd.mm.yyyy Thanks, StSt Unluckily this doesn't help me. The data source is a SQL Server 2005 Dat ...Show All

• Mannequin666 What's the relationship among replication, publication and subscription

  What's the relationship among replication, publication and subscription I want to create replication database, what things should I know first Hi, see: Setting Up Merge Replication(Concepts,topologies, types, agents...) It answers some questions! ...Show All