How to write a slow sql query?

Question

SQL

I am writing a test for the expediency of switching the site to asinki
EF6 .Net C # MsSQL
I need to somehow slow down the execution of the sql query.
So far, apart from multiplying tables without an index, nothing comes to mind, but I want something without memory consumption. you need to run about 500 sql queries at the same time

Answer 1

Maybe just cram sleep into the request :)? Like WAITFOR DELAY '00:00:01'
Dirty and should work

Answer 2

The easiest way is to write a script that will fill the database with random data as much as possible and select all records with all fields

Answer 3

write some query not relying on indexes with heap where , nesting and linking, and run everything in a loop

Answer 4

fulltext search in a string for a non-indexed column. Yes, make the line longer.