SQL Server Magazine January 2002
[Focus]
SQL Server trainer and consultant Morris Lewis recommends a variety of resources that SQL Server administrators and developers can use to improve their knowledge and advance their careers.
By Morris Lewis
What trends will affect your role in the SQL Server world? What areas of specialization will put you ahead of the pack? This advice from the experts can help you choose the right SQL Server career paths.
By Brian Moran
[Features]
Now that you've seen how you can easily set up, reconfigure, and monitor log shipping in SQL Server 2000, beef up your knowledge of role changes, role reversals, and where to place the monitor server.
By Ron Talmage
Use SQL-DMO and other techniques to keep your application and users working effectively long after your MSDE installation is complete.
By William Vaughn
[SQL Server Savvy]
I'm using distributed partitioned views to run a query on two servers. However, the two parts of the union execute serially rather than in parallel. Why?
By Brian Moran
Can I compare the image value in one row with the image contents of another row to determine whether the contents are identical?
By Brian Moran
I'm trying to use T-SQL to return the relative percentage of two summed values when I divide the values into each other. Why does my calculation behave as if it's doing integer math?
By Brian Moran
How can I see when my SQL Server 2000 database file grows and how much it grows each time?
By Brian Moran
What does the value LPC mean in the net_library column of my master..sysprocesses table?
By Brian Moran
[Editorial]
By providing a native JDBC driver for SQL Server, Microsoft hurdles the Java stumbling block and continues to push SQL Server into the enterprise.
By Michael Otey
[SQL Seven]
Here are seven more undocumented extended stored procedures that can add power to T-SQL.
By Michael Otey
[Inside SQL Server]
Rewriting your queries to use TOP instead of SET ROWCOUNT can be a form of query tuning.
By Kalen Delaney
[Mastering Analysis]
To write queries that always return the most recent information, you need an MDX formula that moves forward in time as you add new information to the database. Here are four ways to create this time-dynamic MDX.
By Russ Whitney
[Solutions by Design]
Create a set of history tables in your database or build a separate history database without jeopardizing your database’s performance.
By Michelle A. Poolet
[Answers from Microsoft]
Microsoft’s SQL Server development team provides code that retrieves extended properties in a Web-based SQL Server administration application.
By Richard Waymire
Microsoft’s SQL Server development team explains why a transaction log expands and offers remedies for the problem.
By Richard Waymire
Microsoft’s SQL Server development team explains how to accommodate the most SQL Server connections on one node.
By Richard Waymire
Microsoft’s SQL Server development team tells a reader how to enforce a trigger’s unique value by using a custom CHECK constraint or, in SQL Server 2000, INSTEAD OF triggers.
By Richard Waymire
Microsoft’s SQL Server development team explains why dynamic snapshot processes articles for replication multiple times.
By Richard Waymire
[Exploring XML]
To prevent XML Bulk Load from truncating your data without notice, you can use SAX2 validation with XML Schema mapping schemas to ensure that only data of the correct type is loaded into your database.
By Rich Rollman
SQL Server 2000 doesn't support recursive queries. However, by using the new sql:max-depth annotation, you can easily generate recursive hierarchies without the complexity of building a FOR XML EXPLICIT query.
By Rich Rollman
[Letters]
Readers write in about the implications of increasing SQL Server's programmability, using computed columns, and understanding transaction isolation levels.
By Various Authors
[New Products]
A collection of the latest SQL Server-related new and improved products.
By Carolyn Mader , et al.
|
