SQL Server Service Engine fails to start after applying CU4 for SQL Server 2008 SP1
After performing an update on SQL Server, SQL Server Engine and SQL Agent stop responding.
2014-08-26
3,047 reads
HJE
Upgrading the GIS application and database.
In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.
2013-08-20
3,512 reads
If you're confident about a change in your DB, triple check
Even planning allows for failure, sometimes you can't see everything else where you're standing.
2013-05-01
155 reads
GetDateInString
This function will return a value of date if found within a string, the date format in the string will vary. If no date is found a null value is returned
2013-01-17 (first published: 2012-12-18)
1,260 reads
Blogs
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Forums
What Are the Best Washbasin Faucets for Modern Bathrooms?
In order to create a unified and useful design, selecting the finest washbasin faucets...
How to speed up this query?
Hi everyone I have a query that is taking a real long time. It...
The New Log File
Comments posted to this topic are about the item The New Log File
Question of the Day
The New Log File
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