RE: Review: EditPlus
Any one use multiedit? it's a little expensive but does a lot of stuff like open large 500mb text files and allows editing of several files at once http://www.multiedit.com/
2003-07-18
FILESTREAM
RE: Merge Repl between Sql Server 2000 & CE
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-03
2003-07-02
1 reads
2003-07-01
RE: Slow Distinct Query
The difference originates from the use of the GROUP BY clause. In your first query, SQL Server will build the complete result set, gathering all data for each and every f.fund and f.fund_id. Once it has the complete set, it will start removing all duplicates from it. In the second one, SQL Server will use […]
2003-06-30
RE: Addendum to Newsletters' BUILTIN\Administrator
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-27
RE: Sorting of 2 columns
I forgot to mention, in the ORDER BY clause, if you do not designate a sort order for a column, it will default to ascending (ASC).
2003-06-26
RE: Table Constraints
Thanks mccork, that is exactly what I was looking for... I was unaware that you could use Functions in constraints... Thanks again!
2003-06-25
RE: Current Activity/Process Info sorting
This data is mostly from sysprocesses with joins to syslogins, etc. You could get it from QA and then sort it. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-20
1 reads
RE: Collation conflict in join condition
When i received this error it was due to the collation of the two columns i was joining on being different. Check the collation for the two columns you are joining on and make sure they are the same.
2003-06-18
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