covering index

Technical Article

RE: Storing arrays in SQL.

  • Reply

My guesstimates are that this database, including indexes, will already amount to 1/2 terrabyte in size. Now if I included that schema for coping with arrays, god knows what size it will reach. With some tables with an estimated 500,000 records, that will then need 1,000,000 records in an array table at least. Database sizes […]


2 reads

Technical Article

RE: need help -Stored Procedure -Incorrect syntax

  • Reply

OK i workig 100% thnks a little question how can i add more filed to update like ---------------- @Fname [nvarchar](50),@fld1 [smalldatetime], @fld2 [int], ----------------------- i wont to learn the method --------------------------- declare @na varchar(500), @sisi int, @mmh char(10) set @sisi='2' set @mmh='uuu' select @na = @na + cast([na] as varchar) + ',' FROM [vsisi] UPDATE […]



Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers