Undocumented use of the Columns_Updated() function
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
605 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Breaking Up is Easy to Do
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
595 reads
Who said that breaking up is hard to do?
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
602 reads
SQL Server Error Logs
The active SQL Server error log is one of the first places people look when there is a problem. For...
2007-06-29
1,590 reads
The War Begins :: Reporting for duty
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we...
2007-06-29
1,332 reads
Blogs
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Playing with the Data API Builder
By Steve Jones
I published an article today on the Data API Builder, which is a way...
A New Word: Dolonia
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
Forums
Understanding allowed topics for testing
Hi, I am a first time writer looking to author some content here. I...
Do As I Say, Not As I Do
Comments posted to this topic are about the item Do As I Say, Not...
Filter a SQL Server Audit with a predicate
Hi Gents, Silly question, but it's been a long time since I've done this....
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