Wednesday, October 2, 2013

[SQL Server 2008 issues] 2008 RTM VS R2

[SQL Server 2008 issues] 2008 RTM VS R2

2008 RTM VS R2

Posted: 01 Oct 2013 06:44 PM PDT

Dear AllWhere can I find the differnce between 2 versions of sql 2008Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) VSMicrosoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) RegardsKrishna

connection options to sql server 2008

Posted: 01 Oct 2013 06:58 AM PDT

In a new position that I have, I am told that I will be connecting to reporting services for a sql server 2008 database. My question is, is this where SSRS 2008 reports are displayed and/or deployed to the reporting server? Is this where users can access report buiulder?I am asking this question since I do not know what the difference is between logging into reporting services, integration services, and/or analysis service is setup for?

Optimize join to return single value from (one to many)

Posted: 01 Oct 2013 05:10 AM PDT

Hi,I need to get column from JOINed table but its one to many so I need to select only single instance for c2 , to keep original number of records, I tried to do select top 1 like below but this suddenly gave me very very bad performance, is there any other good way to do this? is there any way to avoid corr query?[code="other"]-- select 100 pk, 'Alpha' c1 into #temp -- drop table #temp;with t as (select 100 pk, 1 level, 'Alpha' c1, 'ID101' c2 unionselect 100 pk, 2 level, 'Alpha' c1, 'ID101' c2 unionselect 100 pk, 3 level, 'Alpha' c1, 'ID101' c2 unionselect 100 pk, 1 level, 'Alpha' c1, 'ID102' c2 unionselect 100 pk, 2 level, 'Alpha' c1, 'ID102' c2)select #temp.pk, #temp.c1 from #temp join t on t.pk = #temp.pk where t.level = 1 AND t.c2 = (select top 1 tt.c2 from t tt where t.pk = tt.pk)[/code]TxMario

approximate timespans for db backups?

Posted: 01 Oct 2013 10:25 AM PDT

Hello, I was wondering if you generally see a fairly consistent timespan for database backups? For example, I just backed up a 5700MB db and it took about 14 seconds. That's about 407MB/s.Based on this metric, would it be reasonable to assume that a 57000MB db would take about 140 seconds to backup? Or do you find that backups become slower or faster at some point?Also, do you tend to see fairly consistent backup times based on database size between different database instances, or do you find that there are db factors which have a significant effect on db backup time? Assume average CPU and RAM between db servers?

Installing a 1t db and best practices to keep 3 data bases in sync

Posted: 01 Oct 2013 05:49 AM PDT

Hi, AllThis is my project which i am going to work on.-- have to install and configure test/dev/prod databases using SQL 2008 and the database have the potential to grow 1t+ (need suggestions and best practices on hardware and software) environment is vmware-- have to keep the prod and dev and test databases in sync all the time -- the test data gets new data weekly through SSIS packages.Thank you for every one for looking at my post

Linked server to DB2 won't show catalogs

Posted: 01 Oct 2013 05:02 AM PDT

I have created the ODBC connection within the IBM Configuration Assistant, then created the linked server to the DB2 database. The connection tests successfully, but I can't see the catalog for the DB2 database. Any ideas?

Trying to remove SQL 2008 R2, getting a dialog about needing to access core_shared.msi

Posted: 01 Oct 2013 03:44 AM PDT

I'm trying to remove SQL Server 2008 R2 Developer Edition from my developer machine, in preparation for installing SQL Server 2012. Right now I'm stuck with a dialog box that says:"SQL Server 2008 R2 SP1 Database Engine SharedThe feature you are trying to use is on a CD-ROM or other removeable disk that is not available.Insert the 'SQL Server 2008 R2 SP1 Database Engine Shared' disk and click OK."I've tried looking for that DVD, but can't find one with that label on it. I've tried looking at every MSDN DVD that I've got, but am coming up with nothing. I'm not sure where this is. The only options the popup dialog box gives me is OK or Cancel. OK would mean that I believe I've found the core_shared.msi file, but since I haven't it will fail. That leaves me with Cancel. I'm hoping that doesn't completely cancel the uninstall. At this point all I can do is hit the Cancel button and hope for the best. I'd love to know what will happen, if it leaves this "SQL Server 2008 R2 SP1 Database Engine Shared" component behind?

SSRS - Cannot Create Connection

