Em Andamento

MS SQL Query optimizing

Hi

I’m looking for an MS SQL Expert to help us with the following SQL Query. The query is very slow due to the two subselects. Can you optimized the query to perform better.

CREATE VIEW V_DEVICE_CAPABILITY_FALLBACK_VENDOR_MODEL AS

SELECT (

SELECT TOP 1 DEVICE_VENDOR

FROM V_DEVICE_CAPABILITY_FALLBACK a

WHERE [url removed, login to view] = [url removed, login to view]

AND a.DEVICE_VENDOR IS NOT NULL

ORDER BY [url removed, login to view] ASC

) AS DEVICE_VENDOR_FALLBACK, (

SELECT TOP 1 DEVICE_MODEL

FROM V_DEVICE_CAPABILITY_FALLBACK b

WHERE [url removed, login to view] = [url removed, login to view]

AND b.DEVICE_MODEL IS NOT NULL

ORDER BY [url removed, login to view] ASC

) AS DEVICE_MODEL_FALLBACK, c.*

FROM DEVICE_CAPABILITY c

Please let me know if you can help me.

Habilidades: Instalação de Script, Administrador do Sistema, Área de trabalho do Windows

Ver mais: optimize mssql query, top query, n query, slow select top query mssql, mssql find slow queries, mssql logging slow query, sql, sql script , SQL Query, sql c, null, MS SQL, C# SQL, looking sql, sql create script, sql select select, sql select order, sql select, query query, sql query help, sql select script, windows expert, query sql windows, windows create script, select select

Acerca do Empregador:
( 5 comentários ) Copenhagen, Denmark

ID do Projeto: #170659

2 freelancers estão ofertando em média $30 para este trabalho

SmartGuru

Hi, I can help you with this query.. Kind regards.

$30 USD em 1 dia
(2 Comentários)
3.0
fedestabile

I have worked on this sort of queries before and I can provide a solution. For more info, please see PMB.

$30 USD in 0 dias
(2 Comentários)
2.0