Topics
Started by
Posts
Last post
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
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(Transa…
26 replies
Dear All, I want to use these values in the parameter for further usese, but it's giving me an erro…
15 replies
Please see my DDL. I would like to create: a) Dimensional table that tracks Primary Accounts’ gr…
2 replies
Viewing 15 topics - 31 through 45 (of 1,503 total)
You must be logged in to create new topics.