Bitwise operators can be challenging to manage at first. However, with practice and patience, and under the right conditions, these operators can provide remarkable performance improvements in production environments. This article will compare two methods of accomplishing the same output, one with a normalized model and the other with bitwise operators.
2002-09-05
12,125 reads
This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQL scripting expert!
2002-09-04
781 reads
Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.
2002-09-03
4,776 reads
In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.
2002-09-02
5,810 reads
This 1100 page book offers something for everyone. Using Blobs, Analysis Services, Replication, High Availability. 38 Chapters plus ebook and tools on the CD. Should you get it? Read our review of this book to find out!
2002-08-30
5,072 reads
How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
2002-08-29
13,045 reads
Liberty Beta 2 will incorporate all the updates of SQL Server’s Service Pack 3. Furthermore, Liberty Beta 2 will be optimized for the newest addition to Intel’s Itanium® Processor Family, the Itanium® 2 processor. This beta is scheduled to start in late September.
Note: Liberty requires 64-bit hardware with an Intel’s Itanium® or Itanium® 2 processor and will not run on standard 32-bit machines.
2002-08-29
40 reads
A list of tips that should make your code more secure. Note that SQL Server is mentioned in a few places, especially # 4
2002-08-28
1,230 reads
In this article, we will leverage Extended Stored Procedures to extend the functionality of SQL Server and give a starting point to experiment with Extended Stored Procedures.
2002-08-26
6,884 reads
Andy takes a look at another entry level book, this one on ADO.Net.
2002-08-23
4,289 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers