Technical Article

Reduce heap table fragmentation

  • Article

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.


5,779 reads

Technical Article

RE: SP Problem With VB6

  • Reply

You could have coded your SP as follows CREATE PROCEDURE usp_check_login   @username varchar(20),   @password varchar(20) AS   SET NOCOUNT ON   SELECT user_id,     user_active as login_active,     user_loginattempts as login_attempts,     user_type   FROM tbl_user   WHERE user_username = @username AND user_password = @password   RETURN @@ROWCOUNT GO That way you could use your RETURN_VALUE to determine whether or not your user […]


3 reads

Technical Article

RE: How to format DateTime?

  • Reply

just get rid of the time part on the input and sample dates. Method1 casting as int Cast(@inputDate1 as int) Method2 remove time part @newinputdate = Cast(Convert(varchar(10),@inputDate, 101) as datetime) Method3 you could use acombination of DateDiff using 'd' as the difference HTH


1 reads


InvalidAbfsRestOperationException in Azure Synapse notebook


Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs


log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers