Phil Factor explains why an ORDER BY clause should always specify the sort columns using their names, or aliases, rather than using an integer to specify the position of a column in the SELECT list.
2020-03-24
I had an update statement that took 3 minutes to run after this code change it took 6 seconds.
2015-03-27 (first published: 2014-05-08)
24,181 reads
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
2015-06-05 (first published: 2012-04-26)
25,998 reads
Thanks for reply,All-includes all Clients and 999 is just another client and should be treated a bit differently LATER.999 is just a Client Number and it could be thousands of clients. So I guess, I am sorry I didn't expain it well, the question is how to distinguish between ALL (which is not a Client […]
2004-03-30
we typically set up our data seperate from our log. Start Enterprise Manager-> Server -> right click properties->database settings ->Default Data directory: D:\SQL\DATA Default Log Directory: E:\SQL\DATA everytime you create a new database it will created in the respected folder you have assign as default. mom
2003-11-20
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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