With SQL Server 2000 you are able to create databases or columns with a different collating setting than the server. This article will explain a couple of methods Greg has used to successfully change collation settings.
2002-12-30
8,749 reads
This free extended stored procedure can read and write to a stored text file. Perfect for writing error logs!
2002-12-24
136 reads
This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed.
2002-12-23
11,250 reads
As a new DBA, you will probably walk into an environment that is poorly documented and nobody has any idea of how many SQL Servers are on the network. In the first series of articles, Haidong Ji talks about how to audit logins in your SQL Server.
2002-12-20
19,578 reads
A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.
2002-12-19
12,824 reads
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
2002-12-17
8,205 reads
Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.
2002-12-13
3,962 reads
Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!
2002-12-11
9,991 reads
EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.
2007-09-22 (first published: 2002-12-09)
32,449 reads
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
2002-12-04
8,111 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Comments posted to this topic are about the item What's the Date?
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Is there a good syllabus for reading these two together? (Yes, it's called the...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers