Viewing 15 posts - 736 through 750 (of 59,060 total)
Whether you are a Brent or a Jeff there are some pitfalls to watch out for to avoid burning yourself out.
Do others see you as a leg up or...
February 9, 2024 at 3:49 pm
We have a requirement to allow certain nominated users to execute 'jobs', where the definition of a job could be running a stored proc, or a PoSh script, or...
February 9, 2024 at 3:01 pm
Whoa... oh my... now there's a subject I didn't plan on reading about tonight. Other than stating that my levels of imposter syndrome just shot through the roof, I'm not...
February 9, 2024 at 3:13 am
Just curious why there appears to be a difference with c:\ and UNC.
It depends on where thing are at and where you're running the command from. For example, if...
February 8, 2024 at 6:20 pm
Heh... no... I agree... BBFAATT will never be able to compete with RBAR.
Also, sorry about your argument with set-based v.s. RBAR thing. I'd have to see what the two things...
February 8, 2024 at 5:41 am
And, sorry... I forgot that it's a bit new... "BBFAATT" is pronounced as "bee-bee-fat" and is my acronym for "Books, Blogs, Forums, Articles, AI, `Tubes, and Talks".
Heh.. and if sarcasm...
February 8, 2024 at 3:09 am
Fair point @jeff, but I think Ron and many other people who build DWs (or Power BI developers?) are more concerned with making the data, and potential calculations, as...
February 8, 2024 at 3:03 am
You may have never seen a good data warehouse. The advantages over standard reporting procedures are significant. Calculations such as YTD, PTYD and the comparisons of the two, rolling...
February 8, 2024 at 2:39 am
I've always had a bit of an issue with Data Warehouses and some of the techniques of using dimension tables... especially temporal dimension tables. While this is a very nicely...
February 8, 2024 at 12:26 am
If InfoSec already has an issue with replication because you are going from Prod to Non-Prod, then using backup/restore is also going to be an issue. Anything that allows...
February 7, 2024 at 8:13 pm
I have a SQL database of 2 TB running on production. There is a need to refresh this database on Q environment on a daily basis. Cannot implement SQL...
February 7, 2024 at 8:07 pm
Comparing yourself to an even bigger asshole doesn't lessen the fact that you're an asshole. In fact, it confirms just how much of an asshole you are. 😉
February 7, 2024 at 3:35 pm
Are you absolutely sure that the drive path and the UNC are actually pointing to the same directory? I HAVE seen people get confused on such issues before.
February 6, 2024 at 8:46 pm
Have you ever read a book on RDBMS?
You can explain things without being such an absolute condescending asshole, Joe!
February 6, 2024 at 1:40 pm
Note : its Partitioned on column - Col_ID ( have to modify the clustered index but just provided as is )
Crud... I missed that detail because I was only...
February 6, 2024 at 1:35 pm
Viewing 15 posts - 736 through 750 (of 59,060 total)