sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx
Returns aggregate performance statistics for cached query plans. The view...
2013-04-03
4,571 reads
sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx
Returns information about each request that is executing within SQL...
2013-04-01
1,192 reads
The 10th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 10 contains all...
2013-03-25
714 reads
The 3rdcumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 3 contains all the...
2013-03-21
918 reads
· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will...
2013-03-19
1,017 reads
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view...
2013-03-11
3,788 reads
The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx
Returns information about the connections established...
2013-03-05
1,471 reads
How can I check what all SQL server features and version are installed on my Machine ?
It’s a frequently asked...
2013-02-25
1,548 reads
The 11thcumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft...
2013-02-19
1,002 reads
The 5th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-02-19
1,917 reads
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers