Pinal Dave posted a funny (in a serious way) blog post semi-related to SQL Server.
You can read the original post here, but I will make some comments in this blog post.
His main question is “Can I expect you to be different today?”
The answer is: YES, but in a very Baron Munchhausen’s way. Remember that time
Continue reading […] Random thoughts and random ideas […]
I just read a very interesting post by Pinal Dave on 3 new DMVs in Denali.
In his post Pinal is asking the audience to help decipher the purpose of the DMVs. So here is my answer:
There is almost nothing new in this case, except for the fact that the information is available through DMVs.
Continue reading […] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry […]
Long story short: I have a SSIS data transformation task which takes some data from a table and inserts it in a different table.
So far so good. But the problem is that the data source in my transformation relies on a query which gets data from a table with several million rows and in reality
Continue reading […] Using T-SQL query options in CTEs […]