Lot's of good books out there. Personally thou I learn better from testing various ways and running into issues myself. I always found the Exam Cram books good in overall view and of course SQL BOL. But as for a book totally focused on querying techniques I have not found one that hits my fancy […]
2004-03-23
Consider you are doing distinct on you output so by themselvesAccountNumber, originalBilledAmount, tbl_PerformedProcedure.PatientPrimaryKeyYou get 3252 but when you add inPhysicianID, cptcodeYou will of course have more potentials for differences should accoutn for that.If you remove distinct they should be the same either way.If there is a reason for distinct please explain what you are wanting.
2004-03-22
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!
2004-03-22
I transfer my Access DB to SQL Server 2000 the best way is to use Access 2002 (XP) upsizing wizard .... it trasfer data , RELATIONSHIPS, INDEXES, defaults and many other things Use RDI in Relationships of course check all checkbox (to trasfer indexes) Ok ... ? try .. and If you need any help […]
2004-03-18
This script drop all indexes from table, including Primary Key contraint. First it del nonclustered indexes, then clustered and at last - drops PK contraint. This scirpt is useful, when you need drop all indexes, like when doing ETL process.
2004-03-17
526 reads
Log on to the server and run the Server Network Utility ( svrnetcn.exe ). By default, you should see Named Pipes and TCP/IP. Again, the order on the server is not relevant, because these are simply the list of network libraries available for clients to connect to. The client decides which library to use.You could disable TCP/IP, […]
2004-03-16
generally it is not sp_prepexec that is the root cause of 100% cpu usage, it is usually a very poorly formed query/design. sp_prepexec is used by ODBC and OLE to try an optimize sql that may or may not be used over and over again. So when the connection first issues free form sql, it […]
2004-03-16
Amazing what all can happen while typing. Fortunately I hit F5 before answering
2004-03-11
42000 indicates some kind of access violation.Check DotsJrOld_db_200308211730.BAK, if exists, try to rename it. You may experience difficulty.
2004-03-11
I didn't think of it, but a restore makes sense. Be sure that your integrity has not suffered before you go any further.
2004-03-10
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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