-
When -- and when not -- to use lock hints in SQL Server
Learn how varying your use of lock hints can increase performance in SQL Server 7 and 2000.
-
Using SQL Server counters - Part 1
A look at some of the more useful performance counters for Microsoft SQL Server.
-
Avoid using BLOBs to store image data
Storing images in SQL Server with binary large objects, or BLOBs, can cause problems you'll want to avoid.
-
Get your indexes in shape
Commands for defragging.
-
How you store your SQL Server data matters
Where and how you store data with Microsoft SQL Server can greatly affect performance.
-
Disk tuning for SQL Server
Consider your SQL Server's disk storage configuration to achieve maximum performance.
-
Viewing configuration settings in SQL Server 2000
See how to view configuration settings in Microsoft SQL Server and learn what to do if changes need to be made.
-
Manual vs. automatic row locking (or conditional app lo
Be careful with trying to manually force row locking, you could lock up the SQL Server database. This tip discusses some alternatives.
-
Using the database maintenance plan wizard
Learn how to use the wizard in Microsoft SQL Server.
-
The Web-based database administrator
A description of the Microsoft's Web Data Administrator that allows you to administer SQL Server over the Internet.
-
Free SQL Server tool for the holidays
SQLCheck can help with a lot of different things in Microsoft SQL Server.
-
Using SQL Server application roles
Learn how to use application roles in SQL Server and some things to consider ahead of time.
-
SQL Server user-security checklist
Some actions to take to help keep SQL Server secure.
-
What's new in SQL Server 2005
A look at manageability and business analytics in SQL Server 2005.
-
Try the XML View Mapper
What it gives you, what it can do.
-
SQL Server support for XML
New clause that allows easy data manipulation.
-
SQL Server 2000 and XML
A look at some of SQL Server 2000's integrated XML support.
-
Performing incremental inserts/updates in SQL Server
This article discusses performing incremental inserts/updates to reduce lock conditions in Microsoft SQL Server.
-
Understanding NULL values in SQL Server
Learn what NULL values are good for in Microsoft SQL Server and how to use them.
-
Secure SQL Server data transfers
In this tip, learn about problems you may encounter when remotely administering SQL Server and how to secure the transfer of your data.
-
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
-
SQL Server meets database application security
Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.