Quick Tip: Taking a Database Offline
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,723 reads
Articles
Tuning SQL Server Memory in 2 Minutes
You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.
2001-05-21
10,037 reads
VMWare
VMWare is a software product that is great for testing new ideas without having to purchase and install a separate machine.
2001-05-21
4,338 reads
SQL Server 2000 Black Book
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
2001-05-18
4,607 reads
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,253 reads
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,709 reads
Cell Phone Horror Stories
These are some stories that show the downside of everyone having cell phones.
2001-05-16
1,807 reads
Getting The Best From The Index Tuning Wizard
The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.
2001-05-16
5,383 reads
Using DTS Global Variables
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
2001-05-16
14,831 reads
Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
2001-05-15
14,826 reads
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers