SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Decrease a sum according to a dimension and according to a condition

  Hello all, First of all, thank you for dwelling on my problem. It is as follows: I want to decremen…

  samirca007

  1 replies

  6 years ago

  By: John Mitchell-245523

• Procedure Error - has no parameters and arguments were supplied

  DECLARE @FROMDATE SMALLDATETIME, @TODATE SMALLDATETIME, @SERVER_NAME NVARCHAR(150) SELECT a.Se…

  SQL Galaxy

  6 replies

  6 years ago

  By: pietlinden

• Standardized QA approaches for SQL Server

  Are there any frameworks out there to standardize, organize, or streamline the process of SQL QA te…

  imani_technology

  15 replies

  6 years ago

  By: Steve Jones - SSC Editor

• Roll multiple records into 1

  I'm trying to roll multiple records into one replacing null value. IF (SELECT OBJECT_ID('tempdb..#T…

  legeboka

  3 replies

  6 years ago

  By: michael.cole 47030

• count(*) locking a table?

  Hello, Why would select count(*) from a table encounter a lock? The table in question had initial b…

  datsun

  8 replies

  6 years ago

  By: Jeff Moden

• Inserting large data volumes into a table as fast as possible

  I'm doing development on large SCD2 tables (100M+ rows).  When I've fixed bugs and it's time to re-…

  Scott In Sydney

  9 replies

  6 years ago

  By: Jeff Moden

• How can this be said in English language?

  how can the meaning of this Where clause be explained in a human language? this query <does what…

  VoldemarG

  13 replies

  6 years ago

  By: VoldemarG

• Creation of clustered primary key only utilizes 1 CPU core

  Hi all, I am once again facing an interesting issue with multi-threading in SQL Server 2016. But fi…

  svenflock

  12 replies

  6 years ago

  By: svenflock

• Data Older than 12 month

  I have date which is stored in Integer how do I get data older than 12 months select * from table1 …

  Nita Reddy

  5 replies

  6 years ago

  By: John Mitchell-245523

• Migrating old data into new while keeping track of foreign keys

    Hello, I'm working on migrating some data from an old system into a newer one.  Their table …

  tarr94

  3 replies

  6 years ago

  By: tarr94

• Datatype differences when restoring a database from one server to the next

  Hello, I'm performing a backup/restore operation from a SQL Server 2012 database server to a SQL Se…

  PFlorenzano-641896

  7 replies

  6 years, 1 months ago

  By: MVDBA (Mike Vessey)

• SQL UniqueIdentifier question

  Hello, Our reporting database truncates and loads latest data during each import and generates Uniq…

  PSB

  4 replies

  6 years, 1 months ago

  By: MVDBA (Mike Vessey)

• Extract string from string that contains specific first two characters

  Hi I would like to extract from a full string the 'XX....' string. This specific string inst in the…

  d_martins

  6 replies

  6 years, 1 months ago

  By: d_martins

• Receiving error: The xml data type cannot be selected as DISTINCT because it...

  In the below query, the data returned in the query is in xml format.  I'm receiving an issue with d…

  Goalie35

  1 replies

  6 years, 1 months ago

  By: sterling3721

• using the same logic across multiple servers/dbs

  We have five different report servers, with 13 or so different databases, all with the same structu…

  jonathan.crawford

  2 replies

  6 years, 1 months ago

  By: Jeffrey Williams