administration

Technical Article

Polling or not

  • Topic

i have a table that has event infomation inserted as they are created. i have and app that polls the table I.e does a select every 30 sec. to see if their are any events for it. is their any way to stop the polling and rather push the event entry to the client pc […]

You rated this post out of 5. Change rating

2001-08-14

8 reads

Technical Article

One Way Interface

  • Topic

I am mainly a programmer work as the IT dept. I am not that adept at SQL Server (and database admin) but am learning. My task at hand it to build a one way interface where another company will send records to our database and we process them. I have a question: How will I […]

You rated this post out of 5. Change rating

2001-08-13

5 reads

Technical Article

Delete using OPENQUERY

  • Topic

I have an application where I need to delete records from a remote table that is accessed via OPENQUERY. I understand that you can INSERT data into a remote table but I wanted to DELETE the data based on a query that must run on the remote server. I tried using a standard DELETE statement […]

You rated this post out of 5. Change rating

2001-08-13

697 reads

Technical Article

Performance Monitor Benchmarks.

  • Topic

In recent weeks i have been trying to find out why SQL is running slow. i have Been using Performance monitor to monitor different objects. I have found alot of infomation on what each object is, but due to the server never been monitored for the last three years i donot know what is good […]

2001-08-13

4 reads

Technical Article

bcp to transfer between SQL 6.5 and SQL 2000

  • Topic

I am looking to export some data from SQL 6.5 for importing into SQL 2000. This works OK using Character mode, but I want to use Native format for speed. I have read through MSDN on this topic and found that I should be looking at the -V6.5 option. I am confused, however, on whether […]

You rated this post out of 5. Change rating

2001-08-13

30 reads

Technical Article

Using replication for redundancy

  • Topic

We have stepped up the criticality level on one of our production db's (actually it is 4 db's) so I now have to setup replication and maintain a backup server. What would be the best type of replication to use? Are there any good replication resources (books etc..) available that might help? TIA, Matt

You rated this post out of 5. Change rating

2001-08-10

3 reads

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers