SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• How to get top 100 values of a col concatenated in a variable in sqlserver?

  hi,   I have used two ways to get the value of the col in a variable. Which one I should prefe…

  rajemessage 14195

  18 replies

  1 year, 10 months ago

  By: Jeff Moden

• What are some SQL commands that data scientists should be familiar with ?

  Hello As an individual who is new to the field of data science, I am keen to gain insights into the…

  avijeet26

  3 replies

  1 year, 10 months ago

  By: Jeff Moden

• Page cost

  A wise person once told me that the cost of retrieving a page in a large result set increased linea…

  bbsimonbb

  1 replies

  1 year, 10 months ago

  By: bbsimonbb

• Domain Extension Splitting Based on Dot(.)

  Hi All, I need to extract the domain extension from the column based on dot(.) like the below &nbs…

  sathishkm

  3 replies

  1 year, 10 months ago

  By: Jeff Moden

• SQL Server RLS Database Users and Login User Permission

  Please suggest practice on SQL Server RLS On the database level, defined users with different permi…

  Irakli Lomidze

  2 replies

  1 year, 10 months ago

  By: SQLWizard

• simple query question

  hi all, I have a simple question: having a table where I have multiple orders for any number of ven…

  axes2000

  7 replies

  1 year, 10 months ago

  By: Jeff Moden

• Is TemporalTable SysStartTime available before performing an insert/Update?

  I want to align a Date column (datetime2(7)) with the same full resolution date of SysStartTime col…

  Dwaine Wright

  6 replies

  1 year, 10 months ago

  By: Ken McKelvey

• Matching the table

  Hi All, I have two table called TableA and TableB. Here I need to match the TableB records from Tab…

  sathishkm

  2 replies

  1 year, 10 months ago

  By: Dennis Jensen

• SSDT import into a table from .csv corruption

  Hello everyone, I am importing from a csv file into a table. Everything works fine. One filed is im…

  atzvei

  6 replies

  1 year, 10 months ago

  By: Jeff Moden

• Master Data - Hierarchies Creation, Change and Maintenance

  Dears, Hope this message finds you well I am now moving into a Master Data position and my experien…

  river1

  16 replies

  1 year, 10 months ago

  By: Jeff Moden

• Grouping the first letter in a string

  Hi All, I have the column of data in SQL Server. Here  I need to group the letters of first word i…

  sathishkm

  6 replies

  1 year, 11 months ago

  By: Jeff Moden

• Extracting the string before and after the given character

  Hi All, I want to extract the string before and after the given characters. Example: ijk.nl?utm_sou…

  sathishkm

  1 replies

  1 year, 11 months ago

  By: aitorzur@hotmail.com

• Data Problem

  This is the Data ID ----- Date From ------   Date To    ------- 2  ----- 2020-01-01  ----- 20…

  immad

  4 replies

  1 year, 11 months ago

  By: Jeff Moden

• what's the performance difference between unique clustered index and primary key

  Is there a performance difference between a unique clustered index and a primary key clustered inde…

  Snargables

  29 replies

  1 year, 11 months ago

  By: CreateIndexNonclustered

• Partial Matching the Columns

  Hi All, How could I partially match the columns from two different table. I have attached the excel…

  sathishkm

  3 replies

  1 year, 11 months ago

  By: Jeff Moden