Viewing 15 posts - 1 through 15 (of 50 total)
Thanks for the replies.
Yes, we are working on alerts now.
In our case its a DW. Since we have multiple files that are currently set as limited in their growth, would...
June 5, 2019 at 8:34 pm
Thank you John.
June 3, 2019 at 4:39 pm
Thank you for your reply. This is very helpful.
January 14, 2019 at 12:12 pm
Thank you everyone for the input. It is very helpful.
October 30, 2016 at 8:39 pm
Thank you for your response
We are not sure yet whether to create it as clustered or not. This is something we will need to test with.
The deletes will happen...
October 21, 2016 at 11:34 pm
This worked great. Last Friday I was able to get this working on our system.
Thank you very much for your help.
February 1, 2016 at 5:04 pm
Thank you Jeff and thank you all very much, I will try this out tomorrow once I am back in the office.
January 24, 2016 at 8:12 pm
Thank you very much for your help. I appreciate it. Will this have the CTE recursion limit? For now The data sets are small, but we may get larger files.
January 24, 2016 at 12:39 am
Here is the set. There will be a begin and end date where we get the min(begin) and max(end) for each set. The cols will be ordered by the date...
January 22, 2016 at 7:24 pm
Hello, Thank you for the reply. It did work. This is the way I get the data in the file from a source system and need to properly insert it....
January 22, 2016 at 6:52 pm
I tried to paste the result to make it looks nice, but could not.
Here is the code for the dataset in question. Thanks for your help.
CREATE TABLE #testa
January 22, 2016 at 6:16 pm
Hello, Thanks for your reply.
This will group all the rows where A = 1 and B = Al to one row.
I only want to sum those up where they...
January 22, 2016 at 5:45 pm
It is not yet in place. Currently we have a service that does calculations to populate a table. The developer is asking if we could have a clr to...
December 22, 2015 at 5:21 pm
Thanks for your reply. Its just something I hope to get done with a query that I can reuse.
June 24, 2015 at 1:28 pm
I have this meta data just for research purpose that I received from an external system. It will not be used for any processing only research and it would be...
June 24, 2015 at 12:16 pm