Administration

• Topics

  Started by

  Posts

  Last post

• Download content ie page like txt file

  Hi, I have problem, how can I download content ie page like txt file. Page is : http://www.cnb.cz/c…

  William-462471

  8 replies

  3 days, 20 hours ago

  By: JFinkster

• Trace Flag 2861

  I just reinstalled a SQL Server (Standard Edition) on a test server the other day.  I als…

  hawg

  14 replies

  1 week, 4 days ago

  By: qbrt

• List of illegal characters in database names

  can anyone provide me with a list of illegal characters in naming database names.... also what is t…

  geoff hopkins

  3 replies

  1 month, 2 weeks ago

  By: Solomon Rutzky

• Changing Data Drive Allocation Unit Size on Existing Installation

  I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup is fairly ty…

  garyb1

  1 replies

  3 months ago

  By: garyb1

• SQL Mail service not started using Outlook 2007

  Hi, I am trying to setup SQL Mail to work with Outlook 2007. I have an email account created on the…

  Steve Lund

  10 replies

  4 months, 1 week ago

  By: Rajattechno

• Problem Deleting Backup Data (sp_delete_backuphistory)

  I've been runnning log shipping for nearly a year, and on several DB's.  My msdb database is n…

  mgroovin

  15 replies

  6 months, 1 week ago

  By: gohil.rajesh

• Finding out Total Disk Space in TSQL

  anyone know any workaround in TSQL who can give this result set? Drive letter | Total Disk Space…

  Raymond Entena

  34 replies

  11 months ago

  By: tung858

• How to stop Transaction log from growing during Delete

  SQL Server 7.0 database question: To free up some disk space, we are deleting old records (not all …

  cdi_h

  7 replies

  12 months ago

  By: HildaJ

• How to analyze massive OLTP databases

  I've just started a job and I'm responsible for administrating (will define later) a few massive OL…

  Mysterio

  7 replies

  1 year ago

  By: Steve Jones - SSC Editor

• Run critical job during upgrade window - SQL Agent stopped

  Hello,  I would like to stop the SQL Server Agent on our ETL box while a 3rd party is updating the…

  Squatt Gmail

  5 replies

  1 year, 2 months ago

  By: Squatt Gmail

• How to see the Current fill factor of an index?

  Hi All, I am just wondering if you could tell me how/where to see what the current fill factor of a…

  Tejwant Kaur-333539

  6 replies

  1 year, 4 months ago

  By: wensheng_zou

• An error occurred while processing log encryption

  We periodically get this message below in the SQL Server log on SQL 2012 Enterprise edition. The da…

  lcaradon

  4 replies

  1 year, 5 months ago

  By: jeffrey yao

• Different Execution plan and performance issues in SQL 2017 compare to SQL 2012

  We have recently migrated from SQL Server 2012 Express to SQL Server 2017 Express and observed some…

  nirav.gandhi7

  3 replies

  1 year, 11 months ago

  By: Grant Fritchey

• Detecting Detached Databases

  I've many databases on the server I've inherited. Some are detached and rather than manually check …

  rflewitt

  16 replies

  2 years ago

  By: AllegedDBA

• SQL Server Agent scheduled job taking abnormally long time to run

  I am having a quite strange problem- the scheduled job in SQL Server Agent is taking abnormally lon…

  ajoy_gp

  1 replies

  2 years, 3 months ago

  By: Steve Jones - SSC Editor