Jason-299789 (6/19/2013)

---

Suresh Kumar Maganti

I agree the bulk insert method is the better way, especially with the One off lock on the destination table, rather than the 700 million...

Jason-299789 (6/18/2013)

---

I think you missed the point that chris was making, if you look at his example he uses an Inline CTE to act as a Tally table.

As you have...

Hi Mike,

Thanks for the nice discussion.

This was indeed a real...

Hi Chris,

Thanks for the nice feedback.

I appreciate...

"Is it really necessary to include the database name in all object references? I've always included schema.object but not database name as it's impossible to deploy the same code base...

After a restore and after having created all the necessary indexes, try using the following code on your database:

exec sp_MSforeachtable 'update statistics ? with FullScan, Norecompute'

Best Regards,

Suresh.

Dear reader,

What I meant by thae statement is the following:

Usually developers tend to use TSQL from their application...

Hi Boris,

The system stored procedure, sp_estimate_data_compression_savings for Microsoft SQL Server 2008 has already been mentioned and used in the article to get an estimate of...

Is it Steven Lugan? Thanks for your comments on the article. I don't have your number. I would be gald to call you or you can reach me at 214-300-8995.

For SQL Server 2005, the syntax would be:

select record_count / page_count

from sys.dm_db_index_physical_stats(392, 1598628738, null, Null, 'DETAILED')

where index_level = 0

The details are given in the same article as to...

Please let me know in which part of the code do you get that error.

Thanks and Best Regards,

Suresh.

First of all, I must thank everybody for their valuable comments and insights on this article. During the past several years, I had come across several situations where duplications came...

To keep you variables alive, sp_executesql could be preferable to EXEC.

select * from openrowset ('Microsoft.Jet.OleDB.4.0', 'Excel 8.0;Database=D:\MyExcel.xls;', 'select * from [Sheet1$]')

The $ sign is mandatory. Even if you sheet name has spaces or special characters, the square brackets would handle...

a.] The advanced SQL Server configuration option 'Ad Hoc Distributed Queries' must be set to 1.

b.] Please remember to close the Excel sheet before each execution of the code.

c.] I...