2016-10-21 (first published: 2015-05-12)
2,388 reads
2016-10-21 (first published: 2015-05-12)
2,388 reads
2016-05-25 (first published: 2014-03-06)
2,215 reads
This can be used for data warehouses as well as truncating table with foreign key constraints.
2016-04-08 (first published: 2014-07-07)
2,611 reads
This script shows the total time between two dates.
2016-03-29 (first published: 2014-07-09)
3,071 reads
For successful run, Your SQL Server service account should have permission to old location & new location
2015-05-27 (first published: 2015-05-10)
1,029 reads
Extract only integers or characters from alphanumeric :
2014-10-07 (first published: 2014-09-05)
1,499 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