Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Preparation a Database for Developer team

  Hi Professionals We have a schadule task that I have to 1- Backtup of main database 2-Update Critic…

  MotivateMan1394

  8 replies

  9 years, 10 months ago

  By: Lynn Pettis

• Table Using up Much More Space When Transferring to New FileGroup

  I have a database on SQL Server 2014 SP1 CU5 with .mdf that is about 1.45 TB. I found one table th…

  lmarkum

  12 replies

  9 years, 10 months ago

  By: Jeff Moden

• Non-Clustered Index - Fill factor

  When we create non-clustered indexes, is it a best practice to set fill factor other than default v…

  SQL!$@w$0ME

  4 replies

  9 years, 10 months ago

  By: SQL!$@w$0ME

• Another Deadlock

  Hi Experts, Below is the xml of deadlock i observed today. Analysing the deadlock give me some idea…

  VastSQL

  2 replies

  9 years, 10 months ago

  By: VastSQL

• Restore Issue

  I am restoring few databases from 2008 backups to 2014. I used litespeed and SQL server native rest…

  kirankritapure

  4 replies

  9 years, 10 months ago

  By: Grant Fritchey

• Restore from 2008 to 2014 messing up file names

  I am restoring few databases from 2008 backups to 2014. I used litespeed and SQL server native rest…

  niks.06241

  1 replies

  9 years, 10 months ago

  By: spaghettidba

• Moving available space from one drive to another on same server

  HI I want to Move an available space of about 500GB from one drive to another on same server . M…

  gxdatareal

  5 replies

  9 years, 10 months ago

  By: Jon.Morisi

• Post-Installation: SQL Failover Cluster Instance preventing nodes from booting after restart

  First, my problem. I am attempting to setup a Two Node SQL Server 2014 Cluster Instance, I have su…

  Dougieson

  5 replies

  9 years, 10 months ago

  By: will.hall

• Connect to SQL instance on Mac

  Hi - Anyone connecting to a SQL instance on a MAC? We have developers running Yosemite and are requ…

  cheshirefox

  3 replies

  9 years, 10 months ago

  By: Luis Cazares

• Control SQL Logins Groups for Developers

  We have about 30 devs that all work on different projects and SQL databases. Dev A and B needs acce…

  AlianaRivera887

  4 replies

  9 years, 10 months ago

  By: Grant Fritchey

• Application/User db account - SQL Azure

  What is the best way to handle application accounts and user accounts in Azure SQL. SQL Server auth…

  SQL!$@w$0ME

  6 replies

  9 years, 10 months ago

  By: SQL!$@w$0ME

• SQL Agent when the clocks go forward

  Clocks are due to go forward soon, how does SQL agent deal with this?? We have some data loads sche…

  SQLAssAS

  3 replies

  9 years, 10 months ago

  By: Grant Fritchey

• indexing foreign key

  Is it a good practice to index foreign keys in all tables. I'm working on a design phase of a db. S…

  SQL!$@w$0ME

  3 replies

  9 years, 10 months ago

  By: SQL!$@w$0ME

• Does Management Studio uses SQL native client library to connect to SQL instance ?

  Hi all, I am using SQL server 2014. I have a ServerA (192.168.1.174) running SQL default instance. …

  szejiekoh

  4 replies

  9 years, 10 months ago

  By: szejiekoh

• SQL Server CPU

  Hi Experts, In our test environment we have 2 instances of SQL Server running on 8 core machine. C…

  VastSQL

  2 replies

  9 years, 10 months ago

  By: VastSQL