As Matt pointed out, double quotes are required when a space is in the path or filename. Allthough it's not required...

Use the same technique as you get from the answers in your previous post http://www.sqlservercentral.com/Forums/Topic1472563-391-1.aspx

Replace the "SELECT CASE" into an "IF" statement.

Don't use single line code (like INSERT ... SELECT... FROM) for such large tables. Use an ETL tool instead. You can use SSIS (import/export wizard) or the BCP command line...

That's an easy one: get the rowcount of the table and use this in a IF statement

-- change the table name (currently: #temp) on two places in the code below

if...

What do you define as a "hit"?

Every executed stored procedure, every executed batch, or every executed statement, or every active connection login, or....?

The most basic(?) way to look at this...

Another solution is to PIVOT the #temp1 table and join this with the table you want to update

-- Pivot source table and join with table to update

Update #Customer_Profile_Master1

set Co_apcode_1_categ =...

I don't think this is the fastest solution, but it will work:

Select * from #Temp1

Select * from #Customer_Profile_Master1

Update #Customer_Profile_Master1

set Co_apcode_1_categ = (select top 1 Category from #temp1 where rownumber =...

What about a simple CASE statement, will dat do the trick?

Declare @firstno varchar(10) = 'V001',

@scndno varchar(10) = 'V005'

select count(*)...

There are several options you can use. It's preferred to execute the commands with a commandprompt utility like powershell. Examples can be found on the internet, just google a bit.

You...

Hi,

Take a look at http://ola.hallengren.com/. He has created a custom maintenance solution. These are highly recommended by many DBA's in the field.

Edit: corrected the URL

Thanks Gail, I learned something new again.

I thought that because a clustered index is always ordered, a scan would always be the same. I'm glad I didn't get this question...

You need access on both the source and the target.

You need access on the source to get to your starting point of the linked server. You need access on the...

Just create the linked server connection and specify the user credentials in the code or in the "Security" page (when using the GUI).

EXEC master.dbo.sp_addlinkedserver @server = N'{FQDN_instancename}', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin...

The answer is B.

Does the exam kit has an explanation or link to why C should be the correct answer?

Mac1986 (7/8/2013)

---

when i execute the SQLCMD using my credential, it works fine. but whjen i put the same command in a SQL job and run it, it fails with Access...