GitHub

create_query_stat_log.sql

create table query_stat_log as select 1 as seq_num,now() as ts,* from query_stat_time; create index query_stat_log_seq_num_key on query_stat_log(seq_num); create index query_stat_log_ts_key on ...
GitHub

create_query_stat_cpu_time_view.sql

(SELECT greatest(1,sum(total_time)) AS t,greatest(1,sum(blk_read_time+blk_write_time)) as iot, greatest(1,sum(total_time-blk_read_time-blk_write_time)) as cput, sum ...
Microsoft

Query Store is enabled by default in SQL Server 2022

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...
crossjoin.co.uk

Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And Power BI

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...
crossjoin.co.uk

Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform

When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need: You can choose a table from the ...