Recursive CTE

Technical Article

RE: DTS disconnected edit: The system cannot find the file specified

  • Reply

Disconnected edit will check the connections in the package before the dialog opens. You probably have a connection that references a file that can't be found. Maybe a UDL file or something?Why do you need to use disconnected edit? The "Properties" and "Workflow Properties" dialogs for the ActiveXScript task should give you all you need. 


Technical Article

DateTime Conversion

  • Topic

I currently, have a field in a table that is a numeric field = 20030104 - I need to convert this to a date field = 01/04/2003 - what is the proper syntax for use in a select statement?Note that I am creating a table and I tried to change the field type to datetime, […]


2 reads

Technical Article

RE: SQL getting slower and slower

  • Reply

I second Allen's questions.   And yes, the hyperthreading is the reason for the 4 cpu's in task manager.When I first took this job I had a server do the same thing.  They were restarting it to get it going again.  You probably have a bottleneck somewhere.  It could be caused by hitting the knee in […]


Technical Article

RE: Spilt string into seperate fields

  • Reply

Phill,Some inline views may help simplify it:select     Account,     Address1 = substring(address, 1, delimpos1-1),     Address2 = substring(address, delimpos1+1, delimpos2-delimpos1-1),     Address3 = substring(address, delimpos2+1, delimpos3-delimpos2-1),     Address4 = substring(address, delimpos3+1, delimpos4-delimpos3-1),     Address5 = substring(address, delimpos4+1, address_len-delimpos4) from (     select *, delimpos4=charindex(';', address, delimpos3+1)     from (         select *, delimpos3=charindex(';', address, […]


Technical Article

RE: Syntax problems

  • Reply

Hi Lars,Below is the corrected syntax.declare @UnitWeight as Real,@fVal as Realset @UnitWeight = 1set @fVal=0SELECT @fVal=SUM(isnull(FVALUE,0))  from ITEMSET @UnitWeight = @fVal Pls check it out.Nitin 



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers