Thursday, August 8, 2013

[SQL 2012] Speccing new hardware

[SQL 2012] Speccing new hardware

Speccing new hardware

Posted: 07 Aug 2013 08:05 PM PDT

Hi allAre there any good articles out there to spec out a new SQL server machine for an existing application? Including things like how to judge how much CPU and memory the SQL server actually requires?Thanks

deleting duplicate

Posted: 07 Aug 2013 11:40 PM PDT

Hi all,can anyone please tell me why its not workingtable duplicate col1 col2 1 abc 2 abc 1 abc 1 bcdresult(in oracle) col1 col2 1 abc 2 abc 1 bcd result(in sql server) col1 col2 2 abc 1 bcd below query is deleting duplicate records in oracle .but in sql server instead its deleting both the recordsoracle:DELETE FROM duplicate d1 WHERE 1<(select count(1) from duplicate d2 WHERE d1.col1=d2.col1 and 1.col2=d2.col2)sqlserver:DELETE d1 FROM duplicate d1 WHERE 1<(select count(1) FROM duplicate d2 WHERE d1.col1=d2.col1 and d1.col2=d2.col2)

Exception has been thrown by the target of an invocation error while executing a table valued function

Posted: 07 Aug 2013 11:04 PM PDT

Friends,We are getting the error mentioned below whenever we are executing a function in the DB. Failed to create AppDomain "CAC_HL7_1.dbo[runtime].28871". Exception has been thrown by the target of an invocation.The same function is present in another SQL Server Instance and it is getting executed without any issues. Please help me in identifying what exactly the issue is and the fix for the same.

about exam 70-457 books

Posted: 07 Aug 2013 10:59 AM PDT

I plan to take 70-457 soon and search books about it.I download "Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012_PDF.pdf" from microsoft website. There are 2 parts in this book.Are these part1 for exam 70-457 and part2 for 70-458?I just read part1, but I saw somebody said there is no reference book for these exams, so I want to make sure.Thanks a lot.

Upgrading from SQL Server 2005 to 2012

Posted: 07 Aug 2013 07:08 PM PDT

HI We are planning to upgrade our sql servers 2005 to 2012.its not just an upgrade, we are installing a fresh copy of windows and then install 2012.Backup to take:DB backups, logins, jobs, maintenance plans.so my question is:is there anything else I need to take backup of other than above?what is the process/procedure to follow to take complete backup of Server settings and configurations ?

Just Beginning ...

Posted: 07 Aug 2013 11:48 AM PDT

I have done a lot w/ Excel Databases, but needed to expand to more power. I have installed SQL Server 2012, but I don't have a clue how to start this thing. No Icon was placed on my desktop. The Sql Server 2012 folders created don't make much sense to me. I only have a book that tells me to choose Management Studio from the main menu. Know idea how to even get to a main menu. Can anyone help me get started:hehe:thxf

Database in Availability Group Issue

Posted: 07 Aug 2013 04:46 AM PDT

I have a database that currently believes its in an Availability Group that it is not in. When I check the sys.dm_hadr_database_replica_states view on the primary replica I see 2 rows one for a primary replica and one for a secondary replica. When I run the same query on the secondary replica I don't see any records I also do not have that database on the secondary replica. Back on the primary replica I attempt to remove it from the AG and get the following errorDatabase 'X' cannot be removed from availability group 'AG'. The database is not joined to the specified availability group. Verify that the database name and the availability group name are correct, then retry the operation.Then I attempt to add it even though it says its there already and I get the following errorDatabase 'X' cannot be added to availability group 'AG'. The database is already joined to the specified availability group. Verify that the database name is correct and that the database is not joined to an availability group, then retry the operation.Because this database thinks its in an AG I can not delete it or take it offline.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog