SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Tracking of Accounts data and Stored procedures

  Please find my sample db here:https://drive.google.com/file/d/1_8JWxOrAdKEz1dxKITnqW3HZr1GTBgB9/vie…

  yrstruly

  22 replies

  5 months, 2 weeks ago

  By: Thom A

• Getting every day data into "AccountCommissionHistory"

  Please find sample data in bacpac format. I would like my data to be loaded daily with a start and …

  yrstruly

  16 replies

  5 months, 2 weeks ago

  By: frederico_fonseca

• Weird problem with substring function over 'text' column

  In the query below, I get the Invalid length parameter passed to the LEFT or SUBSTRING function err…

  _simon_

  2 replies

  5 months, 4 weeks ago

  By: ScottPletcher

• SQL Agent Job schedule

  Hi All, Want to know what are the SQL Agent Jobs scheduled for today at what time they are going to…

  vsamantha35

  2 replies

  6 months, 1 week ago

  By: Michael L John

• Tsql query to show currently running sql agent jobs

  Hi All, Using Tsql query I want to know currently running sql agent jobs and how long they have bee…

  vsamantha35

  4 replies

  6 months, 1 week ago

  By: ScottPletcher

• how to identify table(s) changing quite often

  Hi All, Is there any query using which we can tell what is the table which is changing the most or …

  vsamantha35

  3 replies

  6 months, 1 week ago

  By: Ant-Green

• transaction related error.

  Hi All, Getting below error when running a stored proc? The stored proc was working fine for a whil…

  vsamantha35

  1 replies

  6 months, 1 week ago

  By: Ant-Green

• Hexa 2 decimal 20 digits

  Hi, Need to convert a hexadecimal to decimal/numeric with 20 digits, but due to bigint limitation i…

  ricardocalado

  13 replies

  6 months, 2 weeks ago

  By: Jeff Moden

• 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

  6 months, 3 weeks 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

  6 months, 3 weeks 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

  7 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

  7 months, 1 week 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

  7 months, 1 week 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

  7 months, 1 week 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

  7 months, 1 week ago

  By: vsamantha35