New SQL Server 2000 Data Types
In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.
2001-05-14
6,830 reads
Articles
Removing Duplicate Rows
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
2001-05-14
11,811 reads
Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,543 reads
2001-05-13
2,569 reads
2001-05-13
2,920 reads
2001-05-11
3,017 reads
Changing Where The SQL Server Tools Are Installed
Have an older workstation with only a little hard drive space? Tired of the SQL Server tools taking about a hundred megs on your most precious drive? If you answered yes to either one of those questions, then this quick tip is for you.
2001-05-11
2,834 reads
Minimizing the Number of Log Backups
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,385 reads
2001-05-11
2,300 reads
Detaching and Attaching a Database
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
17,079 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers