Sep 3, 2013 · I have a database mirroring server with Sql server 2012 service pack 1 standard edn on windows server 2012 standard edition Processor Intel Xeon I350 and 8 GB of Ram on both principle …

Mar 25, 2015 · I tried Group By from Select Top 1 Records, As below the script wasn't work.

Jan 14, 2013 · My question there for is can you see security issues regarding the way i am using openrowset with sql server authentication

Jun 29, 2013 · There are some tables which would like to be deleted and can I know whether I can free up some space (shrinking the database) after I delete the tables ? .

Oct 4, 2013 · How do I determine the cardinality and optionality of a table relationship? Please see diagram and rule for more information.

Feb 12, 2019 · As following to my local security policy, I have to establish the limit appropriate to the type of user account accessing the SQL Server instance on SQL Server 2014 Enterprise.

Apr 29, 2014 · I am running an ssis job from sql server agent. The job keeps on failing with the following error- The transaction log for database 'xxxxxx' is full due to 'ACTIVE_TRANSACTION'. ". When I …

Nov 30, 2017 · Temporal is in the ANSI SQL standard, so I doubt that MS can/should divert from how ANSI specifies that things should work. Tibor Karaszi, SQL Server MVP (Web Blog)

Aug 5, 2015 · Question 0 Sign in to vote Hi Team, At the moment I am making use of below query for rebuilding the index, ALTER INDEX ALL ON TABLE_NAME REBUILD (We are performing the same …

Nov 26, 2012 · When you install SQL Server you can install it as a default instance or named instance. Only one default instance and a maximum of 50 named instance per server. in your case try install …