This script will provide a list of indexes that are not used in a database. Indexes are overhead and any indexes not being used but are being updated cause additional load on a database. This looks at the following items: User seeks, scans and lookups. If all three of these are zero and the User […]
2020-04-21 (first published: 2020-04-13)
3,982 reads
This script on missing indexes that SQL had found. SQL will track queries and provide suggestions on indexes it feels will provide improvements. You should not take this information and create all the indexes. Performance tuning can be an art and takes practice. This information should be reviewed and as a DBA implemented a little […]
2020-04-20 (first published: 2020-04-13)
9,746 reads
Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.
2019-08-20 (first published: 2019-07-26)
1,458 reads
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Comments posted to this topic are about the item The New Log File
Comments posted to this topic are about the item Getting Started with the Data...
Comments posted to this topic are about the item The AI/Human Spectrum
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers