Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2021-11-26 (first published: 2019-11-04)
12,637 reads
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-03-03 (first published: 2009-10-07)
46,906 reads
I agree that this should be done with stored procedures. It's to maintain a total of four environments (live, uat, sys-test and dev), so I was hoping to have the SP's on a single environment rather than having to maintain the same SP's in four places. I guess it's not the end of the world […]
2003-07-29
1 reads
Hi Hans, quote: Well, don't get me wrong. I won't, your opinion is very welcome! What a nice coincidence, someone else replied to this article http://qa.sqlservercentral.com/columnists/awarren/worstpracticesnotusingprimarykeysandclusteredindex.asp today. I'm going to read this first, before going any further Cheers, Frank
2003-07-10
I am afraid this is not the case, because the tempdb itself is not growing. It started today from 300Mb for data and 500Mb for log. Now it has 300Mb for data AND 8Gb for log. Just in one working day! I am affraid it will eat the whole disk before the work time is […]
2003-07-07
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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