SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• The object name contains more than the maximum number of 2

  I am trying to execute an alter command on a linked server. I am getting the error "The object nam…

  tpiazza

  4 replies

  7 years ago

  By: ScottPletcher

• Case in Where

  Hello community, I have build this query and what i want is : 1. When fo.dprocesso not null then re…

  luissantos

  2 replies

  7 years ago

  By: luissantos

• Difference in value from yesterday

  I have a small table which collects disk size information and insert the data into a table. Now I s…

  LearningDBA

  2 replies

  7 years ago

  By: HandyD

• Improve performance of a query by milliseconds. Should I loop the query to extrapolate the stats ?

  Hi, I am a query that takes 0.26 seconds to complete in average. The challenge is the process execu…

  Gamleur84

  8 replies

  7 years ago

  By: Grant Fritchey

• Help needed in a query

  Hello All,I need help in getting the info like   Name User IDHow many days until acc…

  DBA_007

  6 replies

  7 years ago

  By: Chris Hurlbut

• Horrible performance using sys.dm_os_performance_counters

  Hi,We are in process of buying a third party application (NewRelic) that does a query the SQL 2016 …

  PatLap

  14 replies

  7 years ago

  By: Jeff Moden

• Substring from string

  Hello,I'm trying to get a substring (in this case  R8241112T) from a string (@var) first by re…

  lukaszpiech

  2 replies

  7 years ago

  By: lukaszpiech

• Problem using CTE

  Can anyone explain why, when selecting data into a CTE and then using the results in the CTE to fur…

  wegrob

  9 replies

  7 years ago

  By: below86

• More efficient delete sql

  Hi, thanks for your help in advance. Is there a way to make this query faster DELETE FROM dbo.polyg…

  olibbhq

  6 replies

  7 years ago

  By: olibbhq

• How to replace NOT IN in WHERE clause

  --SQLselect distinct s.subscription_id,    s.subscription_nm    from…

  archana.mandiriappan

  3 replies

  7 years ago

  By: jonathan.crawford

• A question about the EXISTS operator

  In the ye olde AdventureWorks2016 database if I run the following query it returns Exists, even tho…

  ReamerXXVI

  2 replies

  7 years ago

  By: ChrisM@Work

• Service Broker Question

  I'm trying to push data from one server to another. In order to that, I need to create a route. On …

  SQL_Surfer

  1 replies

  7 years ago

  By: Eddie Wuerch

• T-SQL Query To Find Memory Usage Per Resource Pool Per Database

  Hi, I have just started using Resource governor in SQL Server 2016 and my manager has asked me to w…

  gs1975

  3 replies

  7 years ago

  By: gs1975

• Best Practice while writing Insert statement in Procedures

  In our application we have lots of procedures and most of them use insert and update statement. In …

  devaji123

  1 replies

  7 years ago

  By: Jeff Moden

• Josn Vs Table Varable prarameter

  In one of our scenario from UI we are passing a list of values previously we used to use table valu…

  devaji123

  1 replies

  7 years ago

  By: pietlinden