SQL Server 15 – Administration

• Topics

  Started by

  Posts

  Last post

• Full, and Simple Recovery mode and I/O usage

  Hello room, I have 25 production databases that running on Full recovery mode.Someone changed from …

  Ed7

  2 replies

  3 weeks, 5 days ago

  By: Chris Harshman

• Login error – The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

  Hi All, I am getting below error while trying to connect SQL from remote server. Local login is wor…

  aprathour.89

  10 replies

  2 months ago

  By: Johnson Welch

• SQL Replication trouble

  Hi, I tried to add new article to already existing and working publication and replication. I crea…

  rslavisa

  1 replies

  3 months, 3 weeks ago

  By: Lowell

• Performance concernce

  Just ran through a handful of test harnesses, not impressed, vNext is more like vLast😎 Ve…

  Eirikur Eiriksson

  4 replies

  6 months, 2 weeks ago

  By: Eirikur Eiriksson

• Enable Logging of both failed and successful logins on Linux

  Anyone seen how you do this? On a Windows Environment you can just do this via the Server Propertie…

  Thom A

  11 replies

  8 months ago

  By: Steve Jones – SSC Editor

• Open .PRC with connection

  Using V17.3 and 2008R2 When I double-click on an .sql file, SSMS v17 launches with a new connection…

  schleep

  5 replies

  1 year, 5 months ago

  By: schleep

• Kerberos authentication

  Hi,I have installed SQL Server 2012 SP2 on Windows Server 2012. TCP/IP and SharedMemory protocols a…

  anand.mind

  1 replies

  1 year, 6 months ago

  By: Robert Davis

• Query to find out the user who changed the table Name

  Dear All,Kindly guide me to find out  the user who had changed the name of table of a database…

  adilahmed1989

  3 replies

  1 year, 6 months ago

  By: adilahmed1989

• SharePoint permissions for DBA

  Does anyone have any guidelines or best practices regarding SharePoint admins access level to the S…

  Ryan D.

  3 replies

  1 year, 6 months ago

  By: Sue_H

• How does a integer/any data record store in SQL Server page

  Hello Experts, I have seen the 8KB (8192 = 96 Header + 36 Row Offset + 8060 Free space) page archit…

  info.sqldbamail

  5 replies

  1 year, 7 months ago

  By: Arsh

• No Data in a table when database is restored

  Got a bit of an unusual one that’s got me scratching my head. I’m covering a colleague …

  Sydknee

  9 replies

  1 year, 7 months ago

  By: Arsh

• Shink file VS Resize

  I have a database of about 325GB with free space ~120GB and we’re having drive alerts go off …

  Michael_O

  2 replies

  1 year, 7 months ago

  By: Chris Harshman

• Create a database from backup when the backup transaction log is damage.

  Good day everyone. I would like to know if it possible to restore a dump file to create a database …

  Charles Bilodeau-369032

  14 replies

  1 year, 7 months ago

  By: Charles Bilodeau-369032

• FileTable Share Access

  Hi Experts, How can I access the FileTable directory from another server which is in a different su…

  VastSQL

  1 replies

  1 year, 8 months ago

  By: Sue_H

• When to use a clustered and/or non-clustered index

  Hi, I have been looking all over the net and in books to findwhen to use a clustered and/or non-clu…

  itmasterw 60042

  4 replies

  1 year, 8 months ago

  By: Luis Cazares