Viewing 15 posts - 6,181 through 6,195 (of 59,070 total)
We had the switch upgrade right before the backup started taking long time to finish.
I'm thinking that you've just identified your problem with the backups. 😉
Have the check the...
October 21, 2020 at 9:48 pm
No, the backup is not broken into several files, we can try to do that.
As you said, you didn't have this problem just a little bit ago. I'm with...
October 21, 2020 at 7:35 pm
here is a nice discussion about it all "Mixed Extents: 02 - Indexing and Stats Maintenance"
I saw that. It's a shame that they didn't get into the Index...
October 21, 2020 at 6:43 pm
I ran the update stats on a table by creating the indexes, when i checked after executing the update stats the query performance is degraded , may i know...
October 20, 2020 at 3:47 pm
On the subject of "performance", trailing and mid-string lookups are terrible. If you have to do this more than once, consider another method especially if the data is relatively static. ...
October 20, 2020 at 2:19 pm
The article says that "When a CSV file longer than that is opened, the bottom rows get cut off and are no longer displayed."
Did Excel provide any warning that...
October 19, 2020 at 7:15 pm
I'll file a note to list allowed types. I think it's a short list, so this shouldn't be hard.
It also seems strange to me that a good number of...
October 19, 2020 at 7:09 pm
Any chance you could include all of the code from the variable (as code, not a graphic, please) that gets executed so I can have a look?
October 19, 2020 at 5:57 pm
8<
I also have been known to use xp_CmdShell to work some serious magic for things like file prep (especially on CSVs), file handling (find it, use it, move...
October 19, 2020 at 5:38 pm
Just to be sure, Jacob... I really like your solution (especially since I've tested the bejeezus out of it in the area of functionality) because of the integer math, lack...
October 18, 2020 at 5:11 pm
To Frederico's good point, please see the following article for an introduction to "Tally Tables" (also known as "Numbers" tables). Keep in mind that it's only an introduction and do...
October 18, 2020 at 4:58 pm
I use Google...
https://weblogs.sqlteam.com/peterl/2009/07/12/how-to-calculate-the-number-of-weekdays-for-any-given/
That, however, doesn't count the number of weekend days as the OP requested. It wouldn't, however, provide much difficultly to the OP to realize that if you...
October 17, 2020 at 7:35 pm
Jeff,
Thanks for taking a look.
The problem is indeed one of the range (as Jeffrey also pointed out while I typed this up). The math trick won't work once negative...
October 17, 2020 at 7:07 pm
He he, look what the cat dragged in!
😎
More than two years on and it's still interesting? Feels like eating last week's take out pizza.
Heh... I've done that. It does...
October 17, 2020 at 4:16 pm
It's late in the day, and I'm below my quota of coffee (all too common these days, I really need to rekindle my coffee habit), but here's another, fairly...
October 17, 2020 at 3:37 pm
Viewing 15 posts - 6,181 through 6,195 (of 59,070 total)