(Andrew Novick) In 2003 and 2004, when this news letter was the UDF of the Week Newsletter, it featured the occasional user contributed code. The format of Coding-in-SQL doesn’t really lend itself to most user contributions but shen a reader, Jason Schaitel, sent in some code last week I decided th

(Hari Ramachandran) For years, Microsoft Product Support Services (PSS) has used two tools—OSTRESS and Read80Trace—to simulate scenarios and analyze large SQL Server trace files for its customers. At the Professional Association for SQL Server (PASS) 2004 conference, PSS released these tools to the

(Vijay Kumar) When an application submits a SQL query to the database server, the server first parses the SQL. It checks the SQL syntax, for security access and prepares the query for execution. Query optimization involves determining the optimal path for executing the query. The server uses eit

(Scott Robinson) I remember a time (a time long past) when the idea of tying applications together across functional (and, heaven forbid, departmental) boundaries was not only politically incorrect to the in-house user community, but downright frightening to some—and certainly intimidating to IT (or