SELECT sqltext.TEXT,
       req.session_id,
       req.status,
       req.command,
    ...

If you press F7 in SSMS you can select multiple tables and script the create for all of them, in one go.

You would then have to edit the script but...

Regarding @jonathan-ac-roberts 's test: you might want to include a GO between the two test queries. It might not make a difference, but I have found that quite...

Is it because you are looking up on a different column: ponum instead of po_num 

select po_num from poitem_all
where poitem_all.ponum not in (select po_num from preqitem)

It may or may not use the index. It depends on whether the optimiser thinks a full table scan will be more efficient than a seek with a key-lookup. An...

Well, I got to the first line of the article "Database UPPERCASE". I just wondered why you should have a database in uppercase? What if it consisted of 2 or...

The execution plan is recommending you create the following indexes:

CREATE INDEX IX_DM_NOTF_CHG_EVNT_1 ON [DNB_MDM_MON].[dbo].[DM_NOTF_CHG_EVNT_ATTR]
(
    [NOTF_CHG_EVNT]
)
INCLUDE
(
    [ELMNT_XPATH],
    [CHG_TYP_ID],
 ...

Change the query to this:

SELECT a.notf_chg_evnt AS notf_chg_evnt, 
       a.notf_btch_dtl_id AS notf_btch_dtl_id, 
       a.chg_detct_time AS...

45 minutes or more doesn't sound unreasonable for a table that big, but it also depends on the hardware, particularly the disk.

I use this to get active SQL statements.

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
CONCAT(req.total_elapsed_time/1000,' secs') elapsed_secs,
CONCAT(req.total_elapsed_time/1000/60,' mins') elapsed_mins
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) AS sqltext

It also gives the amount of CPU each statement...

Team

I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month

For Ex

<li...

having something that has a varchar passed to it that returns an nvarchar could be very bad for SARGability, if the column being compared afterwards is a varchar too...

Effectively. The usefulness of this function is not that of rapid execution, but the utility of the result. That is why there is a key that lists the results...

I'm not sure who or what marked the post by fgrodriguez as spam but I'm reposting it here so that the de-spaminator doesn't delete it.

I'll also state I'm a...

Likely because I mentioned you should have a varchar...