Product and Book Reviews

SQLServerCentral Article

Visual Defrag for SQL Server Discount

  • Article

How often do you check your SQL Server tables for fragmentation? How often do you defragment them? This is one of those technologies that has been available for disks for a long time, but now is here for SQL Server. Norb Technologies is offering a discount to the SQLServerCentral.com community on this product.

You rated this post out of 5. Change rating

2005-11-01

4,102 reads

SQLServerCentral Article

SQL Rescue Review

  • Article

Having a good tool to read your SQL Server transaction log can be a lifesaver, or a job saver. RegGate Software, maker of a number of useful SQL Server utilities has a log reader and Grany Fritchey takes a look at this product and how it might work in your environment.

You rated this post out of 5. Change rating

2005-11-01

10,345 reads

SQLServerCentral Article

Review Armtech for SQL Server

  • Article

How many times have you wished you could throttle the CPU use of SQL Server? Or for a database? Prevent your developers from using too many resources while sharing the server with production or QA. ArmTech for Windows can do this and Dinsesh Asanka brings us a review of how this product worked in his environment.

You rated this post out of 5. Change rating

2005-07-26

5,471 reads

SQLServerCentral Article

Turbo for SQL Server

  • Article

Searching data is an essential part of SQL Server applications, especially text searching. While Full Text Search in SQL Server 2000 works, it lacks some important features that Turbo for SQL Server can handle. Read this review of the product and see if this is a way you can enhance the search functions in your application.

You rated this post out of 5. Change rating

2005-06-01

7,438 reads

SQLServerCentral Article

Litespeed for SQL Server

  • Article

Your backups are critical for the success and stability of your business. However as backup sizes grow and servers proliferate, managing the backups and storing all this data becomes a challenge. Dale Elizabeth Corey brings us a look at Imceda's Litespeed for SQL Server, a fantastic utility for helping manage your backups.

5 (1)

You rated this post out of 5. Change rating

2005-05-11

21,966 reads

SQLServerCentral Article

SQL Backup 3.0

  • Article

SQL Server 2000 has a rock solid backup process and one that many people have relied upon for years. However with the growth in database sizes and the constant load on many database servers, a third party backup utility is almost required in many environments. Kathi Kellenberger takes a look at Red-Gate Software's SQL Backup 3.0 and how it performs in her environment.

5 (2)

You rated this post out of 5. Change rating

2005-04-27

12,390 reads

SQLServerCentral Article

SQLH2: The Free Health, History and Performance Monitoring Tool

  • Article

One of the strengths and powers of the SQL Server platform over others is the shear number of things that are available free from Microsoft besides the relational platform. DTS, Reporting Services, SQLAgent, and more are included with the product. One of the newer utilities is SQLH2, a performance monitoring tool that is reviewed here by Kathi Kellenberger.

4.8 (5)

You rated this post out of 5. Change rating

2005-03-28

18,546 reads

SQLServerCentral Article

Netlib Encryptionizer Review

  • Article

SQL Server 2000 has a weak point in how it handles security. SA can see everything, a notion that disturbs many people, especially those that have data security requirements. Netlib has a great product that allows you to encrypt columns, tables, or databases in a way that is seemless to your application. Dale Corey takes a look at this product and how you might use it in your application.

You rated this post out of 5. Change rating

2005-03-07

7,961 reads

Technical Article

Review of Adventnet SwisSQL SQLOne Console, SQL Query Converter

  • Article

Recently, SwisSQL approached me for a review of their product that can convert SQL statements from one dialect to another. They told me that "SwisSQL SQLOne Console" is a GUI application that can convert SQL statements from one RDBMS implementation to another and the dialects supported include:

Microsoft SQL Server
Sybase
Oracle
IBM DB2
Informix
MySQL
PostgreSQL
MySQL
and last but not the least, ANSI SQL

2005-02-24

1,438 reads

Blogs

My 2024 in Data: Reading

By

This is my last week of the year working (I guess I come back...

My 2024 in Data: Speaking

By

This is my last week of the year working (I guess I come back...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

Need ADF pipeline suggestion to copy 1 million files

By varunkum

I have an ADF pipeline that copies Files from source to destination. Both Source...

Backup issues

By Bruin

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Visit the forum

Question of the Day

Function Defaults

I have created this function in SQL Server 2022:

CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
    RETURN @one + @two
END
How can I call this and invoke the default value for @two?

See possible answers