Optimizing SQL Server Performance Using Files and Filegroups
Learn how to boost the performance of SQL Server by making proper use of filegroups.
2001-06-26
1,774 reads
Articles
SQL Server 2000: New XML Features Streamline Webcast
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.
2001-06-26
4,110 reads
2001-06-25
7,065 reads
Automate Writing Stored Procedures
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!
2001-06-25
2,561 reads
Answers to Steve Jones's SQL Quiz
Answers to the SQL quiz that Steve Jones used to give to prospective employees.
2001-06-22
11,617 reads
Who Do You Hire?
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
2001-06-22
13,447 reads
2001-06-20
3,647 reads
Job to Monitor SQL Server 7.0 Performance and Activity
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads
2001-06-18
1,988 reads
Installing Service Pack 1 for SQL Server 2000
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000.
2001-06-18
5,421 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Multi-State Payroll Tax Issues 2026
Prepare for 2026 with this essential multi-state payroll tax issues 2026 webinar from Professionals...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers