Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: Eirikur Eiriksson

• CPU utilization 100%

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

  krishna83

  4 replies

  8 years, 10 months ago

  By: NorthernSoul

• 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: Perry Whittle