SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Data modeling tooling

  Just wondering what people might be using as a data modeling tool these days? Looking for a tool th…

  Jim_K

  2 replies

  1 year, 8 months ago

  By: arnoldnashwel

• SQL to insert row with RefNum to be the next numeric number

  Hi all, I need some help with SQL. I want to create test data by inserting new rows into an existin…

  Coung

  10 replies

  1 year, 8 months ago

  By: arnoldnashwel

• Does INSERT's affect performance depending on INSERT order?

  Assume I have a table with a clustered datetime-index. Assume I'm going to insert lots of data. The…

  oRBIT

  10 replies

  1 year, 8 months ago

  By: Jeff Moden

• Error converting datatype varchar to bigint

  Hi Tried a few things here but can't seem to get past the 'Error converting datatype varchar to big…

  krypto69

  5 replies

  1 year, 8 months ago

  By: Jeffrey Williams

• Why is BigQuery Sandbox saying its ERROR: Expected keyword AS but got "(" at [1:

  Is this an issue with BigQuerry. I was follwing along with this youtube video and for some reason t…

  willdabeast28

  1 replies

  1 year, 9 months ago

  By: Mr. Brian Gale

• How to extract number that is greater than or equal to 16 digits

  Good Morning,   I am using sql server 2022, I have a table I would like to extract 16 Digits o…

  Zond Sita

  7 replies

  1 year, 9 months ago

  By: Phil Parkin

• Basic query performance

  Hi, I have this pretty basic query that is starting to perform slowly. It returns over 22m records …

  krypto69

  22 replies

  1 year, 9 months ago

  By: Mr. Brian Gale

• Column Name Is Different in Power BI Than SQL View

  Hi all, Using Snowflake. When I Describe my View the first columns shows as Nielsen Market Name (KU…

  winston.snyder

  2 replies

  1 year, 9 months ago

  By: Mr. Brian Gale

• Aggregate date series

  I have a an EmployeeTable with data for each day. I need to aggregate that into a table with From a…

  hebjTS

  4 replies

  1 year, 9 months ago

  By: hebjTS

• How to query selected multiple rows into multiple colums

  How to display datas using query data from multiple specific rows in one table sql into multiple co…

  harrytiadi

  3 replies

  1 year, 9 months ago

  By: Phil Parkin

• Return

  Self taught novice learning SQL and would welcome some help with the following code problem In my d…

  Cybodz

  11 replies

  1 year, 9 months ago

  By: Cybodz

• Freezing of multiple databases using VDI snapshot backup command.

  Transact-SQL snapshot backup for SQL Server 2022: Suspend all user databases on the server for a sn…

  Vivek Luhaniwal

  1 replies

  1 year, 9 months ago

  By: Vivek Luhaniwal

• Last value in a row containing..

  I've inherited code in which I need to designate each PATID as either Rel_Exempt or Med_Exempt, dep…

  boehnc

  7 replies

  1 year, 9 months ago

  By: boehnc

• Replication for archive server with longer retention period

  I want to set up SQL Server transactional replication from a main SQL Server to an archive SQL Serv…

  Jon 0x7f800000

  4 replies

  1 year, 9 months ago

  By: Jon 0x7f800000

• Retrieving First Word, First + Second Word, First + Second + Third Word, First

  Hi All, I have the company names in one column. Need a sql server query to  fetch in separate colum…

  sathishkm

  8 replies

  1 year, 10 months ago

  By: Jeff Moden