Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Windows Azure Pack WAP creates database with SqlResourceProviderLogin as owner

  Hi,I'm testing a distributed deployment pattern of WAP with SQL 2014 to provide database as a servi…

  Stueyd

  1 replies

  9 years ago

  By: Stueyd

• SQL 2014 & NICs

  I just purchased a Dell PE730 which has 4 embedded NICs.  I teamed the first two NICs, and I w…

  cmp119

  4 replies

  9 years ago

  By: cmp119

• SQL Server upgrade 2012 to 2014 cleanly - how?

  My test server is running SQL Server 2012 SP3 on Windows Server 2008R2 SP1.  I’m practicing an…

  alan.spillert

  10 replies

  9 years ago

  By: alan.spillert

• track tempdb allocations using Extended events

  Hi SQL experts, How can we track queries/(which stored proc & sql stmt within proc) causing te…

  vsamantha35

  3 replies

  9 years ago

  By: Sue_H

• Is it possible to restore to a point in time by starting with current db and rolling back t logs?

  The scenario is that I have a log-shipped database and a user has dropped a table.   Rather th…

  ed_kennedy_65

  2 replies

  9 years ago

  By: ed_kennedy_65

• Add FSW to 3 Node Cluster

  Morning All, I have a 3 node cluster, with 2x nodes in data centre A and 1 node in Data Centre B. E…

  alex.sqldba

  1 replies

  9 years ago

  By: Perry Whittle

• Windows Server 2016 Standard and Disk Alignment and Offset.

  I am prepping a Windows Server 2016 box to install SQL Server 2014 Standard.  I have two RAID1…

  cmp119

  3 replies

  9 years ago

  By: Perry Whittle

• Question about Always On

  Hi,Just knowing Always On Technologies right now,If I have  a 5 Terabytes database as my Prima…

  Lou

  2 replies

  9 years ago

  By: Perry Whittle

• how many concurrent users are connected to the database from an web application

  Is there a query I can find out how many users currently from a .net application to connect to…

  sqlfriend

  4 replies

  9 years ago

  By: Grant Fritchey

• Exclusive PageIOLatch

  Hi Experts, we have a table which stores documents and have about 100,000 records currently. The ta…

  VastSQL

  10 replies

  9 years ago

  By: Gail Shaw

• Webserver on database server

  My organization is looking to purchase a centralized logging tool, so that we can more quickly loca…

  chuck.forbes

  1 replies

  9 years ago

  By: VastSQL

• Download SQL Server 2014 evaluation edition.

  All, can someone please tell me the best way to install SQL Server Evaluation edition on my laptop …

  NewBornDBA2017

  5 replies

  9 years ago

  By: jasona.work

• Different Query Plan for same query

  Hello, I am having very interesting issue. On one SQL instance therea re 2 different databases. Now…

  free_mascot

  7 replies

  9 years ago

  By: TheSQLGuru

• process_physical_memory_low is 1 in sys.dm_os_process_memory

  Hello, On our secondary node (Always On ), i'm seeing the following. Is this a concern ? I dont see…

  Robin35

  4 replies

  9 years ago

  By: Robin35

• SQL script to Select Fragmentation

  Hi, This SQL script is to select fragmentation tables > 5%, but it's not working.  Any idea…

  dEVafri

  2 replies

  9 years ago

  By: dEVafri