Monday, July 15, 2013

[SQL 2012] Always On in Std Edition. whats actually available?

[SQL 2012] Always On in Std Edition. whats actually available?


Always On in Std Edition. whats actually available?

Posted: 15 Jul 2013 12:55 AM PDT

In the "Features Support" documentation on technet it says that Always On Failover Clustering is available on SQL server Standard Edition for up to 2 nodes.Im not sure what this means though. does this mean i can have secondaries for offloading reporting etc if i use standard edition?[url=http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx#High_availability][/url]

Sql Server - Generate Scripts

Posted: 14 Jul 2013 05:26 PM PDT

Hi Team,i want to generate Table with Data Scripts with Tasks > Generate Scritps, but i dont to all the records, i want only few records scripts based on condition..how to generate, Please suggest...

Tables creation

Posted: 14 Jul 2013 11:49 PM PDT

Did Sql doctor creates any new tables in our Data base?

Restore temp database

Posted: 14 Jul 2013 05:23 PM PDT

Hi, How can i restore the database into temp database in SQL server 2008 R2Advance Thanks.......,

Update Script

Posted: 14 Jul 2013 05:14 PM PDT

Hi Team,I've a Table with 500+ records, in that one column name is 'Sec_Name' having some values as null (approx 150 records), with the same table name i've another table in another database, in that i want to update the null value records,i want a update script for all 150 records. how to get the udpate script for all 150 records.--am trying to generate scripts from Tasks > generate scripts but there am gettting for all the records.i want condition.Please help....

Sum and Data matching

Posted: 14 Jul 2013 11:22 AM PDT

Sorry guys.. new to SQL so may be this question seems primitive to you.I have two tables that have one common field. I need to sum one field of one table (group by common field) and then compare it with column of another table. The final result should be the listing of the common field that does not get match (sum of one table group by column field vs column of another table)Need suggestion and advice.

No comments:

Post a Comment

Search This Blog