SQL Server 2012 T-SQL at a Glance – OFFSET/FETCHCommented on: 3 years ago
(November 21, 2010)
For 1st puzzle, i think we can use your prev. trick of (select 1) only.. SELECT * from tblNumbers order by (select 1) offset 0 rows FETCH First 1 ROW ONLY;
For 2nd : We can take a...
More about Calculating Concurrent SessionsCommented on: 4 years ago
(November 29, 2009)
Is this logic is correct??? This is my first reply to your blog....
select APP,MAX(cnt) as NoOfSessions from
( select s1.app,s.stime,COUNT(*) as cnt from (select app,starttime as sTime...
Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More