To Sergiy's point, asking about the % of Fragmentation is the first...

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...

Ok... now I'm curious, Jason... Which "cloud" provider are you having to move to?

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...

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...

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.

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. ...

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...

And a whole lot more "SQL sins" like no documentation, little testing until it hits prod, nasty...

I found plenty about it and what it is...

https://www.google.com/search?q=XE_SERVICES_RWLOCK

😀

Sorry... my reference was about creating readily consumable data.  You can see one way to do that in the article at the...

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...

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...

You should speak to the OP about the "lazy" thing. 😉

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. ...