Administration

Question

Administration

Ravi SQL

SSCommitted

Points: 1714
More actions
September 10, 2012 at 8:27 pm

#281421

Comments posted to this topic are about the item Administration
Regards,
Ravi.
September 11, 2012 at 3:06 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 2

Thank you Ravi-ji, Interesting one. 🙂

(Though I selected the wrong answer, assuming that bulk import is on huge data and dropping indexes will improve the import process... and was considering bulk recovery model will do the minimal logging (some how)... :ermm: ... after reading the link provided there came to know that my analysis was completely illogical.)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Carlo Romagnano SSC-Insane Points: 22662 More actions · Answer 3

Carlo Romagnano

SSC-Insane

Points: 22662

September 11, 2012 at 1:01 am

#1536019

Thanks!

🙂

t.brown 89142 SSCommitted Points: 1530 More actions · Answer 4

Its a tricky one, and worth knowing.

There are so many rules about getting minimal logging.

george sibbald SSC Guru Points: 104210 More actions · Answer 5

nice reminder, thanks. Good to hear the table only has one clustered index! 🙂

The points in the link about logging behaviour when you batch up bulk imports are important to note.

---------------------------------------------------------------------

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 6

Another thing I thought I learned and found out I didn't.

Thanks, Ravi.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Paul White SSC Guru Points: 150467 More actions · Answer 7

The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and a point.

http://msdn.microsoft.com/en-us/library/dd425070.aspx (Summarizing Minimal Logging Conditions)

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Thomas Abraham SSChampion Points: 10761 More actions · Answer 8

SQL Kiwi (9/11/2012)
The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and a point.
http://msdn.microsoft.com/en-us/library/dd425070.aspx (Summarizing Minimal Logging Conditions)

Thanks to Ravi for the question, and Paul for the amplification.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Dana Medley SSCertifiable Points: 6764 More actions · Answer 9

Dana Medley

SSCertifiable

Points: 6764

September 11, 2012 at 6:20 am

#1536185

Thanks for the great question.

Everything is awesome!

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 10

Thanks for the question. Took a little research to get the correct answer. Good one.

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 11

Thanks, Ravi..

The question is interesting.. and Nice..

sestell1 SSChampion Points: 10230 More actions · Answer 12

Great question Ravi, thanks!

Interesting note about traceflag 610 SQL Kiwi, I was not familiar with that traceflag.

Here is some more information on it:

http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

EDIT - fixed a typo

Cliff Jones SSChampion Points: 10547 More actions · Answer 13

sestell1 (9/11/2012)
Great question Ravi, thanks!
Interesting note about traceflag 610 SQL Kiwi, I was not familiar with that traceflag.
Here is some more information on it:
http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx
EDIT - fixed a typo

+1