Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• any way get get buffer cache hit ratio without usage dm_os_performance_counters

  Hi,we have sp that use dm_os_performance_counters  and collect and store " buffer cache hit ra…

  ebooklub

  2 replies

  8 years, 5 months ago

  By: Sue_H

• Backup size and DB size are different.

  I have a DB which is supposed to be close to 250 GB in Size. I have couple of scripts which are run…

  NewBornDBA2017

  6 replies

  8 years, 5 months ago

  By: Chris Harshman

• Views exist in memory or on disk?

  When a user creates a view from multiple tables, the data from it gets stored somewhere. Is it in m…

  NewBornDBA2017

  2 replies

  8 years, 5 months ago

  By: Gail Shaw

• Replication subscriber log continuously growing

  Hello SSC, I have a replication process running which is having problems with the Subscriber's log…

  icester

  6 replies

  8 years, 5 months ago

  By: Sue_H

• Change all server name synonyms

  Hello I work on SQL server migration. My DB are now on a server "CONTOSO" and in my DB i have more …

  Fellerson

  2 replies

  8 years, 5 months ago

  By: Fellerson

• Issues with applying T - log backups for restore on a scheduled basis.

  Hi All, I have an issue and hoping some-one here can have a script available for this. we have a da…

  BoobyB

  1 replies

  8 years, 5 months ago

  By: goher2000

• Give access to users for certain data in the table or move that set of data to new table

  Hi All, I have a question for the senior members to get a solution forthe below issue. Issue:  …

  BoobyB

  4 replies

  8 years, 5 months ago

  By: BoobyB

• SQL 2014 FAIL_PAGE_ALLOCATION 129

  Hi, I migrated by DBs from SQL2008R2 to SQL2014 on a same server model: Phyiscal with 128 GB RAM.Si…

  ran.ovadia

  8 replies

  8 years, 5 months ago

  By: Jeffrey Williams

• moving partitioned table between filegroups in SQL Server 2014

  We have multiple tables which is partitioned by business date column (365 partitions for a year),an…

  prem.m38

  1 replies

  8 years, 5 months ago

  By: BoobyB

• Login only has access to master and tempdb databases

  I'm using SQL Server 2014 Standard and starting to wonder if I have a bug. I've created some logins…

  mmcardle

  2 replies

  8 years, 5 months ago

  By: mmcardle

• Copy Only Full Backups

  Hi, I know that the copy only option on a Full backup doesn't update the LSN of the database, and t…

  Steve Smith-163358

  4 replies

  8 years, 5 months ago

  By: Steve Smith-163358

• Can't open RSReportServer config file - Invalid license data. Reinstall is required

  Server : SQL server 2014 Standard edition I wanted to open RSReportServer config file as I need to…

  WhiteLotus

  3 replies

  8 years, 5 months ago

  By: Thom A

• Receving a Primary Key Violation in my Target Table that has the exact same layout as the Source Table and the same primary key

  I've got a very weird issue going on with a SSIS Truncate and Load Package. The database that I'm r…

  ericwenger1

  2 replies

  8 years, 5 months ago

  By: ericwenger1

• An article about Dba

  Today I had an email sent from someone from internet, article named disappearing DBA, I read half o…

  sqlfriend

  3 replies

  8 years, 5 months ago

  By: sqlfriend

• Memory on ETL servers

  I have a 2014 Server 4 CPU and 256 gig of memory.  Used for ETL for our data warehouse.  …

  tcronin 95651

  1 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson