Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.
2019-03-26 (first published: 2012-11-30)
7,412 reads
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-12 (first published: 2012-02-21)
1,067 reads
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
2013-12-31 (first published: 2010-12-02)
12,586 reads
Jonathan, I agree about using 'STUFF' - in fact, when I went back to my code to copy it into my message, I realized that I had used 'STUFF', rather than concatenatation, but re-wrote it to confirm my original claim.
2003-12-08
1 reads
By the way, just looked at the thread you posted and I feel that there should NOT be two lookup tables in that situation; statuses of court cases are the same logical types of entity, are they not? "OPEN PENDING TRIAL", "CLOSED CONVICTED", etc (assuming these are actual possible statuses), could all go into a […]
2003-12-05
Maybe something like: select * from Table2 where substring(email, charindex('@', email) + 1, len(email)) not in (select domain from Table1) Assuming of course that email is not null and will always contain a valid email address. Cheers, mia Life moves pretty fast. If you don't stop and look around once in a while, you could […]
2003-11-27
1 reads
Hi, You could use the Convert function to convert the date into the format required... Convert(Varchar(10),getdate(),111) will convert the date into the yyyy/mm/dd format and you can then use : SELECT RETUDATE FROM SVC05000 WHERE RETUDATE = CONVERT(Varchar(10),getdate(),111) further info on Convert can be found in BOL
2003-07-28
1 reads
By Any tool, I mean something like TOAD regrouping basic admin options (user activity, storage management, locks ...) and dev options (sql dev with explain plans, immediate query results when the sql is run ...) also allowing multiple connections on different sql servers - a sort of all-in-one-easy-to-use prog 😉 Thanks !
2003-07-24
1 reads
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
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