Okey, and what is #range_scans? How do you describe #user_scans=0 and #range_scans...

Hi, thanks for this post, but the info there is poor, unfortunately.

#...

Additionally, if you want to work with the two instances simultaneously you must set up different listening ports for them.

IgorMi

Hi,

You should change the data type from image to varbinary(max). Image LOB data is stored off-row (complex pointing), and varbinary(max) is stored in-row (part of the data and index)

IgorMi

Hi,

You should look at CPU, Reads, Writes, Duration and the TextData.

IgorMi

Hi Guys,

Thank you for your replies! They are both useful.

Albeit I'll go with the Scripter class in C#.

Regards

IgorMi

Nice question!

Thanks

.

Hi,

Interesting question!

The expected one data page will be listed after rebuilding the index on the table.

alter index PK_Test on dbo.Test rebuild

dbcc ind ('TestDB','Test',1)

Thanks,

IgorMi

Hi,

Interesting question.

Are the indexes you mentioned clustered or non-clustered? It is important. I'll presume they are clustered and can suggest to you to replace this set of data

(

SELECT a1.ProfileID,...

Hi,

Where is EXCEPT?

It is very practical.

See this: http://msdn.microsoft.com/en-us/library/ms188055.aspx

Thanks,

IgorMi

Hi,

You can use for example two OLE...

Hi,

You must use office 2007 or higher version for a million records. Max rows an excel sheet can accept is 1,048,576.

SSIS is very flexible for such tasks like yours....

Nice question.

Thanks

GSquared (12/17/2012)

---

Lots of possibilities here. Could be the scripts don't do anything because they aren't applicable (like Where clauses that cause no rows to be affected). Could be...