Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Where clause on a bit column

  Hi Experts,I want results based on a where clause , all columns in the where clause is bit.I want t…

  tmmutsetse

  4 replies

  7 years ago

  By: Phil Parkin

• TempDB previous usage

  Hi AllTo track down what is causing TempDB to fill up now is something that is done often so that's…

  Sicilian-Najdorf

  3 replies

  7 years ago

  By: Jeff Moden

• MSSQL_XP waits high

  MSSQL_XP is the highest wait type on my server. Didn't find much info when googled to lower this wa…

  Tac11

  2 replies

  7 years ago

  By: Tac11

• Getting a rough average daily data transferred stat, will this work?

  One of my co-workers came to me with a need.  He was being asked (by a customer) to determine …

  jasona.work

  3 replies

  7 years ago

  By: goher2000

• LSN is broken and I'm unsure why..

  To start with.. I'm relatively new to being a DBA. I have a backup plan that is the following in a …

  oogibah

  9 replies

  7 years ago

  By: oogibah

• Are there any video presentations for SQL FineBuild?

  I've been looking at it recently. It has a lot of options, and lots (and lots) of documentation, an…

  codykonior

  1 replies

  7 years ago

  By: rstone

• Tempdb version store growth

  I am using a monitoring tool and I am seeing this oftenSeverity    Alarm &…

  keanyukas

  2 replies

  7 years ago

  By: keanyukas

• DBCC CHECKDB

  I understand that in order to have DBCC CHECKDB use parallel threads you need to be on Enterprise E…

  SteveOC

  1 replies

  7 years ago

  By: SteveOC

• Replication - publication / subscription

  Hi all.I've never done replication or worked with it, so I've started researching and ran into some…

  hb21l6

  1 replies

  7 years ago

  By: hb21l6

• MSDB Size

  Hello. Reading about MSDB growth and understand that this issue usually gets put down totables with…

  SteveOC

  1 replies

  7 years ago

  By: HappyGeek

• Transaction Logs and VLFs etc

  Hello Bit of a silly question I think, but for my peace of mind...............… We have 2 servers -…

  SteveOC

  1 replies

  7 years ago

  By: Jeffrey Williams

• Deleted tables - release space

  HI, We deleted a bunch of tables (moved them to cheaper storage SAN) and now when I run 'DBCC SHRIN…

  krypto69

  9 replies

  7 years ago

  By: krypto69

• Job Failing : Process Exit Code 1. The step failed.

  Hi All, Im executing SSIS package by using Batchfile and scheduled batch using SQL job agent. …

  squvi.87

  6 replies

  7 years ago

  By: Joe Torre

• one sec vs 40 minutes

  I copied database from prod (sql 2008) to test (sql 2014) , changed compatibility mode to 120, re-i…

  goher2000

  9 replies

  7 years ago

  By: Phil Parkin

• Dettach and attach as a restore mechanism

  Hi I'm  looking at some backup solutions/tools for SQL Server.I can see the tool takes regula…

  terry999

  6 replies

  7 years ago

  By: terry999