Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Exclusive PageIOLatch

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

  VastSQL

  10 replies

  8 years, 8 months 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

  8 years, 8 months 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

  8 years, 8 months 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

  8 years, 8 months 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

  8 years, 8 months 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

  8 years, 8 months ago

  By: dEVafri

• backup after a restore.

  I am using SQL server native tool to do the full, differential, transaction backup. A question…

  sqlfriend

  12 replies

  8 years, 8 months ago

  By: sqlfriend

• Configuration.ini File via script

  Hi All, I'm able to run configuration.ini file via Dos cmd shell script I have a question…

  Davekahn

  1 replies

  8 years, 8 months ago

  By: free_mascot

• Ability to CREATE JOBS run by a service account WITHOUT being SYSADMIN

  Hi SSC,We have a major PITA happening. Our company leadership in their infinite wisdom has det…

  shelleybobelly

  5 replies

  8 years, 8 months ago

  By: shelleybobelly

• Killing non-clustered index creation

  Hi All, I just ran a CREATE NON-CLUSTERED INDEX statement against a 10 TB table. It is running for …

  karthik.catchme

  2 replies

  8 years, 8 months ago

  By: VastSQL

• tempdb: filegroup is full while space is available both in filegroup & transaction log

  SqlServer 2014 sp2cu2: having troubles with tempdb (350Gb full size: 8x25Gb primary group + 150 Gb …

  admin 31599

  9 replies

  8 years, 8 months ago

  By: admin 31599

• Question about DBMail

  I just asked my system admin to provide me with the SMTP server details so I can use that info to c…

  NewBornDBA2017

  3 replies

  8 years, 8 months ago

  By: Lowell

• query time out from .net code

  When running query from .net code, sometimes we got below message, it is not happened all the time,…

  sqlfriend

  10 replies

  8 years, 8 months ago

  By: Ed Wagner

• Access on the DB.

  We have an external user (who works for a different company) who needs access on our prod server. I…

  NewBornDBA2017

  7 replies

  8 years, 8 months ago

  By: Ed Wagner

• Availability Groups in 5 Minutes

  Dear colleagues,I have configured this lab:https://social.technet.microsoft.com/wiki/contents/artic…

  Lou

  1 replies

  8 years, 8 months ago

  By: Henrico Bekker