Viewing 15 posts - 691 through 705 (of 59,066 total)
Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.
Indexes may help (they can also add overhead to deletes as...
March 1, 2024 at 5:49 pm
I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.
Just adding my 2 cents... That...
February 28, 2024 at 2:54 am
this is super interesting. i didn't know that.
this begs the question....how do you decide on an appropriate index? is there a good resource you can suggest that goes over...
February 27, 2024 at 3:03 pm
does it make sense that an unindexed query is faster than an indexed one?
Oh yeah... and big time! There are many reasons why such a thing may happen. For...
February 25, 2024 at 10:01 pm
Your question is easy to ask and can take years to answer.
It sounds like you could stand a lesson on what an "Execution Plan" is. Please see the following link...
February 25, 2024 at 5:14 pm
I was running a SP and I got this. This is the first time I have ever received this. What does it mean? How do I fix it so...
February 25, 2024 at 4:48 pm
We have a rebate program where I need to calculate sales based on the date the customer joined the program. Ex: Customer A joins the program on October 5th,...
February 24, 2024 at 10:58 pm
This reply has been reported for inappropriate content.
Thanks for your kind reply, I got understanding about how it works now.
Do you have any information on how to create jobs for taking the full backup+ transaction backup...
February 24, 2024 at 10:27 pm
thank you everyone. What recommended settings for parallelism should I set SS to? Clearly the defaults are not recommended.
If you read the text in my post, I tell you.
February 24, 2024 at 5:11 am
Heh... and people wonder why data storage is exploding. The only good thing about it is that it has only half the tag bloat of XML but, lordy, what a...
February 24, 2024 at 5:03 am
Taking full backups does not backup the logfile over time. If you're in the SIMPLE recovery model, then the log file will be self truncating whether you take full backups...
February 24, 2024 at 4:57 am
Post withdrawn because I don't actually know much specifically about VEEAM and didn't want to provide any misleading info.
February 23, 2024 at 9:20 pm
The only correct answer is "It Depends". I recommend that you lookup what the abbreviations RPO and RTO are for starters. Also, find and read up on the Full, Differential,...
February 23, 2024 at 9:08 pm
I am a SS rookie. To me it seems like running a query in parallel whenever possible is a great idea b/c that way more work can be done...
February 23, 2024 at 8:58 pm
I had to create a Cursor to update the data in the table.
It would be interesting to know more about that. Usually, it's a serious mistake that can be...
February 23, 2024 at 1:48 am
Viewing 15 posts - 691 through 705 (of 59,066 total)