Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• CPU utilization 100%

  We find  CPU utilization reached to 100% last night. Client could not able to access database …

  krishna83

  5 replies

  8 years, 5 months ago

  By: eneskutuk

• drop article and cleanup replication

  hi guys, i am planning to drop an article on my transactional publication.  I know to drop the…

  DBA-640728

  2 replies

  8 years, 5 months ago

  By: DBA-640728

• Read Access to Database Tables - How do you do it in MS-SQL ?

  Hi all,I need to control access to the developers&business users whom (by business rules) are a…

  szejiekoh

  11 replies

  8 years, 5 months ago

  By: Eric M Russell

• AlwaysOn Backups on Secondaries

  Hi AllIn an AlwaysOn environment, I understand that FULL backups can be offloaded onto my secondary…

  SQLSACT

  6 replies

  8 years, 5 months ago

  By: SQLSACT

• Change Service account password for multiple servers using T-SQL query or WMI Script or PowerShell script or SSIS script

  Can anyone help to understand if there is any T-SQL query or WMI Script or PowerShell script or SSI…

  maroju1

  3 replies

  8 years, 5 months ago

  By: goher2000

• Drive Letter Issue

  Hi, The database data(MDF) and log(LDF) files are mapped to L:\ drive and the database is online/ac…

  narayanamoorthy.a

  3 replies

  8 years, 5 months ago

  By: Perry Whittle

• Should I Re-design table?

  This table has high transactions with select, insert, update, delete and It index got fragmentation…

  chonlatis.je

  29 replies

  8 years, 5 months ago

  By: BrainDonor

• Service Broker Woes

  So I have a basic service broker set up for data auditing , two separate initiators set up to send …

  simon_s

  1 replies

  8 years, 5 months ago

  By: Sue_H

• When does Powershell become indispensible?

  I have been reading articles over the last 6 months that have come my way which discuss the crossro…

  chuck.forbes

  4 replies

  8 years, 5 months ago

  By: Grant Fritchey

• Transaction replication broke for reason unknown on the 30/7/2017

  Hello,We have run into an issue with our transactional replication since the weekend.Nothing as far…

  Rin Sitah

  2 replies

  8 years, 5 months ago

  By: Sue_H

• SQL Server 2014 AlwaysOn failover

  Hi everyone, I have 3 SQL servers 2014 Enterprise (Windows Servers 2012 R2) in a cluster AlwaysOn o…

  shawnshine

  5 replies

  8 years, 5 months ago

  By: shawnshine

• Slow DataBase and Hyper-V

  Hi, In the company I work for, we have a slowness problem in the SQL Server 2014 database. Today ca…

  augustos

  6 replies

  8 years, 5 months ago

  By: TheSQLGuru

• Consistency Errors on System Tables

  Hi! We have a database which is connected to a third-party software.Recently we have installed a ne…

  joliveira 19841

  26 replies

  8 years, 5 months ago

  By: Gail Shaw

• Deny Permissions On Object(s) Except For Certain Users

  I've been tasked with making sure all users, except for a couple, have at most select permission on…

  RonMexico

  7 replies

  8 years, 6 months ago

  By: Sean Lange

• need list of logins at the server level

  My issue is we removed several users at the server level and left them at the database level. I'm t…

  Snargables

  13 replies

  8 years, 6 months ago

  By: Gail Shaw