rohit.anshu (3/21/2013)

---

hi,

i've seen a couple of cases where huge staging tables containing c/nc indexes are truncated and the index drop and rebuild happens , so its like 1. drop index...

I thought I read that but wasn't sure if I was missing something. Thanks for posting back.

Mirroring is a specific concept in SQL Server but I am guessing you meant it generically because you cannot mirror to anything but another instance of SQL Server and you...

You;re really making us work over here...

I tried polishing up the SQL you provided so it would run on SQL Server but it's not even close. Syntax errors everywhere, mis-aligned...

That looks like Oracle code :ermm:

I have never had to set anything to get that to display, it just always has done that for me. I would check to see if there are any service...

What version of SSIS are you using? What is the version of SQL Server where the data source is hosted?

Pushing the data to a staging table and applying all changes at once using MERGE is a good performing option.

If you need to stick with Lookup for whatever reason, please...

Please provide:

1. DDL in the form of CREATE TABLE statements to create your sample tables

2. DML in the form of INSERT INTO statements to populate the sample tables

3. The expected...

EasyBoy (3/20/2013)

---

Hello All,

I would like to capture the script that was ran by user on yesterday between particular time.

But somehow i am not able to get the desire information.

Can anyone...

If you're on SQL 2008 or above then why would you ever want...

Either one, as long as both as connected to the domain. The changes it invokes are made to Active Directory not to the computer where it is run so it's...

You can see the last 256 minutes from sys.dm_os_ring_buffers.

Query courtesy of Glenn Berry's diagnostic query script:

-- Get CPU Utilization History for last 256 minutes (in one minute intervals) ...

And what was it?

What works? Common courtesy is to post the solution that worked for you so others that encounter the same issue and find this thread...