Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• sp_UpdateStats stored procedure, UPDATE STATISTICS SQL Statement, and Auto Update Statistics

  I have been doing some research on sp_UpdateStats stored procedure, UPDATE STATISTICS SQL Statement…

  HookSQLDBA7

  8 replies

  11 years ago

  By: Anonymous

• Managing Hight Qty of SQL Servers By Client

  Hi Guys, I'm really after your opinion on managing big estates that span multiple clients. We're ha…

  alex.sqldba

  2 replies

  11 years ago

  By: alex.sqldba

• SQL Server DBA 101 Presentations

  Hi all, Preparing to do an intro to the life of a SQL Server DBA for a very junior level audience. …

  Adam Bean

  3 replies

  11 years ago

  By: Jeff Moden

• Peer-to-peer transactional replication and Transactional replication with updating subscriptions

  Please help me. I want to know the difference between Peer-to-peer transactional replication and T…

  rajeshjaiswalraj

  1 replies

  11 years ago

  By: spaghettidba

• Recover database value

  Hello sir, good afternoon i need your help regarding SQL server, by-mistaken i updated values of a …

  toxicdeep

  1 replies

  11 years ago

  By: spaghettidba

• Availability Groups Architecture Opinions

  We would like to use AG's for storage redundancy since we have two new flash array's in each of our…

  JeepHound

  3 replies

  11 years ago

  By: Perry Whittle

• MS SQL server master data service IIS configration

  to do master data service, i need configure IIS, however it only prompts error message. such as HTT…

  nightowl23

  1 replies

  11 years ago

  By: Phil Parkin

• Best option for a Reporting Server

  What is the best option for a Reporting Server? Is Always on Availability Groups the way to go? The…

  Welsh Corgi

  1 replies

  11 years ago

  By: cunningham

• Nightly Backup and Restore

  We're setting up an 'Analysis' server area and am considering creating a 'copy' of a transactional …

  FooCorwin

  10 replies

  11 years ago

  By: BLOB EATER

• What is lock page memory

  What is lock page memory. How it will work and why it will increase the performance. Then what is t…

  rajeshjaiswalraj

  1 replies

  11 years ago

  By: BLOB EATER

• Backup Failed in SQL 2014

  I tried to take Database full backup in SQL 2014 RTM (12.0.2000) but backup is failed with below er…

  sri2015

  24 replies

  11 years ago

  By: Diane Rayzer

• Attach AdventureWorks2012 with SQL Server Authentication

  Fresh install of SQL Server 2012 Express Advanced edition. I downloaded AdventureWorks2012 database…

  mili.nikolic

  13 replies

  11 years ago

  By: Justin Manning SA

• SSMS will only run as the administrator

  After installing SSMS on some computers - the only way we can get SSMS to run correctly is to run i…

  smrobin

  3 replies

  11 years ago

  By: Justin Manning SA

• Enforcing Policy Management

  Is it possible to enforce Policy Management polices rather than having to evaluate first. I would l…

  MarvinTheAndriod

  1 replies

  11 years ago

  By: Justin Manning SA

• It's emergency situation. Select from locked rows

  Hi Some records in a table are locked. How to find and unlocked them? Thank you

  MotivateMan1394

  6 replies

  11 years ago

  By: Jeff Moden