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

DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

by Kenneth Fisher

SQLStudies

I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do...

2014-12-11

3,415 reads

TSQL Tuesday #61: Giving Back, you gain more than you give.

by Kenneth Fisher

SQLStudies

Almost four months ago I posted my goals for the next year in my two year anniversary post. I pretty...

2014-12-09

751 reads

Using a date or int column as the clustered index.

by Kenneth Fisher

SQLStudies

The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on...

2014-12-08 (first published: 2014-12-01)

6,986 reads

INSERT INTO SELECT vs SELECT INTO

by Kenneth Fisher

SQLStudies

INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and...

2014-12-03

15,632 reads

You don’t really need ORDER BY do you?

by Kenneth Fisher

SQLStudies

You see dozens of blog posts and articles about how the order of a result set is not guaranteed without...

2014-12-01 (first published: 2014-11-19)

9,657 reads

Who’s on call

by Kenneth Fisher

SQLStudies

Kenneth Fisher:
I really enjoyed writing this post last year and honestly still enjoy reading it myself. And since tomorrow is...

2014-11-26

1,054 reads

Putting sp_ at the beginning of your stored procedure.

by Kenneth Fisher

SQLStudies

Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So...

2014-11-24

1,089 reads

Using T-SQL to populate a Central Management Server

by Kenneth Fisher

SQLStudies

We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the...

2014-11-24 (first published: 2014-11-17)

6,991 reads

Adding a column to the primary key.

by Kenneth Fisher

SQLStudies

Every now and again you realize that the primary key for a table does not uniquely describe a row. Not...

2014-11-13

1,086 reads

TSQL Tuesday #60: Something New Learned – What permissions does have?

by Kenneth Fisher

SQLStudies

What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...

2014-11-11

1,663 reads

Blogs

T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

I haven’t posted in a while (well, not here at least since I’ve been...

Keeping MS Docs Up to Date

One of the things that I like about the SQL Server docs (MS Learn...

Patch Tuesday – Where to get more information

By Brian Kelley

For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...

Read the latest Blogs

Forums

is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

is there a no code way to limit an ssis extract from excel to...

Pivot but preserve all rows on Aggregate column

Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...

any reason to avoid asking ssis to extract files from ftp

hi we have to replace talend which generally was used to move files. talend's...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers