Missing Temp Tables - Follow Up
Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!
2001-06-27
4,852 reads
Articles
Undocumented T-SQL Tricks With Logs
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.
2001-06-27
14,808 reads
2001-06-26
2,789 reads
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
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,053 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,602 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,433 reads
Tame Those Strings! Part 5 - Using STUFF
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,866 reads
Blogs
Getting Started with Azure SQL Database – A Beginners Guide
By John
Last Updated on September 24, 2024 by John Morehouse Years ago, I saw the...
Small Data SF 2024
By Steve Jones
I have often made an effort to attend conferences in the past to grow...
Additional Use for sp_statement_completed
Another discussion in Gothenburg (such a great group of people) around Extended Events lead...
Forums
+27640409447..,; ZIMBABWE SSD CHEMICAL SOLUTION FOR SALE IN BOTSWANA,ANGOLA,GAB
+27640409447..,;;' Hello Everyone!Our chemical solution, can clean deface+27813334083 currency, such as EUROS, POUNDS, DOLLARS,...
How to attach Database created in higher version to lower version of SQL Server
I have attempted to attach a database created in a higher version of SQL...
SQL Query Optimizer Supporting Parameterized Query and WHERE Clause Optimization
I am looking for a SQL query optimization tool that can enhance my query...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers