Starting and Stopping SQL Server Part 4
Continuing with his series on working with SQL Server, Andy Warren looks at how long it can take to start or restart the services and why.
2005-12-29
9,480 reads
Continuing with his series on working with SQL Server, Andy Warren looks at how long it can take to start or restart the services and why.
2005-12-29
9,480 reads
Continuing with his series, Andy Warren looks at what it means for SQL Server 2000 command line parameters as well as checkpointing with this service.
2005-12-15
9,829 reads
Continuing with his series, Andy Warren looks at what it means for SQL Server 2000 to run as a service and some of the options you have for starting, stopping, and restarting your server.
2005-12-01
11,502 reads
I'm sure most DBAs don't give a second thought to starting and stopping their SQL Server 2000 servers. But do you know the different ways to do this and some of the impacts and expectations you should have? Especially with hardware growing, it's not always as simple and straightforward as it should be. Andy Warren recently had to deal with some issues and starts a new series looking at the various ways of starting and stopping SQL Server.
2005-11-17
17,187 reads
Many downloads - especially from MS - are now coming as ISO images. Usually you burn these to CD or DVD and then use as normal, but there is a way to access the image directly saving the time/cost of burning. Not a SQL article, but you may find it useful anyway.
2005-10-14 (first published: 2004-07-16)
55,505 reads
Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.
2005-09-30 (first published: 2003-02-19)
37,496 reads
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
2005-08-26 (first published: 2003-04-23)
48,493 reads
One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.
2005-07-15 (first published: 2002-01-24)
23,320 reads
How many times have you run out of space in a database? What about on a file system? Andy Warren has had this happen a few times, especially when large imports take place. He brings us an article that describes some of the precautions he has taken to prevent this from happening.
2005-07-14
11,198 reads
Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!
2005-07-08 (first published: 2001-10-29)
29,241 reads
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
Comments posted to this topic are about the item UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A:
B:
See possible answers