Can you supply more code for the column select and from clause, etc? The community can probably give you better suggestions with that. That being said, here is...

I'm not sure about the performance you will get out of this, but try using the following syntax:

Select ID1.*, BT.Name From IMPORTFILE_DeDuped1 as ID1

left outer join BIG250MMTABLE as BT

on ID1.Name...

Kinda weird, but I'm glad it's working for you. If you're running Mgmt Studio from your workstation, maybe try patching the client. If you are already patched, then...

first off, you would want to create a linked server (like between the 2 nodes). Then from the source machine, do code like the following:

[font="System"]begin distributed transaction

select * from...

It looks like all instances should show DTC as running, based on an x64 SQL 2005 SP2 4 node cluster in an A/A/A/P configuration. Have you tried doing a...

Hi Eva,

To answer your questions,

1) Backups are online operations, whether or not you are using Standard vs. Enterprise. As for restoring a database, when you do page...

Can you clarify what version of SQL you are running? I know you only mentioned the client was 2k5, but I want to verify that you are looking at...

One way to proactively do this is using SQL profiler. You can put a lot of filters on it, such as application (EM) or user, etc... The only...

Not only is the question poorly worded, the "correct" answer is wrong. If you look at what filegroups can be set to read-only, it says all but the primary...

Not a problem, Lanny.

Thanks,

Eric

I don't think it's necessary to schedule downtime and have user acceptance testing for reindexing. If you have a 24 x 7 application database, you may need explicit downtime,...

Hi Larry,

I would say the biggest problem with reindexing a database is the CPU, IO and time cost. It is a pretty low risk command, but it definitely needs...

I must say I am jealous. Mr. Kelly's solution is far easier and elegant. The only down-side is having to teach Enterprise Manager addicts how to use QA,...

As for adding users to the security admin role, revoke exec on sp_addsrvrolemember. I'm stumped on the grant/revoke/deny create database. I don't think that's possible. Anyone else...

For reading the error log, deny exec on master..sp_readerrorlog. Looking into the others...

Thanks,

Eric