SQL Server Magazine December 2004
[Focus]
The typical SQL Server pro, according to SQL Server Magazine's 2004 salary and industry survey, is a white male in the 30- to 39-year-old age range working as a DBA on the East Coast. See how you compare to this profile of survey respondents.
By Jessica Heckathorn
SQL Server pros love their work--but their jobs can be tough to take. Survey respondents speak out about what makes them happy in their careers and the challenges they face.
By Dawn Cyr
Find out how your pay stacks up against your peers', where the best-paying jobs are--and who has them.
By Suzanne J. Cone
[SQL Server Savvy]
When you call sp_configure to set a value for any option, SQL Server issues a DBCC FREEPROCCACHE command, which invalidates all stored procedure plans currently cached and requires recompilation of new plans.
By Brian Moran
Are you deciding between SQL Server Authentication and Windows Authentication? Find out which method provides better security.
By Brian Moran
SQL Server Profiler is your most important tool in your SQL Server tuning arsenal. But like any powerful tool, Profiler can cause problems.
By Brian Moran
Generally speaking, the difference between a SQL:BatchCompleted event's duration time and a SQL:StmtCompleted event's duration time is how long each event takes to parse and compile a query.
By Brian Moran
[Editorial]
With the advent of 32-bit-compatible x64 chips, the 64-bit computing wave is about to break. If you’re considering a SQL Server system upgrade in the next year, one of these 64-bit platforms should be on your short list.
By Michael Otey
[Inside SQL Server]
Use these tools to find everything you ever wanted to know about your indexes--and then some.
By Kalen Delaney
[Solutions by Design]
Keyword arrays are common but hurt database performance by forcing table scans. Here's how arrays hurt and how you can help.
By Michelle A. Poolet
[T-SQL Black Belt]
When the query results are too big for one screen, you need to set up your application for paging. Take a look at these two solutions to fit any paging needs.
By Itzik Ben-Gan
[New Products]
Check out the latest SQL Server-related products.
By Dawn Cyr
[SELECT TOP(X)]
Here are five techniques for writing better code from Steve McConnell’s new book, Code Complete, Second Edition (Microsoft Press, 2004).
By Michael Otey
[Ask Microsoft]
Microsoft's Richard Waymire reports that a new Yukon feature will let users read data that another user is updating.
By Microsoft's SQL Server Development Team
Microsoft's Patrick Conlan explains techniques for stripping letters out of a string.
By Microsoft's SQL Server Development Team
|
