Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Query to check the tables part of procedures

  Hi, Though sp_depends 'proc_name' displays all the tables which are part of the procedure but if th…

  SQL_Hunt

  1 replies

  9 years ago

  By: TheSQLGuru

• Anyway to find the total number of records inserted/deleted/updated in tables using sys.stats or sys.indexes views

  Hi, Is there anyway to find the total number of records inserted/deleted/updated in tables using sy…

  SQL_Hunt

  4 replies

  9 years ago

  By: Ed Wagner

• Can not access / login to SQL Server

  "Can not access / login to SQL Server" [Sql Server 2014 Express] Q1: Is there a way to fix this pro…

  mark4asp

  2 replies

  9 years ago

  By: Kevin3NF

• Memory Needed More

  We have server with 16 core 64GB RAM in Active\Passive Cluster,out of which 56GB is assigned to SQL…

  Rechana Rajan

  8 replies

  9 years ago

  By: Mr. Brian Gale

• Transaction Log space required by individual transaction

  Is it possible to estimate, even if only very approximately, how much transaction log space a given…

  ianharris2

  1 replies

  9 years ago

  By: John Mitchell-245523

• Corruption of the file format .mdf

  I had a problem. While working in MS SQL Server was made to emergency restart the computer. After r…

  plop4568

  4 replies

  9 years ago

  By: Gail Shaw

• SQL Server Maintenance Plan - Unable to Edit

  Hello, I have imported SQL Server Maintenance Plan (which takes Full & T-log backup o…

  Sreejith!

  5 replies

  9 years ago

  By: Sreejith!

• Index Usage Details.

  Hello Experts, To monitor the real index usage I mostly use the below std query. Do you suggest run…

  SQL_Hunt

  4 replies

  9 years ago

  By: Gail Shaw

• SQL sp_send_dbmail - SMS formatting problems

  Hi AllWhen sending an SMS text message from SQL Server using the below. Exec msdb..sp_send_dbm…

  SQLSACT

  5 replies

  9 years ago

  By: Ed Wagner

• SQL Server backup error. Operating system error 3(The system cannot find the path specified

  I have an Azure drive mapped to SQL Server 2014. I have verified that SQL Server is using a service…

  equipe9

  3 replies

  9 years ago

  By: Mr. Brian Gale

• Splitting TempDB

  Hi, I noticed yesterday that I have the following setup for one of my production virtual database s…

  Mike Scalise

  11 replies

  9 years ago

  By: TheSQLGuru

• Procedure plan changed suddenly

  Hello, Is there anyway to find how suddenly a procedure plan is changed. I understand that there ca…

  SQL_Hunt

  9 replies

  9 years ago

  By: Grant Fritchey

• XML input variable vs table variables

  Hi, Is there any way the performance can be improved if a XML input variable is passed whch cntains…

  SQL_Hunt

  3 replies

  9 years ago

  By: Eirikur Eiriksson

• Transaction replication is looks not working.

  Hi, I Just joined to company and give me to bunch of SQL Servers to do admin.I noticed there is a P…

  ashwan

  8 replies

  9 years ago

  By: MG-148046

• Extract sp_execute value to a variable to compare

  Hello, I want to take the sp_executesql results to a variable to further compare the results. Pleas…

  SQL_Hunt

  7 replies

  9 years ago

  By: Sue_H