Topics
Started by
Posts
Last post
Hey everyone! I have a SQL agent job that deletes data then inserts data into the same table hourly…
11 replies
Hello. We have inherited a system and some code and this has been flagged as a performance issue. I…
13 replies
Hi, Our DB vendor is now implementing a new FK. This new FK is not going in due to duplicates - The…
8 replies
I have a business requirement to produce a running total, but with a twist ... If the running total…
14 replies
I need to send a copy of this to our customer but do not want to send all of the data so I need to …
2 replies
So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string splitting functions …
3 replies
Hi All, been a while since I posted. Facing weird calculation, I cant wrap my head around on how to…
7 replies
I currently have multiple databases, many databases represent a single customer, but a couple repre…
5 replies
Hey all, Been a while since I posted here. Recently encountered an odd problem. In the below code, …
3 replies
By: Ed B
I have a poorly performing proc, that is called heavily, and is taking around 4 seconds to complete…
2 replies
Hi I need to anonymize some of our members for an outward facing demo web site. Long ugly story, bu…
15 replies
Hi ALL I need help with the following query. declare @T table ( ID int identity , PAX_CNT INT , PAX…
2 replies
hi, IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='abc' AND COLUMN_NAME…
10 replies
Hello. I am a bit confused and not sure what terms to use to Google. I have a transaction that over…
9 replies
By: SteveOC
I have a database with two versions - a production version and a development version. As I fix and …
3 replies
Viewing 15 topics - 1 through 15 (of 3,039 total)
You must be logged in to create new topics.