Shrink Database Log Files One by One
Learn how you can shrink your transaction log files serially, one by one.
2023-03-31
3,806 reads
Manie Verster
- Interests: Photography, Programming, Computer Games
The Importance of Reading Comments
Read when you search for help on the internet. You might miss a very important part of what you must do.
2013-06-10
4,883 reads
2010-09-30
2,927 reads
2010-09-06
4,044 reads
Missing row numbers
I had a request from a client who prints a lot of cheques each month and there control over the cheques went a bit haywire. The requested me to create some controls in their system to make sure that the cheques are use in cheque number sequence.
2009-01-20
1,125 reads
Knowledge sharing
This article talks about the sharing of knowledge in forums such as SQLServerCentral.
2008-11-25
3,323 reads
Patindex
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,348 reads
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Is GenAI Coming Faster Than You Think?
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Local Storage Options
Comments posted to this topic are about the item Local Storage Options
DeepSeek: What is new with this AI technology?
Comments posted to this topic are about the item DeepSeek: What is new with...
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers