Topics
Started by
Posts
Last post
I have a function where I am trying to create syntax or data error conditions where I can create it…
9 replies
I'm trying to find the first occurrence of a specific incident during a given time period. An exam…
16 replies
I have 2 tables 1-Web_Orders Reference_No int Released int Data : Reference_No , Released 12…
10 replies
Hi all, I currently have an SSIS package that completes this task, however, it seems that the reque…
7 replies
Hello, I have data from two different sources - Source1 and Source2 - we have a dtsx packa…
14 replies
Hello, I have a function where I am passing 4 parameters FUNCTION [dbo].[Employee] (@…
1 replies
I've seen articles that say you shouldn't make the leading column in your index a BIT column. There…
6 replies
I was reading about these but wondered how they would help when 99% of your sql is ORM-generated? …
1 replies
Hi all, Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary ke…
15 replies
Hello, Can someone help me with script of finding transactions which are heavily using temdb space …
8 replies
We are experience deadlocks in a stored procedure. This procedure is doing a merge-operation within…
1 replies
Hmmm... OK, I can do this but only with some really expensive RBAR table operations, the script I'v…
25 replies
I have a few million records in a csv file. This has only one field which is a driver md5 ( eg. 0x0…
6 replies
I have a large number of yes/no columns for a table. Rather than creating a bit field for each, I'd…
40 replies
Hello, I have a scenario where I need to query the length of the string value given for each column…
3 replies
Viewing 15 topics - 1,486 through 1,500 (of 4,984 total)
You must be logged in to create new topics.