Shrink Database Log Files One by One
Learn how you can shrink your transaction log files serially, one by one.
2023-03-31
3,666 reads
Learn how you can shrink your transaction log files serially, one by one.
2023-03-31
3,666 reads
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,881 reads
2010-09-30
2,927 reads
2010-09-06
4,044 reads
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
This article talks about the sharing of knowledge in forums such as SQLServerCentral.
2008-11-25
3,323 reads
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,336 reads
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers