This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query
2003-10-30
56 reads
New Author! Ramesh talks a little about database theory, using the ERD, and how you can put it to work.
2003-10-28
22,498 reads
Have you ever tried to open the current error log in Enterprise Manager only to have it seize up and hang? Has that annoyed you? It certainly annoyed Steve Jones and he decided to do something about it. A little techinque for helping to manage the size of those logs and prevent the "not responding" message from appearing in Task Manager.
2003-10-27
6,348 reads
This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)
2003-10-24
8,318 reads
New Author! This is a fairly article that looks at how to do bulk data loading at a very (very) low level. You'll need to be able to read code to make use of this.
2003-10-23
5,863 reads
New author! Nick discusses why 'XML is One Answer', outlining some of what he believes are key points about using XML with SQL Server. This is a follow up (and sort of counter point) to another great article we had here on the site a couple weeks ago by Don Peterson. Good stuff!
2003-10-22
5,743 reads
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
2003-10-21
70 reads
Regular columnist Robert Marda discusses a few ideas on stored procedure documentation. How much documentation do you need and is "documentation" different than code comments?
2003-10-20
18,716 reads
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
2003-10-16
8,880 reads
Another adventure in the real world. Steve Jones tracks down a problem with locks on a live system. Read along and see how he works through the issues.
2003-10-15
5,191 reads
Say you need outside help. You’ve exhausted all the things that you could do...
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
Comments posted to this topic are about the item How Clustering can be Used...
Comments posted to this topic are about the item Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers