Database Upgrade

Technical Article

RE: Transaction logs keep filling up

  • Reply

you could also increase the growth factor for the transaction log, in the database properties, and change it to unrestricted growth. If it manages to grow large enough without causing a problem to the normal deletes/dataloads you do, then keep the log at that size and reduce the growth factor back to a smaller percentage again (eg 10%). […]


Technical Article

Looking for a Solution to my problem

  • Topic

Hi! I need solution for my problem.the scenario is that We have an DB created in Access, it contains some data. Now we have updted our DB to SQL and certainly with changed structure, but we want to port data from the access db to sql db even though its structure is changed.So anyone who can […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Copy backup to not destroy backupchain

By Landola

Hi, A bit unsure about how to make a copy only backup and the...

Can someone explain where non - clustered index is stored?

By yourjobismine

I am learning non-clustered and clustered indexing. When reading this article,involve%20any%20extra%20lookup%20step. came across this...

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers