Kenneth Fisher

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at https://sqlstudies.com/.

Microsoft’s free virtual labs

by Kenneth Fisher

SQLStudies

If you have spent any time looking around my site, you will notice that I love study materials and in...

2014-05-26

1,177 reads

DBA Myths: A table with a primary key is not a heap

by Kenneth Fisher

SQLStudies

Typically when you see a heading like this you know the answer is “No” or “False” but in this case...

2014-05-21

2,618 reads

Granting or denying permissions to all of the tables within a database

by Kenneth Fisher

SQLStudies

When granting or denying permissions to the tables within a database you have two options. You can either add the...

2014-05-20 (first published: 2014-05-15)

3,231 reads

T-SQL Tuesday #54: Interviews!

by Kenneth Fisher

SQLStudies

It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing....

2014-05-16 (first published: 2014-05-13)

1,616 reads

Does SQL Server do a CHECKDB during an instance restart?

by Kenneth Fisher

SQLStudies

When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server...

2014-05-13 (first published: 2014-05-07)

2,383 reads

Why is there a sysobjects when we already have sys.objects?

by Kenneth Fisher

SQLStudies

Once upon a time in a version of SQL far far away we had system tables that were easy to...

2014-05-05

712 reads

Collation: Confusion

by Kenneth Fisher

SQLStudies

I started reading about collations after I had a recent run in with them. As I read I started to...

2014-05-02 (first published: 2014-04-23)

2,387 reads

Collation: Temporary objects and variables: Demonstration

by Kenneth Fisher

SQLStudies

I had a recent run in with collation problems and it got me started reading about them. As I read...

2014-04-30 (first published: 2014-04-21)

1,870 reads

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

by Kenneth Fisher

SQLStudies

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...

2014-04-30

2,706 reads

The default autogrowth settings do NOT come from the Model database.

by Kenneth Fisher

SQLStudies

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed...

2014-04-28

1,133 reads

Blogs

My 2024 in Data: Reading

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

My 2024 in Data: Speaking

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

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

By Tracy McKibben

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

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

Backup issues

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