This article points out the option to use the query statistic cache from SQL server. You can get the actual SQL using sys.dm_exec_sql_text.

Hope that helps:

http://ozkary.blogspot.com/2014/09/recover-sql-server-management-studio.html

Hi,

SELECT

FROM ddb_temp_DDB tdb

join accounts acct on acct.num_cue_s = tdb.num_cue_s

It looks that the join is finding more than one unique record on the accounts table. Have you...

Just to add to the conversation. You could also use casting to do a like search:

select * from mytable where cast(UploadDate as varchar(10)) like '%2002%'

Just note that any casting prevents...

CESH is a debug shell utility for Windows CE (CE Shell). This is not for SQL Server.

hello,

Take a look at the script (line 187). It uses the SQLDMOScript_Triggers property. This means that when the call to object.script (line 196) is made, the trigger...

hi,

yes, fine tuning the queries to get the best performance is always welcome.

For production environment, I suggest to process/publish the conversion of IP to num during the import...

great feedback!

I like how simple and clean that looks

Using SSMS (SS management studio), right click the server node and select properties. Click memory and set the max server memory.

Then click Processor, and set the MAx worker threads.

Something must...

hi,

I would used a calculated measure if this data point would be used in other areas/reports/dash boards.

If this data point is only relevant to this one report, I would add...

hi,

Make sure to set the limits on the amount of memory and worker threads that SQL Server uses. If you only have 12GB of memory, SQL should...

hi,

You should try to keep the scope of the transaction small, so you can commit after the insert statement (after error check). Do the read outside the...

Hi,

The idea behind this script is to use it for automation purposes. There are different ways in which it can be achieved. This is just one method.

thanks for...

Perhaps null values are giving you different results. You should check for null values on either side of the join (parent_id or dept_id). You can add a isnull(col,-1) around the...

Let me try to understand your requirements. In your database, there are many labels that can be used, and these labels can be translated in multiple languages.

You could use...

To add to this discussion, I think that a nested CTE can provide a solution for this. The problem is that nested CTEs are not supported, but there is a...