Viewing 15 posts - 3,406 through 3,420 (of 59,067 total)
Heh... ok... here's another thought. If you don't think you own the data (not like the guy in the story Steve related), let something happen to it and find out...
May 25, 2022 at 3:09 am
Maybe a bit more directly....
https://www.google.com/search?q=how+to+find+queries+taking+the+most+memory+in+sql+server
May 25, 2022 at 3:03 am
I've not had to do such a thing because I've never had the same problem. If I did, I'd probably start with the following search...
May 25, 2022 at 3:01 am
As an alternative this could possibly/probably be better handled by SSIS than what you describe as your current solution.
Instead of writing to a temp table, just pass the data...
May 25, 2022 at 2:56 am
Well....there's always a way. The way you are looking for here is exporting it as a bacpac and then importing it into the 2016 server. It's not nearly as...
May 25, 2022 at 2:54 am
The free edition of SQL Server is called the "Developers Edition" and it has the same capabilities as the "Enterprise Edition".
https://www.microsoft.com/en-us/sql-server/sql-server-downloads?SilentAuth=1&wa=wsignin1.0
Be advised the download is for 2019. I did a...
May 24, 2022 at 5:46 pm
Hello Jeff, thank you for you explanation, i absolutely agree with you, but situation i have is that on separate disk for log files i have physically limited space...
May 24, 2022 at 5:27 pm
An even easier way for the future might be to make an update-able partitioned view that would auto-magically evaluate the data from the temp table and auto-magically write it to...
May 24, 2022 at 5:21 pm
What would be better would be to make it so that groups of rows in the temp table that will be written to the same tables are handled all at...
May 24, 2022 at 5:19 pm
Just ran across this article... I agree! Very nicely done, especially with the page-level proofs!
As a bit of a sidebar, the reason why such a small change caused the Clustered...
May 24, 2022 at 5:11 pm
You should also post which browser you're using when reporting such problems.
May 23, 2022 at 8:22 pm
Amazing... you had to write all of that for a pipeline? Guess I'm glad I don't have to work with such a thing.
Since I don't know about pipelines, would it...
May 23, 2022 at 8:20 pm
Hi Kathi,
Congratulations on the new job and thank you for what you've done for this community as a member of Redgate and long before that. I was thrilled to have...
May 23, 2022 at 8:08 pm
Hi and welcome aboard. That's actually a really pertinent post for this 11 year old post and that's why I like this site so much. No "Comments are Closed" here!...
May 23, 2022 at 8:06 pm
I don't know much about PowerBI but the last answer at the following link appears to be the ticket. You'll need to change all the reports once but then you'll...
May 23, 2022 at 8:00 pm
Viewing 15 posts - 3,406 through 3,420 (of 59,067 total)