Topics
Started by
Posts
Last post
Hi All, Is there any query using which we can tell what is the table which is changing the most or …
3 replies
Hi All, Getting below error when running a stored proc? The stored proc was working fine for a whil…
1 replies
Hi, Need to convert a hexadecimal to decimal/numeric with 20 digits, but due to bigint limitation i…
13 replies
I'm using sql statements to query data from multiple tables and exporting them into csv files, then…
5 replies
All, I have an unusual scenario. A developer sent me some code that has a BEGIN / COMMIT and a roll…
9 replies
Good Morning, I have a quick Question Have a table called subtable with column Year(YYYY) format nu…
2 replies
Hi, if OBJECT_ID ('tempdb..#tmp') is not null drop table #tmp; create table #tmp (TrId INT,SellPric…
6 replies
Hi All, We don't have baselines in our env. I mean, no monitoring tool. We use sp_whoisactive every…
2 replies
Hi All, I want to start extended session via job and want it to stop automatically after 2 hours. H…
3 replies
Hi All, Which DMV will tell me the transaction mode of a SPID? I did check MSDN but couldn't get th…
2 replies
Hi, in one of our environment , we are using a pre-built software and we have developed our own Api…
1 replies
Hi, could someone go through the deadlock and process flow below and advise of what I may be…
1 replies
Hi , when begin transaction and update holds lock on row and no other can update if unless committe…
2 replies
To meet these requirements below, I came up with this SQL. Please evaluate my code if it produces t…
12 replies
Hi , I have 2 databases 1)staging 2)prod. I am using following query to get index stats for rebuild…
6 replies
Viewing 15 topics - 61 through 75 (of 1,532 total)
You must be logged in to create new topics.