Topics
Started by
Posts
Last post
Hi Community, I have created the following table CREATE TABLE HMCTS.MDM_DEV.dimDate ( DATE_KEY DA…
7 replies
I have 2 tables the first one holds the dbwait information(locks), and the second table holds the d…
6 replies
Hi, I am looking to calculate some data. We have orders dropping every day, and I need to calculate…
3 replies
Hello, I have a bunch of stored procs that I'd like to execute all at once, insert their results i…
6 replies
Hello, While running the above query thru SSMS we see odd behavior with the time it takes to run th…
12 replies
I'm back again with more dumb questions. This time I am dealing with refactoring a single select wi…
4 replies
Getting a lot of raw, non-sproc queries run which is causing plan cache bloat, any ways to prove th…
4 replies
Blitz Cache reveals that the 50 most expensive queries run against the production servers are raw s…
3 replies
Hello, I have inherited a process that utilises an SSIS package and related stored procs that creat…
4 replies
Hello Community, The attached SQL Script (Procedure) is compiled / written for Azure SQL DW. As suc…
2 replies
Hi everyone, I am running into a \n issue and it seems like none of the solutions I found online h…
1 replies
Hello friends. I have a hierarchy table like this: Month empEntityID empID empName mgrID empEntityI…
10 replies
Hi guys, I'm quite new to T-SQL and honestly started to take online classes just a week ago. I've …
2 replies
How could I turn this into a total by Entity rather that just having a line total by day. I would l…
7 replies
Hi all. I have also posted this on DBA Stack Exchange, but I'm posting here because this community …
8 replies
Viewing 15 topics - 526 through 540 (of 3,091 total)
You must be logged in to create new topics.