Not too sure whether I got your question correct, But anyways thought of asking this.

Did you try disabling the Non clustered index during the pruning process and then enabling it...

Its good to have clustered indexes, but depends what kind of column you choose. To keep it short, its better if the column picked as Cluster is a column which...

Sure I will help you.

1) Please post the query in text format. Though I managed to look at your query from the Query plan, please post in text format as...

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

...

@alex,

/*

You could insert your top 20 ActiveDirectory records into a temp table

and UNION separate selects from joins between that temp table to every table you want to consolidate.

*/

Isnt...

@halix,

Out of all the solutions, simple and the one thats most likely to improve the performance is the solution

based on UNION.

Yet 'w.empnum = '00000' + a.employeeid' wouldnt use a...

Having charindex function will ensure that index on a.account

doesn't get used.

Indexes are not effective when you have 'OR' conditions as well.

Can you please post the query plan that you obtain,...

@Thomas-428301,

Included columns are not present at intermediate levels and are present only at leaf levels. So it saves space. You can verify the same using the DMV

sys.Dm_db_index_physical_stats...

Hi Josef,

Good write up. Just a bit surprised that you didnt get much into when to use a Included column covering index..ie Index selection.

I did notice that there was a...

@paul-2,

Great question as expected from you.

thanks.

Hi Phil,

/* With the push towards Powershell and CLR, expect a lot, read all, of these extended stored procedures to be phased out. */

Powershell/CLR can be a good alternative...

First the commit is written to T-Log immediately when it is successful. So on recovery from T-log it will updated on the Data file.

@nplace6530,

Yes true. Along with their longevity, the scary part about undocumented stuff

is their behavior after a patch installation/hot fix update which alter system tables and hence can change...

philcart,

The idea is if a health check script fails(becos of undocumented function), applications dont crash and users dont complain. But if a server crashes or data loss occurs because...

@phil,

OSQL/SQLCMD is n't a gr8 option either. OSQL marked depreciation and replaced by SQLCMD.

I would like to know the reason why u say its dangerous to use xp_dirtree (...