Forum Replies Created
Viewing 15 posts - 76 through 90 (of 3,543 total)
-
Reply To: SQL Full text query too slow
Must admit I've not come across a problem like this, but then I do not have large catalogs.
However one problem I have found with performance is trying to do all...
-
Reply To: Are the posted questions getting worse?
Thom A wrote:Unfortunately, it seems it isn't DST aware for all timezones, as Britain doesn't have a timezone listed, but I assume it suggest we use Greenwich Standard Time.Greenwich Standard Time...
-
Reply To: Validate field in STaging before loading
Jeff Moden wrote:No. You're not off beam on that at all. When I do imports, it's ALWAYS to a staging table of sorts for exactly the reason you state. I'll either...
-
Reply To: How to execute a Main-Sub report multiple times in SSRS 2017
You should be able to do this by utilising a tablix and putting the sub reports in separate rows of the repeating group and put the main report in the...
-
Reply To: Can't update status to match characters in case of signature key value is stars?
May be something like this.
(Search this site for DelimitedSplit8K id you do not already have it)
SELECTi.[Signature Key],i.[Group Id],i.Portion,
CASE WHEN i.Portion LIKE REPLACE(k.Item,'*','_') THEN '' ELSE 'Not '... -
Reply To: Are the posted questions getting worse?
david.edwards 76768 wrote:I'm somewhat starved of mentors and peers being the only person at my firm responsible for "all things database" (and reporting), Sole and Accidental DBA, while also being backstop...
-
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:If you are interested, I'll ping you a draft of the writeup, mind you that this the first draft so few bits are missing, very interested to see your...
-
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:Now we are talking! Are you willing to share the library? Done extensive work on the subject and always interested in exploring alternatives.
😎
It is a .NET VB class library...
-
Reply To: Are the posted questions getting worse?
Phil Parkin wrote:I must have explained that issue (opening CSV in Excel rogers the underlying data) more than a thousand times.
Access solves the problem, but how many accountants use Access?
Was that...
-
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
I thought, baggy eyes, toothless grin and a double chin.
-
Reply To: How to remove quote marks using SSIS and a little C#
Jeff Moden wrote:Yes, you still need to deliberately get rid of the first character in the first column and the last character in the last column (because they're quotes) but that's...
Viewing 15 posts - 76 through 90 (of 3,543 total)