RE: Linked server errors
I did job that kill dormant connections and runt every minute This job give me temporary quite good solution of this problem
2003-06-02
Foreign Keys (FK)
RE: Access Massivly faster than SQL Server [Long Post]
elvistheprince, I also saw that for some reason SQL became extremely slow when given the large number of values in the IN clause. I'd try some workarounds for that: 1. If the list of postcodes is a result of some other query I'd use it as a subquery rather than passing the list of codes. […]
2003-05-30
RE: How to keep and restore the deleted records?
Hello, Your ideas are great and I’m going to try bcp. For a5xo3z1, your question is good. Actually, our data is used to statistical research. So some dirty data must be deleted periodically. Sometimes data managers who have delete permission make mistakes. Well, I’ll think about your way seriously. Thank you for your help.
2003-05-20
RE: permissions to start sql server agent
If you (as the user) are trying to stop or start SQL Server Agent, you need to be in one of the following local groups on the system: Administrators Power Users SQL Server Agent doesn't need to be in the Administrators local group. Minimum permissions, per BOL: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_6k1f.asp K. Brian Kelley http://www.truthsolutions.com/ Author: Start to […]
2003-05-16
RE: Script for deleting duplicates in mulitple tables
Can you post some code and data to show what you mean? Steve Jones steve@dkranch.net
2002-04-16
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