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/.

Physical Join Operators by Ami Levin

by Kenneth Fisher

SQLStudies

For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...

2013-11-06

672 reads

Adding a column to a table with a default (NULL vs NOT NULL)

by Kenneth Fisher

SQLStudies

There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...

2013-11-05 (first published: 2013-10-30)

5,170 reads

A look at comments

by Kenneth Fisher

SQLStudies

Everyone knows that we should include comments in our code right? On the other hand the vast majority of us...

2013-10-29 (first published: 2013-10-21)

1,740 reads

Change in SQL 2012 SSMS grid output behavior

by Kenneth Fisher

SQLStudies

It’s one of those things that always aggravated me but not really enough to complain about. When you run a...

2013-10-28

693 reads

Unexpected truncation in FETCH

by Kenneth Fisher

SQLStudies

Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...

2013-10-23

720 reads

I’ve refreshed a test database from prod but now the users can’t access it.

by Kenneth Fisher

SQLStudies

This happens to me all the time. I get a request from a developer to overwrite the test copy of...

2013-10-16 (first published: 2013-10-09)

2,666 reads

Query to compare indexes between two tables

by Kenneth Fisher

SQLStudies

We have a set of databases at my office that use the load and swap method of loading data with...

2013-10-16

1,206 reads

Why you should know how to script as well as use the GUI

by Kenneth Fisher

SQLStudies

Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out...

2013-10-14

1,010 reads

Use TOP instead of SET ROWCOUNT

by Kenneth Fisher

SQLStudies

Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however...

2013-10-10 (first published: 2013-10-07)

3,975 reads

T-SQL Tuesday #47: Your Best SQL Server SWAG

by Kenneth Fisher

SQLStudies

It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG....

2013-10-08

748 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By Brian Kelley

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By Meagan Longoria

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCU Galaxy No.Telp 083831617937

By oasisoutdoorproducts

Whatsapp.083831617937 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Kota SBY, Jawa...

BCA KCP Darmo Indah Timur telp:cs.083188951403

Whatsapp:083188951403 Jl. Raya Satelit Indah No.AN-2, Tanjungsari, Kec. Sukomanunggal, Surabaya, DKI Jakarta 60187

BCA KCP Mangga Besar No tlpon:083138717148

Whatsapp:083138717148.Jl. Raya Mangga Besar No.15, RT.6/RW.5, Mangga Besar, Kec. Taman Sari, Kota Jakarta Barat,...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers