March 25, 2003
When you want more than just the summary data that GROUP BY can give, using COMPUTE and COMPUTE BY is the best way to get the details and aggregates.
February 1, 2003
Learn what you can and can't do with SQL Server views, and a few tips on better viewing habits.
January 1, 2003
In SQL Server, data types can have owners, and in some circumstances, you might want to change a data type’s owner. But to do so, you must first understand user-defined data types and know how to find information about them in your database.
December 1, 2002
Do you need full-text search capabilities? Microsoft provides a full-text search component in SQL Server, but you might find that creating a custom solution is less expensive and easier to maintain.
December 1, 2002
Assigning permissions isn’t always straightforward, especially when you’re working with dependent objects. Here are some complications you might encounter in your permissions and how to solve the problems that can crop up.
December 1, 2002
Part one in a series of articles that explain everything you need to know about using views and achieving the best query performance with them.
December 1, 2002
In general, the only kinds of permissions that are inheritable are those that you can grant. But one exception to this rule is the RAISERROR command.
November 26, 2002
Here's a small homework assignment to help you create and access views.
November 26, 2002
Use this method of rewriting queries to improve the performance of your custom search solution.
November 1, 2002
In the second of two articles, Itzik Ben-Gan explains how to use the XOR and NOT bitwise operators and shows you how to how to extend the bitwise manipulation capabilities in T-SQL by writing your own user-defined functions.
November 1, 2002
User permissions let you control exactly which users have access to what data. Learn how to use specific commands to set permissions and how to use system tables to track permissions information.
November 1, 2002
Use the information in the sysperfinfo system table to put specific performance counter values into your T-SQL scripts.
November 1, 2002
Here are two ways to define a list in the sort order you choose.
November 1, 2002
It seems so easy: The query should return the decimal number you want when you use the POWER() function with a negative exponent. But hidden in this combination is a trap that Itzik Ben-Gan reveals.
November 1, 2002
Writing a query that calculates percentages from a bit column might prove to be more difficult than you think. Itzik Ben-Gan describes an efficient method.
November 1, 2002
When you try to convert sales data in an integer column to numeric form, you might receive a different result than you expect. Here’s a way to avoid the pitfalls.
October 1, 2002
Because they both have generalized purposes, people sometimes confuse the PUBLIC role and the guest username. Learn why this special role and special username are different and how to use them effectively.
October 1, 2002
Storing two-valued flags such as on/off or true/false can create sticky problems for developers. Learn how you can use bitwise operators to create flexibility in manipulating flags.
October 1, 2002
Until the advent of SQL Server 2000, if you wanted to encapsulate a simple expression, you had to hard-code it in a view. Now you can use a UDF to encapsulate the expression and reuse it. Flexibility is the key.
October 1, 2002
This homework assignment can help you further improve your ability to write scalar UDFs.
Add these Headlines to your Website
