Viewing 15 posts - 2,431 through 2,445 (of 59,067 total)
I'm pretty sure this a spam post. The exact same question was posted on Reddit a month ago. It's looks like the ol' one question from login and answer with...
November 16, 2022 at 8:47 pm
Now this is a massive jump from a local instance running on my laptop (core i5, 8 gb RAM) to a database on Azure free trial
Welcome to the world...
November 16, 2022 at 8:38 pm
An Azure Database with 10 DTU's is the second lowest size available, up the size and try again.
He's using the "free trial" version... can you actually up the DTUs...
November 16, 2022 at 8:36 pm
Will the real Robert Sterbal please stand up?
November 16, 2022 at 7:45 pm
Greetings and welcome aboard.
Just to "grease you up" for asking questions, I recommend you read and understand the article at the first link in my signature line below. If you...
November 16, 2022 at 7:16 pm
Thanks.
For the first time in a long time I actually have a database that needs indexing. I imported about 9 million voter records from the Pennsylvania Full Voter Export.
To...
November 16, 2022 at 4:52 pm
So, what happens if someone needs a restore from the previous day 30 seconds after you drop the old backup?
It sounds to me like you need to keep both the...
November 16, 2022 at 4:49 pm
Because if you care about performance, you want to avoid IO. Calculating "next wednesday" is about 150 times faster than looking it up (using ta table) on just a...
November 15, 2022 at 9:04 pm
And don't forget to make "compression" the default... especially when using a NAS.
November 15, 2022 at 6:02 pm
Ok... this is the 3rd post on the same subject. One of your others provided some output, one of the others provided some input, and this one provides the code...
November 15, 2022 at 4:57 pm
You'll find that very few people are going to go read the article you provided a link to. You also haven't posted the full code you're using . You've also...
November 15, 2022 at 4:55 pm
I see no difference between the original data form and what you've requested. other than some column names in the desired output. We don't actually know what the column names...
November 15, 2022 at 4:49 pm
Saving either the full backups or the log file backups to the same server as the database is one of the worst ideas for backups. There's no chance at restores...
November 15, 2022 at 4:43 pm
thanks Both i have now sorted with calendar table.
My advice there is "Watch the Reads".
It would also be nice if you posted the code you ended up using for...
November 15, 2022 at 4:32 pm
Viewing 15 posts - 2,431 through 2,445 (of 59,067 total)