SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• advice on diving into devops for managing BI projects

  hi , i know this is a sql server forum but i think my brain is aligned more with members of this fo…

  stan

  7 replies

  20 hours, 39 minutes ago

  By: stan

• Simplifying WHERE Condition with LIKE test on multiple columns

  Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1] LIKE 'B…

  Reh23

  4 replies

  2 days, 13 hours ago

  By: frederico_fonseca

• reaching ftp thru winscp but erroring in ssis ftp task connection

  Hi, below i show various results trying to reach our ftp site (a globalscape product) from both win…

  stan

  20 replies

  3 days, 18 hours ago

  By: Lisa Slater Nicholls

• Switch partition: NULL boundary id

  I have table: t1 in schema1 with 19 billion records. I have another table with same name: t1 in sch…

  vpolasa

  1 replies

  4 days, 22 hours ago

  By: Jo Pattyn

• Deleting data in large table

  I have a large table with 17M+ rows for our package record audits.  I've decided to clear out anyth…

  Jackie Lowery

  12 replies

  1 weeks, 6 days ago

  By: Jonathan AC Roberts

• SQL Server 2022 order by bug?

  Hi, I was using order by on a column with characters and saw something I couldn't explain. Seems a …

  hugo-939487

  14 replies

  2 weeks, 5 days ago

  By: hugo-939487

• cant process ssas db on vm - error says source is encrypted and other things

  hi i get the error you see below when trying to process my AR cube full.  it is sourced by a sql db…

  stan

  23 replies

  3 weeks, 2 days ago

  By: stan

• This doesn't make sense to me - making me crazy - er

  Hi So I have the below select query that won't return results if I have it this way:   --DOES …

  krypto69

  4 replies

  1 months ago

  By: krypto69

• fast farward curson vs while loop on @table

  hi, need to known weather fast farwand cursor is faster than a while loop made on @table variable h…

  rajemessage 14195

  4 replies

  1 months ago

  By: carwalk

• Find all the tables in a database containing particular column value

  Hi, I want to find all the tables name under a database where tables having text like "ID". Like in…

  RCRock

  7 replies

  1 months ago

  By: pietlinden

• Looking for help with SQL statement

  Hi there I am seeking some help with an SQL statement. Any help would be welcomed. TIA   See t…

  DalF1960

  6 replies

  1 months, 2 weeks ago

  By: ScottPletcher

• Select @ for different fields

  I have a need where I need to pass a field name to a Stored Procedure then lookup information on it…

  bswhipp

  6 replies

  1 months, 2 weeks ago

  By: Mr. Brian Gale

• Varchar(max) to lines

  I have an issue with a varchar(max) field with up to 7000 characters needing to be put in to lines …

  bswhipp

  5 replies

  1 months, 3 weeks ago

  By: bswhipp

• best tool for documenting your databases (more design decisions etc)

  Any suggestions for a good tool for documenting a database and all the important objects in it? I'm…

  pietlinden

  5 replies

  1 months, 3 weeks ago

  By: carwalk

• ERD Tools recommendation

  Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations? Thanks!

  Coffee_&_SQL

  8 replies

  1 months, 3 weeks ago

  By: mamta25