An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
Learn how to boost the performance of SQL Server by making proper use of filegroups.
With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries.
This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!
Answers to the SQL quiz that Steve Jones used to give to prospective employees.
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Comments posted to this topic are about the item The Improvement Limit
Comments posted to this topic are about the item Migrate SSRS Reports to a...