2016-08-11 (first published: 2015-06-12)
3,585 reads
2016-08-11 (first published: 2015-06-12)
3,585 reads
2015-10-23 (first published: 2014-05-13)
3,699 reads
Option A also keeps your logic out of the report, which turns the report into just a formatting tool. This allows other tools, such as excel, to use the same source logic, which enhances reuse and makes reconciliation easier. This will also allow you more easily to switch to a different tool if needed. Example: Crystal […]
2004-11-05
your problem was more interesting than my work..... I can tell you the exec-plans are different....print them out and compare line by line....you'll see they diverge quite fast.i'd be interested to see if the exec-plans (of both queries) from the test box...(which are always fast???)...differ in any way....either between themselves...or compared to the prod versions.
2004-07-22
hey egnagey,try adding the following HAVING clause to your SQL to see if that is what you are looking for:SELECT tblroofs.roofid, cap.estimatedcost as CapCost, cap.estimateddate FROM tblcapitalexpenditures as cap RIGHT OUTER JOIN tblroofs ON cap.RoofID = tblRoofs.RoofID WHERE [tblRoofs].[CompanyID] = @CompanyID AND DATEPART(yyyy, cap.estimateddate) >= DATEPART(yyyy, DATEADD(yyyy, 1, GETDATE())) GROUP BY […]
2004-07-22
Run them in Query analyser with the execution plan enabled, see where the difference lies
2004-07-22
I searched whole of MSDN and its release contents online but couldn't find it. I also suspected for release label as SQL Server 2005 but there was none. Usually MS releases beta products for MSDN enterprises? Can Yukon be a exception? That would be against MS marketing policy Please let me know if you come across […]
2004-04-09
Personally I like the backup restore. Run a backup and copy to your laptop, then copy to the enw server and restore.http://qa.sqlservercentral.com/columnists/sjones/migratingtoanewservermovinglogins.asp
2004-02-20
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers