2016-08-11 (first published: 2015-06-12)
3,585 reads
Tool
2015-10-23 (first published: 2014-05-13)
3,699 reads
RE: Connection Issues
<so the GUI is my crutch! >Yes, it gets quite complicated using T-SQL but being unable to reproduce your actions and being unable to produce an audit trail because you used EM will cause the auditor to raise an issue due to Sarabannes-Oxley (for publicly traded companies) and HIPAA (for the Health Care Industry). I worked for many […]
2005-03-02
RE: Crystal Reports data access methods (stored procs, etc.)
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
RE: Sargable condition slower than non-sargable...why?
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
RE: Returning too many rows....
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
RE: A tale of two where clauses...
Run them in Query analyser with the execution plan enabled, see where the difference lies
2004-07-22
RE: Where Can I find Yukon Beta?
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
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers