Active Forums

Search this forum:
Search
You are not authorized to create a new topic
Topics
 Replies
 Views
 Last Post
0 Replies and 1 Views MSSQL Query TimeOut research  1  0 Started by  Paul Fijma to troubleshoot query timeout issues start with this article https://blogs.msdn.microsoft.com/docast/2018/10/12/troubleshooting-query-timeouts-in-sql-server/ links to the tools: https://github.com/Microsoft/DiagManager https://github.com/Microsoft/SqlNexus
0 1
27 Feb 2020 08:47 AM
1 Replies and 5 Views Effective Database Maintenance  5  1 Started by  Paul Fijma A good article about tips for Effective Database Maintenance by Paul S. Randal: http://docs.microsoft.com/en-us/previous-versions/technet-magazine/cc671165(v=msdn.10) for me effective the order is to do the following: - full backup once every night, with verify - log backups every 5 minutes (to the cloud) with verify - at the end of the day i do max. 2 hour defrag on databases, during the most silent time. ( 2 hour is arbitrary determined, after a check on times needed average in a f...
1 5
by  Paul FijmaJump to last post
24 Feb 2020 01:55 PM
1 Replies and 44 Views Backup How-it-works  44  1 Started by  Paul Fijma Article about backup and how it.. actually works etc.: http://www.sqlshack.com/understanding-sql-server-backup-types/
1 44
by  Paul FijmaJump to last post
24 Feb 2020 01:42 PM
1 Replies and 33 Views Find Missing Index  33  1 Started by  Paul Fijma SQL Scripts: How To Find Missing Indexes (Posted on June 5, 2018 by Eric Cobb) One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it is used, or if it is even being used at all. But SQL Server doesn’t just monitor the indexes that you currently have, it even keeps up with statistics for indexes that it wishes you had! What Are Missing Indexes When SQL Server is processing a query, it will s...
1 33
by  Paul FijmaJump to last post
21 Jan 2020 10:11 AM
0 Replies and 31 Views Date Time  31  0 Started by  Paul Fijma some information: http://tableplus.com/blog/2018/09/ms-sql-server-how-to-get-date-only-from-datetime-value.html and http://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/
0 31
17 Jan 2020 11:18 AM
You are not authorized to create a new topic