Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-28
983 reads
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-28
983 reads
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2010-01-04
2,795 reads
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
2009-12-31
15,057 reads
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-29
3,772 reads
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-08
1,844 reads
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-17
1,413 reads
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-13
2,276 reads
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-05
1,355 reads
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-11-04
3,401 reads
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
2009-10-23
1,608 reads
By Steve Jones
I published an article today on the Data API Builder, which is a way...
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
Hi Gents, Silly question, but it's been a long time since I've done this....
Hi everyone I have a query that is taking a real long time. It...
Comments posted to this topic are about the item 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