By Russ Whitney, 08/19/2003
OLAP cubes are notorious for having lots of empty (or null) cells. Including these empty cells in your result sets can bog down your analysis applications. But you can use these ...
By Rich Rollman, 08/19/2003
ADO.NET's DataSet gives you the performance benefits of client-side technology for storing and accessing large amounts of XML data in SQL Server.
By Brian Moran, 08/19/2003
Learn how to prevent certain users from creating new Data Transformation Services (DTS) packages on your server.
By Carolyn Mader, 08/19/2003
Check out the latest SQL Server-related new and improved products.
By Russ Whitney, 08/19/2003
Here's a query that uses the TOPCOUNT() function to rank customers who aren't single and female.
By Kalen Delaney, 08/19/2003
Sometimes you can't bring a business back to where it was before disaster struck. Here's how a leading replication and high-availability expert dealt with the worst disaster in ...
By Kalen Delaney, 08/19/2003
Any event that causes data loss or system downtime can be a disaster for your company. But with careful planning, you can minimize a disaster’s effects. Help your system survive ...
By Itzik Ben-Gan, 08/19/2003
Resourceful readers share their set-based solutions to August’s relational-division puzzle—and get great results!
By Kalen Delaney, 08/19/2003
Some additions to the sysprocesses table and a new function in Service Pack 3 make SQL Server troubleshooting even easier.
By Brian Moran, 08/19/2003
Do you regularly get an annoying error message from Enterprise Manager when you try to view database information through the Task Pad view?
By Michael Otey, 08/19/2003
SQL Server, far more than any other enterprise-level database, is installed and run under less-than-optimal conditions. Building truly reliable systems requires good planning and ...
By Brian Moran, 08/19/2003
How to write an OSQL script that passes your desired variables.
By Kimberly L. Tripp, 08/19/2003
Yes, you need to plan well for disaster recovery, but consider spending as much time on disaster prevention and minimization.
By Michael Otey, 08/19/2003
These connection-string examples illustrate the seven most common connection scenarios.
By Russ Whitney, 08/19/2003
Use the FoodMart 2000 Sales cube to find which 10 non-beer products customers purchased most frequently in the same transaction with beer products.
By Michelle A. Poolet, 08/19/2003
Typically, DBAs use database partitioning to improve performance or enforce security on large databases. However, in this case study, a company used partitioning to improve ...
By Various Authors, 08/19/2003
Readers write in about how Reporting Services will bring integrated OLAP and transactional reporting functionality within the reach of any business and about using Analysis ...
By Brian Moran, 08/19/2003
Would you like to know how to hide Data Transformation Services (DTS) packages from a certain set of Enterprise Manager users?
By Brian Moran, 08/19/2003
Learn how to verify that your client machine has a TCP/IP sockets Net-Library connection to the database.
By Kimberly L. Tripp, 08/19/2003
When disaster strikes only a subset of data, take the easiest route to recovery. Why undertake a full database restoration if faster recovery options are available?