SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Columnstore indexes and compatibility

  Hi I know, back in the day, the CSIs on SQL 2012 stopped the table being updated/inserted etc I kno…

  peter.cox

  5 replies

  5 years, 6 months ago

  By: Jeff Moden

• Need to select where count more than 1 in criteria one and in that more than 1 .

  Hi, I need to make a select and display of ITEMID, TRANSID and POSRECORDID, where TRANSID count is …

  sk 939

  12 replies

  5 years, 6 months ago

  By: sk 939

• Sum of Column When Values Different

  Dear Forum: I have a Column1 that has values from 1 - 9.  I need to Sum the values of this column f…

  AMCity

  2 replies

  5 years, 6 months ago

  By: ScottPletcher

• Optimize Cursor

  I inherited this script that has a cursor and I know this query can be optimized by not using a cur…

  GrassHopper

  11 replies

  5 years, 6 months ago

  By: ScottPletcher

• Recursive Query for Table1 and Table3

  I have 3 tables,  I need recursive query Table3 is recursive join with Table1 I have attached the d…

  s.ravisankar

  3 replies

  5 years, 6 months ago

  By: Mr. Brian Gale

• Convert Varchar to Int and SUM

  Hi, need a request...it's possible to convert dbo.RE80_MOVSCHPUNTI.RE80_VALORE this table from nvar…

  ibrahimovich87

  13 replies

  5 years, 6 months ago

  By: Ant-Green

• Surprised that Row_Number() has better performance than IDENTITY

  I was doing some testing to see if it's more efficient to use an identity column or to use ROW_NUMB…

  souLTower

  6 replies

  5 years, 6 months ago

  By: souLTower

• Distributing a value among the rows in Sql Server

  Dear All, I have a requirement in which i need to distribute a value among the rows  For Eg: i ha…

  bsushu

  4 replies

  5 years, 6 months ago

  By: bsushu

• Changing column datatype performance question

  Hello All, I have a table with hundreds of millions of rows. One particular column (varchar(250)) h…

  C-M-A

  5 replies

  5 years, 7 months ago

  By: MVDBA (Mike Vessey)

• Dimensional Database \"examples\"

  I have read many things online regarding dimensional vs relational databases. I under that its less…

  wallywizard

  2 replies

  5 years, 7 months ago

  By: wallywizard

• Extract part of string

  hi, How can I extract part of this string declare @string varchar(1024) set @string = 'Total # of b…

  Mad-Dog

  7 replies

  5 years, 7 months ago

  By: ScottPletcher

• query to check the duplicates

  i have a table, where a column ABC holds value 123 , based on this column ABC , i want to find how …

  mcfarlandparkway

  2 replies

  5 years, 7 months ago

  By: Lynn Pettis

• Name columns for a pivot

  I want to put this comment column in 1 row.  I have a pivot that is working but I don't know how to…

  GrassHopper

  8 replies

  5 years, 7 months ago

  By: GrassHopper

• SQL server change table query not working as expected

  Hi, It looks like that a CHANGETABLE query for a particular table is not working correctly. I creat…

  chatsubrato

  1 replies

  5 years, 7 months ago

  By: chatsubrato

• Workaround for executing dynamic sql in function

  I'm trying to create a view which dynamically generates text from input parameters. But executing d…

  vpolasa

  1 replies

  5 years, 7 months ago

  By: Steve Collins