Run a trace for an hour or so during the busiest time of the day and feed the traced data to the index tuning wizard and see what it recommends....

No, it is basic TCP/IP, only one listener on a port.

I do strongly recommend setting a port range policy. And set each instance to a port, and not use...

vkundar:

It sounds like you have a stage process and then a load process from staging. Is there a cleaner method than comparing all the fields on the rows? ...

Build some pre-aggregated data tables. Add up common combinations, by month by customer and such. Indexes on almost any field that will be filtered on.

I guess I need...

I might suggest a more portable version:

SELECT * FROM INFORMATION_SCHEMA.TABLES

CEWII

I don't know of any tools, but the first problem is figuring out what is using linked servers, you can do a search of the syscomments using the LIKE statement....

I like both but each has its own purpose..

Many (most) environments end up with a mix. With Linked servers being used less.

For data that you need the absolute most...

I setup the basis for you to add additional checks 1 or 100 it doesn't matter.

At the point it says:

-- Additional conditions that you want checked

Add an addition check, raise...

hemant789 (8/12/2009)

---

Thanks for reply.

We can do this by making one group email id for all ten peoples but i don't want to use this option.I want to do it from...

I think the bundling problem is forced bundling, at least you can uncheck the option for a Google toolbar. But when the provider says ok you want ESPN, well...

I found this:

http://blogs.mssqltips.com/forums/p/916/1969.aspx

Be careful with that extended stored procedure if you have mount points it won't show the right number..

Why don't you explain what you are trying to accomplish?

CEWII

Think of television. If the Golf channel had to be purchased separately, it might not exist. But by bundling the Food channel, the Golf channel and a few more in...

This is the way I like to handle it..

ALTER TRIGGER [dbo].[Opdr4a]

ON [dbo].[uitgifteregel]

FOR INSERT

AS

BEGIN

DECLARE @FailFlag tinyint

SET @FailFlag = 0

...

Is there a cube on top of it or are you talking about a relational DW?

CEWII

I don't think you can.. But why don't you see about a distribution list on your email server. Send to the "list" and IT handles the distribution to...