|
Ashfield wrote: if we understood your problem
Yup. A big IF. Couldn't understand it at all.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Please post DDL for the tables in question, sample data, and expected results. It's a whole lot simpler to help you that way.
|
|
|
|
|
Can you post your query?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
Service broker and sql notification are normally associated with database events. If you are wanting to know about file system changes you need a filesystemwatcher[^]
Bob
Ashfield Consultants Ltd
|
|
|
|
|
ok . i need this.
for example in my program :
i need that if user add or remove a book from database . changes display online.
<< never believe a lie >>
|
|
|
|
|
In which case, yes server broker & sql notification will do the job.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
how i can do this?
<< never believe a lie >>
|
|
|
|
|
Have a look at this CP article[^]
Bob
Ashfield Consultants Ltd
|
|
|
|
|
|
Now I'm confused - and not a little annoyed. I point you at an article that gives loads of info about using notification services and you reply with a load of confused.
You could also try google, or even buy a book - there are several gopod ones on the market
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Have you studied SQL Server development at all?
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
I had an empty SQL database created on one of our internal machines. The admin gave me dbowner rights. At this point I need to know how to go about creating tables, queries, etc in that database. The last time I used MSSQL (8 years ago), I had physical access to the machine and could mess with it all I wanted. That's no longer the case. Is there something that I can install on my desktop to management it (so that I do not have to get the admin involved for every little change I need)?
Thanks.
DC
"Love people and use things, not love things and use people." - Unknown
"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch
|
|
|
|
|
I'm in the same boat you're in...but I have a few words for you as a gift from one SQL Server newbie to another: "Microsoft SQL Server Management Studio Express"
|
|
|
|
|
Yes, I had previously seen this tool and it looked promising. My only reservation was that it was for MSSQL 2005 Express. Currently I do not know what version of MSSQL we have.
Thanks for the confirmation.
"Love people and use things, not love things and use people." - Unknown
"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch
|
|
|
|
|
David is right, Management Studio is the tool you are looking for. I have a personal question for you. MVP, 5 years membership, 21 articles and you are a SQL newbie. Just what have you been doing, oh wait read the articles -
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Just what have you been doing...
Not that it's any of your concern, but what I've been doing does not involve databases of any sort.
"Love people and use things, not love things and use people." - Unknown
"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch
|
|
|
|
|
You're right it is none of my business but I'm so steeped in LOB applications that are all database oriented I was curious is all.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hey Guys,
I am trying to enhance queries that uses linked server (both servers aare SQL Server) and i am looking for fresh Ideas. I am working with a lot of data.
- I tried to copy data to a temp table and then use the temp table (with appropriate indexs) instead of querying the table in the remote server directly
- using OpenQuery - bad in loops
Would setting up views be a good idea? Any thoughts?
|
|
|
|
|
The most imprtant goal you have is that you don't fetch all the data through linked server and then perform joins, where clauses etc. Try to fetch only the data you need. This may require views and stored procs on both sides that help you eliminate the unnecessary rows as early as possible.
Mika
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Thanks for your reply. If we have say 1 remote table that we are working with, I was thinking of creating a view of this table on the local server and then just query the view. But I am not sure if this will enhane the perfromance or not.
|
|
|
|
|
It's quite impossible to generally say if it helps or not. If you can write the view so that it restricts rows on target, it will help. What I'm after is for example something like this:
On local server
- SELECT * FROM View WHERE ... (returns 100 rows)
- view on local server fetches all rows from linked server based on a view on linked server
on linked server
- a view fetches only those rows that are potentially needed on the other side (let's say 1000 rows)
- the table on linked server has for example on million rows
So in the case above, there's only need to transfer 1000 rows (or less, depending on the view and the conditions in the select statement) through the link instead of million rows. This will greately speed up the operation.
Try using Query Analyzer (execution plan) to investigate what actually happens. This will give you a good idea about the bottleneck. If you cannot see operations performed on the linked server side via execution plan, you can bring all the data to the same database, investigate it and when row elimination is done as early as possible, implement the solution on both sides.
Hope this helps,
Mika
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Thanks Mika, you were of great help. Thats exactly what I will try to do.
|
|
|
|
|
No problem
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
I often use table-valued functions rather than views because they allow parameters for more fine-grained filtering of rows.
|
|
|
|