Hi Gail

i have disabled all the triggers that i have made,...

Hi Gail

i have disabled all the triggers that i have made,...

How to script SQL Server logins

Right click on the login and select script login as to a new query wondow(easier way of doing)

Properties...

I will try that, when you say Stripped and mirrored , i thought this will have a impact on performance, may be i am wrong,

I am having a view...

Thanks,i am only using 2 Quires to retrieve all my reports, each table has 30 columns, and db sits on a file group,

I am not using Union in...

say 50 million

Hi

I am not sure what exactly you mean by monitoring, are you going to install a 3rd party software for...

try HOST_NAME in ('111','222')

Hope this is what you are looking for 🙂

What error message are you getting from this SQL, I can see a distinct in there, you are using a Group function, that will give you distinct, can you post...

you can use Upper ( Colname) to change the case, then you have to use a loop and then use alter column to change the name of the tables, i...

you can ignore this when creating a linked server, there is a collation option , you can turn it off or on , if you are using 2005, you can...

Google for DBA Interview Questions mate, you will get lots of Questions 🙂

Can you post the code that you are trying to run 🙂

can you post the code which you are using, so some one can have a look and suggest some option

you can also use DTS or SSIS 🙂