Kenneth Igiri

Kenneth Igiri is an Enterprise Architect with almost two decades of experience in Information Technology with nine of those years focused on SQL Server and Oracle databases. His interests include Database Performance, HADR, Cloud Computing, Data Architecture and Enterprise Architecture. Asides from his day job, Kenneth teaches at Youth Church, writes faith-based fiction and works as a Strategy Coach. You can connect with Kenneth via his blog https://kennethigiri.com, LinkedIn or YouTube (@kenigiri).
  • Interests: Strategy, Small Business, Creative Writing
  • Skills: Database Management, Data Management, Leadership, Management, Design Thinking

SQLServerCentral Article

SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.

4.38 (8)

You rated this post out of 5. Change rating

2016-11-30

2,395 reads

Blogs

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Friday Flyway Tips: Autopilot in 10 minutes

By

The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...

Read the latest Blogs

Forums

how to find the 2nd and 2nd to last entry in a table?

By water490

Hi everyone I am working on a query where the calculation depends on whether...

How to Obtain Call History of a Stored Procedure/UDF

By YSLGuru

I know in the past this wasn't possible but maybe that's changed as SQL...

No End to Programmers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No End to Programmers

Visit the forum

Question of the Day

Counting Bits II

What is the result of this query in SQL Server 2022+?

select bit_count('7')

See possible answers