SQL Server 2012 T-SQL at a Glance – OFFSET/FETCHCommented on: 5 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: 6 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...
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More