I'm using sql statements to query data from multiple tables and exporting them into csv files, then…
9 months ago
I have an unusual scenario. A developer sent me some code that has a BEGIN / COMMIT and a roll…
By: Brandie Tarvin
I have a quick Question
Have a table called subtable with column Year(YYYY) format nu…
9 months, 2 weeks ago
By: Zond Sita
if OBJECT_ID ('tempdb..#tmp') is not null drop table #tmp;
create table #tmp (TrId INT,SellPric…
We don't have baselines in our env. I mean, no monitoring tool. We use sp_whoisactive every…
I want to start extended session via job and want it to stop automatically after 2 hours.
9 months, 3 weeks ago
Which DMV will tell me the transaction mode of a SPID?
I did check MSDN but couldn't get th…
in one of our environment , we are using a pre-built software and we have developed our own Api…
could someone go through the deadlock and process flow below and advise of what I may be…
when begin transaction and update holds lock on row and no other can update if unless committe…
9 months, 4 weeks ago
By: Jo Pattyn
To meet these requirements below, I came up with this SQL. Please evaluate my code if it produces t…
10 months ago
I have 2 databases 1)staging 2)prod. I am using following query to get index stats for rebuild…
10 months, 1 week ago
By: Jeff Moden
Please assist. I am getting the above error:
CREATE VIEW DailyAccountBalances AS
I want to use these values in the parameter for further usese, but it's giving me an erro…
Please see my DDL.
I would like to create:
a) Dimensional table that tracks Primary Accounts’ gr…
Viewing 15 topics - 31 through 45 (of 1,503 total)
You must be logged in to create new topics.