DEfault trace is enabled but i has trc files for only past 3 days.

How cud i implement Audit for security without using sql profiler.

Is there any script out there which runs all the time and audit each login and give me all the...

Just to have an aidea of my setup.

I have 20 huge databases on 2 servers each db range from 500GB to 900GB. Now we had each table partioned by monthly...

David

You are option looks interesting to me. HE re is my understanding about that...

I am looking to compare database structures.

Its he same cast and case statements repeated with no change except the field names. anyways i was just looking for better performance of such dyanamic sql. any idea?

Lynn

In the query above Revenue is view actually.

Could you tell how view will improve the performance.

Lynn

I tried with join as you said. If i run within the same server i see some gud performance than earlier but when i run cross over server still its...

Lynn

Do u mind to put your code here as you said.

Sorry ,The query i have pasted here may be wrong, its a long code doing all repeated stuff like CASE staments just to make it short i cut it down....

its the server name and i have only 1 instance on that server. Yes it is named i i think.

Guys

My LinkServer setup was working perfect with KERBEROS and today suddenly my connections from one of the servers failed. I am getting this error again.

Msg 18456, Level 14, State 1,...

Yes but iwould like to know if they queries run in parallel will that degrade performance

its Dev environment but when people do heavy updated other developers can not query that databases.

Another performance question.

Developers run updates queries on multiple databases at once, like if they need to update 3 databases they open 3 windows and run the queries simultaneously which brings...