Viewing 15 posts - 1 through 15 (of 62 total)
Thx Brian, like you we believe that a func can return only 1 value or only one resultset.
also a proc cant return a table variable.
so are you suggesting that the...
May 2, 2024 at 10:52 am
thx Martin
Quick question, what's the problem using one server for all databases, where you set Max DOP for example to 2, this way a query will use paralelismus at max...
April 17, 2024 at 5:57 pm
thx Brian. That is useful info. I'm going to price it.
Phil, because our ssis architecture is somewhat cookie cutter for each erp (netsuite will be one of those erps), i'm...
April 12, 2024 at 6:35 pm
thx Phil. I had a meeting today with one of our cloud architects. Somehow our company (maybe using something called MS Graph) has a list of their api's in DEVOPS...
April 12, 2024 at 3:48 pm
thx, just the type of feedback i was looking for. i've never seen an ssrs report ingest excel. But i am very familiar with pbi ingesting excel. do you have...
April 12, 2024 at 12:47 pm
appreciated jeffrey but i suspect we are going to make the wrong decision if i dont look closer at this with some of your info at my disposal. i'm trusting...
April 8, 2024 at 7:34 pm
yes, i usually consider that road but am very careful not to create a new "cottage industry". By that I mean a whole new process whereby people have to take...
April 8, 2024 at 4:26 pm
thx scott is a checkpoint equivalent "result wise" to setting a log as reusable? i was surprised to hear i needed to set a log as reusable. but i have...
April 8, 2024 at 4:14 pm
no problem frederico. your idea about partitioning jumped into my head early on also. i have to read jeff's link before i do anything.
April 8, 2024 at 4:09 pm
thx frederico, not sure but i think our recovery simple choice addresses your point about logging mode. and yes i've seen backups run in seconds on this 105 gig db.
But...
April 8, 2024 at 12:57 pm
thx Jeff, so how do we mark the log reusable after the 12th erp is done? I wasnt clear in my post but should have stated that no one erp...
April 7, 2024 at 7:26 pm
thx frederico, i tried to explain that one erp is always a full, the other 11 are generally (more than 99%) done with an incremental algorithm.
April 7, 2024 at 6:57 pm
thx phil. no i looked closely at the view definition too. but that is when / after all the records are committed.
when i strip out all the left joins, what...
April 7, 2024 at 12:57 pm
thx Brian, that makes a lot of sense and we already nixed the idea of a laptop for other reasons. But your reasons are better than ours. We started talking...
April 4, 2024 at 12:30 pm
thanks phil, do you mean all on the same single pc? That's the kind of feedback i was hoping for. That way no one instance of sql could interfere with...
April 2, 2024 at 4:37 pm
Viewing 15 posts - 1 through 15 (of 62 total)