Search Results: Fetch

• 
  SQL Server 2012 “Denali”: Paging feature

  Paging is a process of splitting large result set into subset of pages. So, instead of displaying 5000 records resulting from a search, first 20 records are shown and then next 20 and so on. In SQL Server 2005, Common Table Expression (CTE) is generally u

  Author:  Ahmad Osama     Date: 2/12/2012     Section: Blog

  tags : Fetch, Offset, Order by, Paging, SQL SERVER 2012 new features
• 
  SQL Server 2012 DENALI T-SQL Enhancements: FETCH & OFFSET

  T-SQL New feature for OFFSET and FETCH Please note the table is completely fictitious and all data is just for presentation purpose Consider a scenario below: English Product Name Reorder Point Dealer price Item 1 100 1000 Item 2 200 2000 Item 3 150 3000

  Author:  Raunak Jhawar     Date: 11/14/2011     Section: Blog

  tags : Fetch, Fetch Denali SQL Server 2012, Offset, Offset Denali SQL Server 2012, Ranking in SQL Server, SQL, SQL Denali, SQL Server, T-SQL Enhancements Denali CTP3 SQL Server 2012
• 
  SQL Server - What Is A Cursor?

  Cursors are database objects used to manipulate data in a set on a row-by-row basis; it acts just like a recordset in ASP and Visual Basic. We can also fetch cursor rows and perform operations on them in a loop just like using any looping mechanism found

  Author:  Piyush Bajaj     Date: 6/27/2011     Section: Article

  tags : Cursor, ISO Syntax, SQL Server, Transact-SQL Syntax
• 
  SQL Server 2012 Denali SSIS Enhancement - Group and Connection Managers

  SQL Server 2012 - Denali SSIS Enhancement Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”. This post comes as a

  Author:  Raunak Jhawar     Date: 11/18/2011     Section: Blog

  tags : Business Intelligence, denali ssis new features, Microsoft SQL Server 2012, SQL Server 2012, SQL SERVER 2012 new features, SQL Server Integration Services, SSIS, SSIS new features
• 
  Syntax Error when using Keywrods in SSAS MDX Query

  Hi I am working on a SSRS project where my datasource is SSAS Cube. I want to fetch data into my report based on the parameter passed to the MDX Query. I have a few Records in my cube with Group Name as 'IS','Group A','F & D' When I pass group name as

  Author:  Bappi Kishan Singh Guruvindapalli     Date: 10/9/2012     Section: Forum

  tags : Keywords, MDX, SSAS, Syntax Error
• 
  Linking Main Report with Subreport in SSRS

  Hello, I am having two 2 tables employees and salary which are linked by employeeid. I am having a Main report which fetches the data from employees table. There is one more report subreport.rdl which fetches the data from salary table. If I want to link

  Author:  Lata Lata     Date: 5/4/2011     Section: Forum
• 
  sp_who2....killing.....

  if we run sp_who2 in mssql we can get some details. On that details the status column having the data's like Running\Sleeping we see. From that details i can delete the sleeping status rows. But how to aware that sleeping id have been execute some insert\

  Author:  Abdul Salam     Date: 9/28/2011     Section: Forum
• 
  SQL Server: Address translation- How Virtual Memory is mapped to Physical Memory

  Introduction We all know that data retrieval will be fast if the data pages are found in RAM .If the data pages are not in RAM, they are fetched into RAM from the disk. This causes a physical IO .The page remains in the RAM until it’s again kicked o

  Author:  Abhay Chaudhary     Date: 2/11/2012     Section: Blog

  tags : address translation, Page table Entries
• 
  SQL Server: Select Star From Cube

  Select * from Cube (SQL? No, its MDX) Everybody knows that to query the data from an OLTP database, we use SQL. Similarly, to query the data from an OLAP database, we have to use MDX. MDX stands for “Multi Dimensional Expression” language whic

  Author:  Amit Karkhanis     Date: 8/31/2011     Section: Blog

  tags : MDX; Simple MDX Query; Basic MDX
• 
  Reducing the execution time of SSRS 2005 reports

  Hi, I too faced the same kind of issues when rendering the SSRS reports. My suggestion is migrate to SSRS 2008. The fact is that SSRS 2005 executes the query and renders all the data regardless of how many pages the report is?!. (Say if the result is 50 p

  Author:  Muthukannan Ganesan     Date: 3/21/2011     Section: Forum
• 
  Understanding SQL Server Performance Tuning - Why DateAdd is performing too slow.

  Dateadd performing too slow,proper tuning of the SQL Statements in the dateadd condition.

  Author:  Satnam Singh     Date: 7/20/2012     Section: Article
• 
  Help in Performance Improvement of a Data Function.

  Friends, I am having a serious performance problem with the below query: SELECT DATEADD(mi, (SELECT BiasInMinutes FROM A WHERE (Begin1 < B.CompletedWhen) AND (End1 >= B.CompletedWhen) AND (Timezone = C.TimeZone_I)), B.CompletedWhen) AS Expr1) BETWEE

  Author:  Satnam Singh     Date: 6/28/2012     Section: Forum
• 
  Confusion about index

  Yes Prince that is right.In case if the data pages are not available in the buffer pool the memory manager would fetch the data pages from the disk. But I could not understand how does data pages being fragemented relates to buffer pool.If my buffer pool

  Author:  Sachin Nandanwar     Date: 4/20/2013     Section: Forum
• 
  Doubt on CUBE process type

  Hi Amit thanks for reply, Facing time consumption issue. When I use process full it is taking 5-6 hours.As you suggested if I go with process data it will drop aggregations and indexes which impacts cube processing time.Please guide me on this. Please cor

  Author:  sreehari b     Date: 5/23/2013     Section: Forum