InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 04:53:26 GMT20http://www.sqlservercentral.com/Forums/Topic1450896-2838-1.aspxShare some questions of Oracle 1Z0-597 exam material below:http://www.scribd.com/doc/139897200/1z0-597It will be useful for you to prepare the test well.Thu, 09 May 2013 00:09:01 GMTacexapdeshttp://www.sqlservercentral.com/Forums/Topic1442945-2838-1.aspxHi Folks I am New To Sql Server.I have Some Confusion Regarding Testing.What is Unit Testing.How The Sql server Procs And Functions Are Tested Whether They Are Worked As For The Need .Is There Any Tools For Database Testing Especially For Sql Server.Help meTue, 16 Apr 2013 12:42:52 GMTAnanth@Sqlhttp://www.sqlservercentral.com/Forums/Topic1441835-2838-1.aspxHello I am in a process to start the stress test using RML utilities. I am newbie in this yet. Please advise with the troubles I faced with.I've got a trace (35GB) fro our production server using a script that the RML's manual provides. That's 10 minutes server's work.Then I was trying to produce .RML files from the trace and have got the errors as below:the first command i've used was:ReadTrace.exe -o"input" -I"traces\trace.trc" -SSQLSERVER1\SQLSERVER1 -aI've got the error:04/12/13 12:36:21.533 [0X00002340] A serious error condition (true == pVariant->FIsUnknownType()) has been encountered. Utility Error: Attempt to use an invalid variant type File: .\rpcbinary.cppLine: 264 Return Address: 0x000007F77A774212 Function: FConvertNCharStringFromRPCThen, I was trying to skip the first trace, starting from the second:ReadTrace.exe -o"input" -I"traces\trace_1.trc" -SSQLSERVER1\SQLSERVER1 -aand got the next error:ERROR: SPID was detected using Multiple Active Result Sets (MARS). ReadTrace can only process this set of trace files with -T35 enabledOK, I've set the -T35 parameter... but got the error, that ReadTrace with this param can't produce .RML files.Please help me to figure out the errorsThank You in advanceFri, 12 Apr 2013 12:16:41 GMTShurgenzhttp://www.sqlservercentral.com/Forums/Topic1376052-2838-1.aspxHi All,I need to know if there is any tool which can be used to for post migration ETL testing? The ETL has been written using sql scripts to move the data from Legacy database to a new database and both have different database structures We need to test the tranformed data for accuracy and check for data quality and quantity after the ETL process is executed. I have questions about the following:1.what should be the best approach/ best practices to test the data in the new database after transformation?2. I would like to know if there is any tool which can be used to compare the data in old vs new database (both having different structures) ? Thanks.Tue, 23 Oct 2012 07:48:11 GMTvick12http://www.sqlservercentral.com/Forums/Topic1070758-2838-1.aspxHi,I've loaded a few hundred XML files into a SQL Server 2008 DB and need to show that the data was accurately replicated.I'd like to take 10% of each table (each XML files corresponds to a table) and check them against the XML file. Or vice versa, it doesn't really matter.It is easy to select 10% of each table at random, but does anyone have an idea on how to check it against the XML files?Thanks in advance.Mon, 28 Feb 2011 12:32:10 GMTiDamixhttp://www.sqlservercentral.com/Forums/Topic1354998-2838-1.aspxHi All, Don't know what my organization expect from me but I got a new challange.My experience till now has been a SQL developer and now management ask me to lead a DB testing team.Not sure how much difficult it would be.So can anybody guide me that in what areas I need to start look into.Wed, 05 Sep 2012 22:04:43 GMTrhythmkhttp://www.sqlservercentral.com/Forums/Topic1348677-2838-1.aspxHi DBA Floks i need help,I am geeting weird error when i upgrade to sql server 2008R2 sp2-cu1,installation say error but version number get increase and everyting worksi am attaching what i see in setup bootstrap log files.please any one lemme know what is this error ,i need to upgrade my production server soon as i did DevOverall summary: Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files. Exit code (Decimal): -2058354685 Exit facility code: 1360 Exit error code: 3 Exit message: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files. Start time: 2012-08-07 20:26:31 End time: 2012-08-07 20:36:02 Requested action: PatchInstance MSSQLSERVER overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files. Exit code (Decimal): -2058354685 Exit facility code: 1360 Exit error code: 3 Exit message: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files. Start time: 2012-08-07 20:28:45 End time: 2012-08-07 20:35:57 Requested action: Patch Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120807_202630\MSSQLSERVER\Detail.txt Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.4260.0%26EvtType%3d0x60797DC7%400x24C2C4E7Machine Properties: Machine name: {server name} Machine processor count: 8 OS version: Windows Server 2008 R2 OS service pack: Service Pack 1 OS region: United States OS language: English (United States) OS architecture: x64 Process architecture: 64 Bit OS clustered: NoProduct features discovered: Product Instance Instance ID Feature Language Edition Version Clustered Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text Search 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 MSSQLSERVER MSAS10_50.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.52.4000.0 No Sql Server 2008 R2 Integration Services 1033 Enterprise Edition 10.52.4000.0 No Package properties: Description: SQL Server Database Services 2008 R2 ProductName: SQL2008 Type: RTM Version: 10 SPLevel: 2 KBArticle: KB2720425 KBArticleHyperlink: http://support.microsoft.com/?kbid=2720425 PatchType: QFE AssociatedHotfixBuild: 0 Platform: x64 PatchLevel: 10.52.4260.0 ProductVersion: 10.52.4000.0 GDRReservedRange: 10.50.4001.0:10.50.4199.0;10.50.4200.0:10.50.4250.0 PackageName: SQLServer2008-KB2720425-x64.exe Installation location: n:\a87b62242978bfa12b\x64\setup\Updated product edition: Instance Edition MSSQLSERVER ENTERPRISE User Input Settings: ACTION: Patch ALLINSTANCES: False CLUSTERPASSIVE: False CONFIGURATIONFILE: ENU: True FARMACCOUNT: <empty> FARMADMINPORT: 0 FARMPASSWORD: ***** HELP: False INDICATEPROGRESS: False INSTANCEID: <empty> INSTANCENAME: <empty> PASSPHRASE: ***** QUIET: False QUIETSIMPLE: False UIMODE: Normal X86: FalseRules with failures:Global rules:There are no scenario-specific rules.Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120807_202630\SystemConfigurationCheck_Report.htmWed, 22 Aug 2012 13:16:14 GMTdba.swapnahttp://www.sqlservercentral.com/Forums/Topic1183878-2838-1.aspxI have source side stored procedure.Using which i need to do analysis and write test cases.In the stored procedure , they are updating data after wrting the stored procedure.Do any one know how to write testcases for update statments.KomalFri, 30 Sep 2011 12:18:17 GMTkomal145http://www.sqlservercentral.com/Forums/Topic1151002-2838-1.aspxIs anyone performing load testing and if so, how are you doing it?Fri, 29 Jul 2011 08:40:50 GMTEd.Watson aka SQLGatorhttp://www.sqlservercentral.com/Forums/Topic1100571-2838-1.aspxI recently read Solomon Rutzky's article on DBFit (http://www.sqlservercentral.com/articles/Testing/64636/) and I've been working with it. Once I get past a few of the gotchas such as needing to use True\False in the DBFit code where SQL Server expects 0\1 for bit values it's a nice tool.I was wondering if there are best practices for use of the tool or even for automated database testing in general? For example, the article talks about creating objects (tables, procs, etc) on the fly so they can be rolled back. That's a great concept but I'm running into problems implementing it. For example, I comment my procs so I can remember just what the heck I was doing but double dashes won't work when creating the proc from DBFit. The simple answer is to take out comments and such in the DBFit html but then you are testing something other than what you wrote or will put into production. Also, you have to make updates in DBFit when you update your scripts, etc. Too much room for error in either screwing up a copy\paste or forgetting to copy in the change.I'm considering maintaining the database by running the scripts using SQLCMD Mode from SSMS then handing over the DBFit html to the testers. That separates the database maintenance from the testing while still being able to build the database to a known state. The maintenance scripts and testing html would be stored in the same place in source control and checked out all at once when needed.Does anyone have any words of wisdom on the subject?Thanks.DonThu, 28 Apr 2011 13:59:30 GMTDonaldWhttp://www.sqlservercentral.com/Forums/Topic1077601-2838-1.aspxHello All, I need to test the working of few SQL Server related applications on Windows 7 OS for my organization.The list of applications is given below. Can anyone please advice me on what parameters and modes should I test the applications so as to get good test plans for these applications. I have not tried anything like before so trying to seek as mush help as possible on this. :DBArtisan 8.7.1DB Change Manager XERedGate SQL Backup 6.2Erwin Data Modeler 4.1 SP3Erwin Model Navigator 4.1 SP3Rapid SQL XEDB Visualizer 7.1.4Thanks for any suggestions that you have.Mon, 14 Mar 2011 03:36:45 GMTrahulr.sharmahttp://www.sqlservercentral.com/Forums/Topic1094724-2838-1.aspxHi friends,Is there any testing tool available for the testing of SQL Stored procedures/functions? . Like the Nunit testing , NAND for .Net code I'm looking for some testing tool for SQL.Thanks in advance.Sun, 17 Apr 2011 23:33:01 GMTonly4mithunchttp://www.sqlservercentral.com/Forums/Topic1094897-2838-1.aspxI would like to know the testing approach for sql sever upgrade 2000 to 2008 . Does anybody has any idea??Mon, 18 Apr 2011 07:07:52 GMTnharanhttp://www.sqlservercentral.com/Forums/Topic1063959-2838-1.aspxguys do you know how to import data from excel 2010 to MS Sql 9.0? Should that need an SSIS or some DTS?help me please.. thanks! :DMon, 14 Feb 2011 19:25:22 GMTa.campos132http://www.sqlservercentral.com/Forums/Topic1068913-2838-1.aspxOur current setup is configured where local data servers are used to directly FTP the respective databases housed on that server to production servers. What I want to investigate is the processing impact of FTP'ing on the server while databases are running (and vice-versa) - as there may need to be a business case put forward to alter the current arrangement. While I have seen, VBS scripts to track CPU load, I want to have an understanding of all factors - CPU load, RAM and upload bandwidth? Are there any standardised rules-of-thumb on how to monitor these? Presuambly, I'll need to monitor all factors twice, once sans FTP, then a DB run while FTP'ing?Thanks.RobThu, 24 Feb 2011 07:02:20 GMTrobertprice45