Find Min/Max Values in a Set
New Author! The author tries to port a solution from Oracle and runs into a problem. Agree with the solution?
2003-11-21
11,540 reads
Articles
Database Migration Tool
New product designed to help you move from one database platform to another. (Not Reviewed)
2003-11-21
1,260 reads
A Methodology for Determining Fill Factors
New Author! Jeff had some questions about fill factors - but no answers! He did some work and came up with a set of recommendations for how and when to set your fill factors to something other than the default.
2003-11-20
10,233 reads
Brief Tutorial on Text, Ntext, and Image
Joseph has written a couple articles for us and forwarded this link to an article he wrote recently on text type columns. You can see more of his work at http://www.sqlservercentral.com/columnists/jgama/.
2003-11-20
1,940 reads
Who Cares about FillFactor?
New Author! The first of two articles this week on fill factors, this article looks at the impact fill factor can have on performance and shows you the key tools and counters you use to assess the impact of changes to fill factor.
2003-11-19
25,842 reads
Database Workbench 2.4 released
Database Workbench, a cross database engine development tool, version 2.4 has been released today, 11/10/2003. It now includes support for MySQL and has an extensive list of bugfixes and small enhancements with regard to InterBase, Firebird and MS SQL Server support.
2003-11-19
265 reads
Multiple Table Insert
This article shows how to do conditional multiple table inserts. While it is more script than we typically display, it's interesting and might get you thinking about other uses for the idea.
2003-11-18
14,268 reads
The Guru's Guide to SQL Server Architecture and Internals
New book! This new book by Ken Henderson (author of other 'GURU' books abou SQL) promises an all inclusive approach to the internals. Sample chapters and other info available by following the link. We'll try to get a review up soon!
2003-11-17
1,325 reads
Using Xp_cmdshell
One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.
2003-11-14 (first published: 2001-05-03)
39,606 reads
Transferring a SQL Server Diagram
So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.
2003-11-13
11,693 reads
Blogs
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
Forums
Revolutionizing Entertainment with Mobile Game Development
Mobile game development has become a cornerstone of the entertainment industry, transforming creative ideas...
Exploring the Future of Mobile App Development
Mobile app development has become a cornerstone of modern business strategies, enabling companies to...
Events of System_health extended event serious or not
I have listed the event names present in my system_health extended event report. Based...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers