Why not to store dynamic SQL in a varchar(max) variable ? Why you need both temp tables?

What is the goal to join to sys.database_mirroring ? You're not using anything from...

You can do it without cursor

select session_id,DB_NAME(database_id),text, transaction_id

from sys.dm_exec_requests r outer apply sys.dm_exec_sql_text (sql_handle)

where open_transaction_count>1

Thank you. They have catalog views for databases, tables, columns , but they don't show whether a column is calculated. But anyway, it's good. I did not know that SSAS...

Yes, thanks Gail, I just found that it was blocked by another insert.

Grant Fritchey (8/26/2015)

---

Also, you say you checked the plan, I mean, did you look at the plan when it's running slow to compare it to when it's running fast. If...

Yes, I checked execution plan, and executed it on empty and filled buffer cache in test server, it all executes within seconds. But my PageIOLatches happen in production, and not...

Perry Whittle (8/6/2015)

---

SQL Guy 1 (8/5/2015)

---

But my concern is there are any implications of this change? Are there any internal SQL Server processes or scripts that rely on pseudo-standard...

JManuelN (8/6/2015)

---

Hi,

There should be no problems moving DBs to a different path location. Only if you have read-only databases or read-only filegroups you may find some issues. Maybe if you...

This looks like the most elegant solution. But I...

You can also BCP out

Thanks for the links, Alan. Especially for the 2nd one. Interestingly, it in turn links back to SSC site to a great script written by Gianluca Sartori: http://www.sqlservercentral.com/scripts/tempdb/72007/

About...

Thanks a lot, Vincy. Checkpoint greatly helped me. I was running it just once, and it was enough to bring it to 0%, though it took almost 2 min.

Alan: how...

At the...

Thanks again, now I can easily query :

select * from [old_master_2015_07_10].[sys].[sysxsrvs]

Now I need an underlyer table for sys.server_principals view. But how to find all the tables for system views?...

Thanks, this was my mistake:

Now I will go further, because this was holding me.