Random thoughts and random ideas

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 […]

 

SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

I just read a very interesting post by Pinal Dave on 3 new DMVs in Denali.

Interesting.

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.

In the

Continue reading […] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry […]

 

Using T-SQL query options in CTEs

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 […]