RE: Handling a DTS packages errors
Well, that is what I thought too. That is why i have the second task (Do Successful Task) on the failure side of my sample. It still comes out as a failed package in the job.
2004-03-19
Profiler
RE: Why does this SP require recompilation?
remove TOP 100 and use followingSET ROWCOUNT 100 -- ur select query here SET ROWCOUNT 0 What is performance impact of this ? Well as per BOLIf a SELECT statement that includes TOP also has an ORDER BY clause, the rows to be returned are selected from the ordered result set. The entire result set is […]
2004-02-16
1 reads
RE: Query Returns Data From Linked Server Despite Loss of Connection?
Well, I created the link months ago... and I've slept since then... but sysservers shows it as SQLOLEDB. So yes, it's SQL Server.<BEAT_DEAD_HORSE>Say, the connection went down again just a bit ago. I performed my primitive test, and it failed the query in QA once and then resumed functioning. Ping was still timing out.</BEAT_DEAD_HORSE>Regards, SJTerrill
2004-01-22
RE: No snapshot wanted, just transactions
Yes it can be done. But be shure you don't have upadtes or deletes from old records, because replication will fail. When you subscribe to the publisher you can choose that you already have the data and that there is no need to syncronize. Or if using stored procedures in the sp_addsubscription sp, choose 'none' in […]
2004-01-06
RE: Statistics on multiple columns
quote: Thanks Jonathan, I read the paper (Automating Statistics Management for Query Optimizers ). Very **very** complex! If I understand well, there's no simple rule of thumb. You have to try and to test (heuristic approach) and so on ... Am I right? Patrick SIMONS, MCP Yes, that paper is quite technical... You can guess […]
2003-12-15
RE: Remove alpha characters
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
RE: Store Key - Storing Misc Data
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
RE: SELECT FROM a WHERE {end bit of field} not in B..?
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
2003-08-27
RE: SELECT DISTINCT...
Hi Frank, So ur suggesting to have new row in tb_reports table for each modification so that querying will be easy.I will try that. Thanks & Rgds, Surjit
2003-08-07
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