Forum Replies Created
Viewing 15 posts - 76 through 90 (of 3,544 total)
-
Reply To: SQL Full text query too slow
Personally I would concatenate the varchar columns into a single column and depending on how volatile the data is, either a computed column or a separate table and full text...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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 '...Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
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...
Far away is close at hand in the images of elsewhere.
Anon. -
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
I thought, baggy eyes, toothless grin and a double chin.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 76 through 90 (of 3,544 total)