Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• 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, 12 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years ago

  By: Gail Shaw

• DBCC CHECKDB lock the Databases

  How to check this task, Is this coming by default sql server ? and how to stop this task

  chonlatis.je

  3 replies

  9 years ago

  By: Gail Shaw

• restore point

  Is there something equivalent in SQL server like create guaranteed restore point in oracle? I know …

  sqlfriend

  12 replies

  9 years ago

  By: jasona.work

• need script to pull out all numeric numbers more that 6 digits long within a string

  IF Object_id('tempdb..#temp') IS NOT NULL DROP TABLE #temp select 1 id, 'hello …

  Snargables

  3 replies

  9 years ago

  By: Snargables

• Distribution Cleanup

  Distribution DB is growing Day by Day and old transactions are not getting deleted.Removed 0 replic…

  DBA_007

  1 replies

  9 years ago

  By: Kevin3NF

• Track User level metadata changes in SQL Server

  Scenario is one of db user(employee) resigns his job, i need to track the metadata changes done by …

  GA_SQL

  4 replies

  9 years ago

  By: Gail Shaw

• AlwaysOn Missing Redo Thread

  Morning Guys, I have one particular database that isn't large or overly active but has stopped redo…

  alex.sqldba

  6 replies

  9 years ago

  By: peterbarronwell

• Tempdb Spills

  Hello all  I have attached the query plan anonymised not sure what i can do to help the perfom…

  zouzou

  5 replies

  9 years ago

  By: Jeff Moden