Viewing 15 posts - 6,496 through 6,510 (of 59,070 total)
What is your current Index Rebuild strategy and how frequently and in what % the fragmentation is happening?
To Sergiy's point, asking about the % of Fragmentation is the first...
August 27, 2020 at 6:17 pm
tank you solve 🙂
I'm not quite sure how to read that... Does that mean that you already have a solution that solved the problem or that you need a...
August 27, 2020 at 5:25 pm
Ok... now I'm curious, Jason... Which "cloud" provider are you having to move to?
August 27, 2020 at 12:56 am
I agree with ilyaioffe, which means that the most correct answer is actually the XP_CmdShell answer which, by the way, IS also a supported answer.
What you have listed as a...
August 27, 2020 at 12:36 am
I'm of no help here. I just wanted to say "thanks" for the followups on your problem... it's bound to help someone in the future and that might even be...
August 27, 2020 at 12:12 am
Since you're importing from a spreadsheet, do you really need a VARCHAR(MAX) column? This question also has pertinence to your other post on the subject.
August 26, 2020 at 10:26 pm
How many rows are actually in this table? And, if you have that indexes, it could help if you posted the CREATE TABLE statement along with the CREATE INDEX statements. ...
August 26, 2020 at 10:23 pm
Ah, sorry, Jason. I should have known better just because it's you. And I saw the post from SQLSkills right at the top and made the sorry mistake of assuming...
August 26, 2020 at 10:14 pm
It seems to me some leaders incorrectly use Agile to rationalize skipping design.
And a whole lot more "SQL sins" like no documentation, little testing until it hits prod, nasty...
August 26, 2020 at 10:12 pm
I found plenty about it and what it is...
August 26, 2020 at 8:40 pm
thank you vary much 🙂
next time not lazy:)
😀
Sorry... my reference was about creating readily consumable data. You can see one way to do that in the article at the...
August 26, 2020 at 5:55 pm
Thank you for both of your answers.
To provide a bit more context: I am looking at someone who is an absolute expert in data modelling creating very efficient and...
August 26, 2020 at 5:24 pm
hi all,
i have the follwing table : 10 lines
i want to show only row after 30 second (should be paramter :)) between them. ( as summery of previous records)
on...
August 26, 2020 at 2:14 pm
For those are too lazy to copy paste for testing, added 2nd Colum for True False:
You should speak to the OP about the "lazy" thing. 😉
August 26, 2020 at 2:03 pm
p.s. And, no... this process doesn't use "SSDT", "SSIS", or any of the other 4 letter words in SQL Server. It's all done in T-SQL and it runs very quickly. ...
August 26, 2020 at 1:51 pm
Viewing 15 posts - 6,496 through 6,510 (of 59,070 total)