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,472 reads
Andy Warren
Starting and Stopping SQL Server Part 3
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,821 reads
Starting and Stopping SQL Server Part 2
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,491 reads
Starting and Stopping SQL Server Part 1
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,137 reads
Use ISO Images Without Burning to Disk
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,401 reads
Logins, Users, and Roles - Getting Started
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,409 reads
Dynamic SQL or Stored Procedure
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,331 reads
Reducing Round Trips
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)
22,925 reads
Running Out of Space
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,167 reads
Worst Practices - Making Databases Case Sensitive (Or Anything Else)
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,150 reads
Blogs
Part 2: The Modern Azure Data Warehouse – ADF and ADLS
In today’s data-driven world, having the right tools to manage and process large datasets...
A New Word: Flichtish
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
Automating Container Image Builds with Docker Build Cloud and Github Actions
In a previous post we went through how to use Docker Build Cloud to...
Forums
Realities of Predictive Analysis
Comments posted to this topic are about the item Realities of Predictive Analysis
Linked Server Product Name?
Just came across something weird. Was wondering if anyone else has ever seen this....
Can index fragmentation cause the database to enter suspect mode?
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
Question of the Day
Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers