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%). […]
2004-08-19
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 […]
2004-08-19
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Hi, A bit unsure about how to make a copy only backup and the...
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
I'm using this query to check if I have any unused indexes.. One of...
Ask SSC