2001-05-15
1,910 reads
Articles
2001-05-14
1,462 reads
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,811 reads
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,802 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,530 reads
2001-05-13
2,560 reads
2001-05-13
2,906 reads
2001-05-11
3,009 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,830 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,380 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers