Topics
Started by
Posts
Last post
Tables have identical structure but different indexes (except) PK and different stats. all DTA…
2 replies
I have query which is filling TEMPDB I need suggestion how to modify this query to which can minimi…
3 replies
Okay I can easily see how to update a table field after an Insert but do I use the system Inserted …
4 replies
I have a very large table and I'm looking to do a cleanup based upon a non-keyed field. This table …
21 replies
Hello I need help identifying all records that have consecutive hours (time in order) of greater th…
5 replies
I have 2 tables which I need to cleanup old costkeys, based upon a driver table. The driver table i…
5 replies
I am using the following script to import data from a json file. This file contains special charact…
4 replies
By: don075
Hi, I have a set of data (for instance sine wave) and I need to count, how many times have value re…
2 replies
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016, but do not have idea for the tar…
1 replies
I am using the following sql to convert rows into columns for each pid, intdate. This works fine wh…
3 replies
I need some help to optimize this query as it runs in many threads in an over night, and it pegs CP…
13 replies
How to merge two tables with unlike fields. I have two table with one unlike field that I need to s…
3 replies
Hi, yesterday I had to update several rows of a table. The rows for update where selected by a sele…
11 replies
I have a table like below ID Ident source val opendate closedate IsActive ------------------…
6 replies
By: Ed B
I have a couple of databases One would be regarded as the source and another as the destinat…
2 replies
By: DamianC
Viewing 15 topics - 1 through 15 (of 3,062 total)
You must be logged in to create new topics.