Outer Join Trouble
Writing outer joins can be more difficult than it appears at first glance. Steve Jones examines this less often used query technique and brings to light a few places where you can lose data.
2006-01-05
18,615 reads
Articles
THE ROLE OF DATA DICTIONARY
IT leaders from enterprises around the world have realized that acquiring and implementing commercial off-the-shelf (COTS) application packages is a smarter thing to do, than the traditional approach of developing home-grown applications. This may not be the fit-for-all solution, but it makes sense from a cost, time to market and resource standpoint. Selection and acquisition of the software package is just the first step. How the software package brings value through successful implementation, is critical to the business. Internal groups as well as industry analysts will closely watch COTS package implementation in the organization.
2006-01-05
2,981 reads
Clustered Indexes in SQL Server: Things You Need to Know
This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I'll also give you some tips on how to use them in a not so obvious context.
2006-01-04
5,922 reads
Securing SQL Server
the January magazine is being printed right now and should be mailed out early next week. Read the editorial and see how you can get you e-copy now!
2006-01-03
4,845 reads
Digging Into Access Performance
Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.
2006-01-02
8,179 reads
Creating an End-to-End Package
In this sample chapter, you'll get a full tutorial on how to create an end-to-end SSIS package including transformation, looping and archiving of files.
2006-01-02
1,102 reads
Cursors and embedded SQL
In the days when I contentedly cut procedural code, I was puzzled by the visceral rages of the database specialists; they were like the ship’s cook occasionally going berserk with a meat-cleaver. After I switched to database work, I realized why.”
2006-01-02
3,504 reads
2005-12-30
2,121 reads
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,487 reads
Using ITWIZ.EXE to Automate Index Analysis
This process uses ITWIZ.EXE the command line version of the Index Tuning Wizard. SQL trace file information is stored in a table on production then transferred to a non-production server. ITWIZ is then run against the transferred trace data resulting in a UNICODE SQL script. This script has index creation and deletion information as well as script parameters in a remarks section.
2005-12-29
1,973 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers