On MS Access applications, usually I use subreport objects with SQL queries of their own, linked to the main report which includes the subreport. Classic example of such master-detail reports is invoices: + master (main report) section includes invoice date, invoice number and details of the customer account such as name and address lines. + … Read moreShow MS Access Subreports With No Data
…when we can “ask” or “google” or “yahoo!” Today, I thought let me check an “online SQL tool” (web-based database administration software) on the net, and found out that Microsoft has one. OK, let me download it and check it. I visited their website, a link diverted me to it. And within it, it diverted … Read moreWhy “bing”?
Also known as content indexing service, this process is part of Windows operating system, and it is supposed to index the files on the drive(s), which should provide faster file search and access using the indexing service catalog. Instead of speeding up your machine, it sometimes slows it down, which is probably because some dummy … Read moreAnother clumsy application from Microsoft: cisvc.exe
After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).
WITH OrderedOrders AS
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
WHERE RowNumber BETWEEN 50 AND 60;
It is simply unacceptable, non-standard, impractical! By the way, you can not use column numbers (e.g. ORDER … Read morePaging records in MS SQL Server 2005