Who is online?
119
guests and
0
members
Login
|
Register
home
articles
forums
blogs
did-you-know
quick tip
podcasts
files
login
about us
events
join us
write for us
newsletters
register
home
» search results
Search Results: Fetch
14 results found
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
Page 1 of 1 (14 items)