Posted: 01 Oct 2013 01:53 AM PDT

Hi There, I am new to SSRS and have basically created a bunch of reports (sysadmin) through visual studio, deployed them and setup the necessary rights, permissions and roles needed per folder on the localhost URL. Now the fun part, the domain user can access the URL get to the required folder but when trying to execute the report the following error is thrown out. An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'RI_TEST_TEXTILES'. (rsErrorOpeningConnection)For more information about this error navigate to the report server on the local server machine, or enable remote errorsI logged in using the domain users credentials that is not part of system admin and i can execute the reports successfully but as soon as the users try they get the above error. I have been at this now for two days but with no luck, i have literally tried everything.ThanksMax

Truncation Error

Posted: 01 Oct 2013 03:19 AM PDT

In an SSIS package I am using a Data Flow Task and I am getting this warming:Warning 2 Validation warning. Load Daily Folios from NVCORP: {6574291C-EDED-4C84-8E07-FABBCAD8883D}: Truncation may occur due to retrieving data from database column "ORIGINAL_SRP" with a length of 11 to data flow column "ORIGINAL_SRP" with a length of 3. NVCORP - STAGE - FoliolinkResvRate_STG - Local.dtsx 0 0 But my SP_COLUMNS shows the following for the ORIGINAL_SRP columnTABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME PRECISION LENGTHFOLIOLINK_RESV_RATE_STG ORIGINAL_SRP 12 varchar 50 50Any thoughts , why it thinks it's only a length of 3??

master.dbo.xp_create_subdir not working for Long Directory names

Posted: 30 Sep 2013 08:46 PM PDT

Hi All,I have created the attached sp for creating sub directories (which has been later integrated in my restore tool) using xp_create_subdir.This works fine for smaller names, but for longer names, the command behaves strangely and does not create sub directories. It is unable to take longer names which is evident from the print commands.This behaviour persists in Sql server 2005/2008/2008 R2(not tested in 2012)for e.g[Create_Dir] 'abcd275_travellinks' works absolutely FineAs soon as you run the below command, it gives errors since it is not able to take longer names :[Create_Dir] 'abcd275_travellinks'Has someone faced the same issue? Any suggesstions would be highly appreciated.Thanks in advance.

performance

Posted: 30 Sep 2013 10:22 PM PDT

Hello dear,in a server i install sql 2000 & sql2008 r2.and link to another server in sqlserver2000r r2 that have sqlserver2000.suddenly all application that connect to sqlserver2008 r2 decreased speeds of them.what happen on?would you please help me?;-)best regards,zohreh

Script for columns' name, data type, length for one table

Posted: 01 Oct 2013 12:36 AM PDT

I am looking for a simple script for columns' name, data type, length for one table and sort by name

Indexing a column with type 'uniqueidentifier'

Posted: 30 Sep 2013 10:33 PM PDT

HiWe have a SP which is giving performance issues. As an example it has been executed 4 times and has an total elapsed time of 68961914. It is the costliest procedure in terms of Worker time. By comparison other have ran 18877 times with a total time of 358513681ms, and 261 times with a total time of 11155273. I know the comparisons are not really helpful without giving you more info about each SP but its just a guide.I have ran an index tuning query and it has recommended an index on the table the Sp uses. The index it recommends is an uniqueidentifier. The table currently has one non-clustered index with read ratio of 180 to a write ratio of 2365.Is it likely that adding this index will aid in the performance of this Sp ? Also should i got for a clustered index or non clustered ? I realise that adding a clustered index will have a performance hit while it re-organises the data in the table.

Rebuild index task/job fails every time...

Posted: 03 Jul 2011 07:18 PM PDT

We are using SQL Server 2008 Enterprise 64bit.And we have made standard database optimalisation jobs via the maintenance plans.The rebuild index task will run weekly, but is failed the last 3 weeks.When I check the history of the job, I encounter following error after 9minutes:[i] Executing query "ALTER INDEX [PK_AboProductType] ON [dbo].[AboProdu...".: 2% complete End Prog... The package execution fa... The step failed.[/i]But this will not give me the information I need to correct this problem!When i want to run the standard report: Index usage statistics, I get following error:[i]Error:Incorrect syntax near '('.[/i]What can I do to get the job running clearly again?I don't know where to start :(
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog