SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Sql server data export to csv with 100,000 row filesize limit

  I'm using sql statements to query data from multiple tables and exporting them into csv files, then…

  FlyingSquid

  5 replies

  2 years, 2 months ago

  By: frederico_fonseca

• Transaction has no commit error

  All, I have an unusual scenario. A developer sent me some code that has a BEGIN / COMMIT and a roll…

  Brandie Tarvin

  9 replies

  2 years, 2 months ago

  By: Brandie Tarvin

• How to delete all records if sub query returns no records/values

  Good Morning, I have a quick Question Have a table called subtable with column Year(YYYY) format nu…

  Zond Sita

  2 replies

  2 years, 2 months ago

  By: Zond Sita

• sum 2 column by group

  Hi, if OBJECT_ID ('tempdb..#tmp') is not null drop table #tmp; create table #tmp (TrId INT,SellPric…

  thbaig

  6 replies

  2 years, 3 months ago

  By: thbaig

• How to query performance baseline

  Hi All, We don't have baselines in our env. I mean, no monitoring tool. We use sp_whoisactive every…

  vsamantha35

  2 replies

  2 years, 3 months ago

  By: ScottPletcher

• How to stop an XE after 2 hours automatically

  Hi All, I want to start extended session via job and want it to stop automatically after 2 hours. H…

  vsamantha35

  3 replies

  2 years, 3 months ago

  By: vsamantha35

• How to get the transaction mode of a spid.

  Hi All, Which DMV will tell me the transaction mode of a SPID? I did check MSDN but couldn't get th…

  vsamantha35

  2 replies

  2 years, 3 months ago

  By: vsamantha35

• workaround deadlocks

  Hi, in one of our environment , we are using a pre-built software and we have developed our own Api…

  thbaig

  1 replies

  2 years, 3 months ago

  By: thbaig

• Deadlock related to AutoCreateQPStats

  Hi,   could someone go through the deadlock and process flow below and advise of what I may be…

  frederico_fonseca

  1 replies

  2 years, 3 months ago

  By: frederico_fonseca

• begin tran vs WITH(ROWLOCK)

  Hi , when begin transaction and update holds lock on row and no other can update if unless committe…

  thbaig

  2 replies

  2 years, 3 months ago

  By: Jo Pattyn

• Dimensional table and Stored Procedure

  To meet these requirements below, I came up with this SQL. Please evaluate my code if it produces t…

  yrstruly

  12 replies

  2 years, 3 months ago

  By: yrstruly

• wrong index name

  Hi , I have 2 databases 1)staging 2)prod. I am using following query to get index stats for rebuild…

  thbaig

  6 replies

  2 years, 3 months ago

  By: Jeff Moden

• 'DATE' is not a recognized built-in function name

  Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(Transa…

  yrstruly

  26 replies

  2 years, 3 months ago

  By: yrstruly

• Multiple values in a parameter

  Dear All, I want to use these values in the parameter for further usese, but it's giving me an erro…

  vijay.verma2

  15 replies

  2 years, 3 months ago

  By: kaj

• View Or Stored Procedure

  Please see my DDL. I would like to create: a) Dimensional table that tracks Primary Accounts’ gr…

  yrstruly

  2 replies

  2 years, 3 months ago

  By: kaj