When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
2007-10-02 (first published: 2002-08-14)
24,646 reads
Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the ways functions can be used within SQL Server 2000.
2004-10-22 (first published: 2001-05-02)
21,100 reads
Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.
2003-02-21
10,028 reads
This article by Neil Boyle looks at the enhancements to triggers that SQL Server 2000 brings.
2001-07-11
6,694 reads
First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance.
2001-06-12
5,395 reads
This article by Neil Boyle examines techniques for speeding up your queries by writing better T-SQL.
2001-06-07
13,586 reads
Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.
2001-06-05
7,613 reads
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
2001-06-04
10,700 reads
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
2001-05-30
3,325 reads
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
2001-05-29
10,446 reads
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
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
Comments posted to this topic are about the item Getting Started with the Data...
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