SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Linked Server Query incorrectly returns 0 rows on SSMS

  Hi all, Need help to figure ut why the remote query I execute on the server return 0 rows , but the…

  saphiros

  2 replies

  6 years, 12 months ago

  By: jonas.gunnarsson 52434

• Proverbial Tree Barking

  Hi All, I'm just after a pointer really. I've had an idea. I want to prouduce a database. One where…

  maverickuk82

  1 replies

  6 years, 12 months ago

  By: maverickuk82

• Merge/Split/Switch partition's affect on indexes?

  Hi All, Currently I have a partitioned table that is partitioned by date.  On this table, I have 3 …

  SystemlordAnubis

  11 replies

  7 years ago

  By: SystemlordAnubis

• TSQL query not working properly against Full Text Index

  Hi, I've been having this issue for quite some time and need some help to understand it. I am not s…

  SQLMantra

  5 replies

  7 years ago

  By: Sue_H

• Date Calendar - Current Qtr

  Hi, I have a Date calendar table which has a range of dates between 01/01/2000 to 31/12/2050. It cu…

  SQL_Kills

  10 replies

  7 years ago

  By: nigel.

• Table type

  I just want to validate my use of a custom type. I'm doing a query on that I need to pass an unknow…

  Admingod

  4 replies

  7 years ago

  By: jonas.gunnarsson 52434

• SQL lookup tables

  Hello, I am very new to SQL and would really appreciate some help.   I am using Microsoft SQL …

  Jevans

  2 replies

  7 years ago

  By: Jevans

• What is the best way to test data type conversions?

  Is there a way where I can use a debugger to see the value of a variable at each execution step? Is…

  michael.leach2015

  5 replies

  7 years ago

  By: michael.leach2015

• Finding the starting ID in log table

  Thanks if you can help. A logged process starts and then perform additional actions. Then the proce…

  Chrissy321

  1 replies

  7 years ago

  By: DesNorton

• Is there a better (shorter) way to right this short query?

  Hi, I have been given a piece of SQL to use to create a dimension table, however the SQL is referen…

  chocthree

  7 replies

  7 years ago

  By: jcelko212 32090

• Problem using @@DBTS between the primary and secondary in an AG

  We have an ETL process set up that uses rowversion and had an issue last week because the ETL proce…

  sherrerk

  2 replies

  7 years ago

  By: sherrerk

• sql server 2017 INSERT and UPDATE lock database

  Hello friends,i have a database with table of millions of records.I update my database with INSERT …

  emanuele 8962

  7 replies

  7 years ago

  By: fahey.jonathan

• How to/ideas? - Unit/performance testing

  Hi, I wondered if someone could offer some insight in to methods of testing database releases, name…

  NicHopper

  1 replies

  7 years ago

  By: david.Parsons 36778

• Use constraints to determine to execute either an insert or an update (re-post)

  Hello, I would like to use either a Unique Constrain or Check Constrain to determine if an insert s…

  raf.figueroa

  9 replies

  7 years ago

  By: Sergiy

• NOT IN with OpenRowSet

  Hi, I am trying to use a text file to exclude a list of things.  Thus I was hoping to use OpenRowSe…

  TJ_T

  17 replies

  7 years ago

  By: Jeff Moden