Jeff Moden (9/21/2016)

---

I ask because the easiest and absolutely fastest way to import this data would be do create a BCP format file with line sensitivity. It would eliminate...

😎

Multiple joins need not mean you have a bad performance. I tried with some test data with some sample by executing

INSERT INTO dbo.[DataTEST]

Select data from

dbo.[DataTEST] where ID >9...

Restore filelistonly from disk='Backup path here'

The above will give you the size of files going to be restored in bytes.

As John mentioned there is no way you can restore without...

This can be made...

onja (9/21/2016)

---

Hi,

I'm about to execute DBCC TRACEON (4199) and sp_configure on a specific database but I'm not sure whether it will affect all other databases in a server even though...

A quick and simple solution with good old joins.

Select

CustomeridID.Data as CustomeridID ,

AccountID.Data as AccountID,

EnquiryName.Data as EnquiryName,

Source.Data as Source,

EventDate.Data as EventDate,

EventDays.Data as EventDays,

EnquiryCreatedDate.Data as EnquiryCreatedDate,

Description.Data as Description

FROM dbo.[DataTEST] d...

I don't think cmdshell is evil and it was very useful many times to solve problems at work as a DBA while I started automating my tasks.

However when I...

Hi, what makes you ask this question? if you are just considering the hosting your existing database code and no new development, I think you are safe. You might want...

SQL Galaxy (9/14/2016)

---

Yes, that view is correct SQL statement.. I have created many views with CTE Select statement in non custom port just like only Linked server name.

also...

Hi Bharat,

I think Hugo has explained you very well all the routes you can take. As he mentioned you can use DMV (they are good only since last restart) for...

I have used SMO usin .net and SSIS long back to automate scripting selective database objects.

I think you can use SMO and powershell to achieve the same

Why are considering this in the first place?

It is better to use query hints as minimally as possible. Since the execution plan changes based on data, query hints may...

I too agree that the approach should be reconsidered if you have the luxury.

As Gail mentioned, there is no way than to execute alter scripts for each table.

However you can...

The Dixie Flatline (9/5/2016)

---

We do something similar, matching on license numbers...

Since you are using the stored procedure route, they do not need the fixed database role. But you need to give explicitly grant execute permission to the procedure you cerated