Topics
Started by
Posts
Last post
Hi, I have address in a database table like this below and should got to -->: 1627W.PINNA --- …
9 replies
A BA recently ran this query and it got flagged by a capturing event for having > 130,000,000 lo…
1 replies
Hi, I know I've asked this before and got a good link , but can't figure out how to parse this XML …
3 replies
A developer asked me to run a query based on the following regex: ^[A-Z]{4}[0-9]{4} Which means tha…
4 replies
Hi Experts, We have a stored procedure to search users. In order to improve performance i have rebu…
8 replies
Hi Experts , I have a job which calls 100 of stored procedure. I have identified the tables which w…
2 replies
Hello, We set database log file size to 10GB, however database log file size is increased to 30 GB …
4 replies
Hello: I have a table that has the JobNo and Time1 Columns. EmpNo | JobNo | Ti…
11 replies
Hello, I have query contains both start and end date, i would like to filter out data based on two …
2 replies
Hi, The code below produces a file and the view used here has rows. The problem is that is generate…
11 replies
Hi, This post is related to an error I have discovered through the execution of a SSIS package th…
17 replies
My server have 2 instance: 1 version 2012 and 1 version 2017. Sometimes, instance sql 2012 (or sql …
2 replies
I am getting an Arithmetic Overflow error on this field, suggestions on a fix? CAST(ROUND(CA…
2 replies
hi there all, I am "playing around" with extended properties. I realized you can add them e. g. for…
4 replies
Hi, I am trying to get a Microsoft function to work with a variable. Below as you can see I am usin…
2 replies
Viewing 15 topics - 181 through 195 (of 4,984 total)
You must be logged in to create new topics.