Administration

SQLServerCentral Article

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

  • Article

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2007-11-01 (first published: )

38,884 reads

SQLServerCentral Article

Disaster In The Real World - #2

  • Article

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.75 (4)

You rated this post out of 5. Change rating

2012-12-14 (first published: )

10,626 reads

SQLServerCentral Article

Using the Copy Database Wizard

  • Article

In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.5 (2)

You rated this post out of 5. Change rating

2002-07-18

11,185 reads

SQLServerCentral Article

The Case for SQL Logins - Part 1

  • Article

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2 (1)

You rated this post out of 5. Change rating

2002-06-25

12,639 reads

SQLServerCentral Article

Creating your own sp_MSforeach stored procedure

  • Article

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2002-06-17

16,161 reads

SQLServerCentral Article

Maintenance Plans - Backups and Removing Old Files

  • Article

Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-06-10

7,592 reads

SQLServerCentral Article

Maintenance Plans - Behind the Scenes

  • Article

Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2002-05-27

10,421 reads

Blogs

How Redgate Flyway Can Boost Your DevOps Journey

By

A brief introduction to the tool and its advantages for database migrations DevOps is...

Building a Docker image with Docker Build Cloud

By

In a previous blog post we went through how to build a Docker container...

Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond

By

Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...

Read the latest Blogs

Forums

How to compare data in customer table with other customers to find related cust

By Zond Sita

select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...

process records in loop

By Bruin

I'm only processing 50,000 records not everything from the Table where there are 250,00...

The Marked Transaction

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Marked Transaction

Visit the forum

Question of the Day

The Marked Transaction

I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?

See possible answers