Thursday, March 4, 2010

My SQL LDF file is so big in comparison with the MDF file, what can I do ?

At a lot of customer sites I  have seen situations in which the transaction log file (LDF) is multiple times bigger than the MDF file. This is not a 'normal' situation. In this blog I will explain what you can do if you have an LDF file of your SQL server database which is too big in comparison with the size of your MDF file.



What is the difference between the MDF and LDF file ?
The .MDF file is the primary data file of a SQL database. The .LDF file is the transaction log file of a SQL database. The transaction log is used to guarantee the data integrity of the database and for data recovery. Data integrity is implemented by design and can't be configured by the database administrator. Data recovery is implemented by design and is configurable by the database administrator.

In SQL Server you have 3 different data recovery models: Simple, Full and bulk-logged. Typically, a database uses the Full recovery model or Simple recovery model.

What is the main difference between Full and Simple?
  • Simple: No transaction log backups. Changes since the most recent backup are unprotected. In the event of a disaster, those changes are lost and need to be redone. You can only recover to the end of a backup.
  • Full: Requiers transaction log backups. No work is lost due to a lost or damaged data file. Can recover to a specific point in time, assuming that your backups are complete up to that point in time. For example, prior to application or user error. 

What is in the transaction log in the Simple recovery model ?
All open transactions. This means not committed transactions. This is called the active part of the transaction log. At the moment a transaction is committed it will be truncated from the transaction log. Log truncation automatically frees disk space for reuse by the transaction log. The biggest size of the transaction log will be the size of all open transactions at one moment. Therefor in a 'normal' SQL production database the transaction log file will never get very big.

What is in the transaction log in the Full recovery model ?
All committed transaction (inactive part) and open transactions (active part). The log records cannot be truncated untill all its log records have been captured in a transaction log backup. The log is truncated when you backup the transaction log.

What can we do to lower the size of the transactional log file (LDF)?
It depends on the configured recovery model of your database, what you can do. The recovery model of your database can be found in the properties of the database:

or via SSMS:
Open a query window and select the database.

USE
SELECT Recovery_model_desc FROM sys.databases WHERE Name = db_name()


What to do if your recovery model is: FULL?
Check if you are making transactional backups on a reguler time interval. If you only make full backups your transaction log will always grow and will never be truncated. In case you never want to lose data in case of a application or user error. Start making transactional log backups. If a database restore to the latest full backup is acceptable, you can switch the recovery model of your database to simple. Before switching the recovery model of your database please read next document: Considerations from switching the recovery model of your database. After switching to the recovery model Simple , you can shrink the log file. See the end of this blog how to do this.


What to do if your recovery model is: Simple?
Shrink the log file.


To set the recovery model to Simple you can run next query:
ALTER DATABASE
SET RECOVERY SIMPLE

To set the recovery model to FULL you can run next query:
ALTER DATABASE
SET RECOVERY FULL

How many free space is available in my log file?
  • Select the database in the Object Explorer
  • Point to Tasks, Point to Shrink and then click Files.
  • Select File Type: Log
  • Currently allocated: The current size of your log file
  • Available free space: The free space in your log file
To shrink the log file:
  • Select the database in the Object Explorer
  • Point to Tasks, Point to Shrink and then click Files.
  • Select File Type: Log
  • Select Release unused space
  • Press OK to start the shrink process. If you do not want to shrink the log file press the cancel button.

151 comments:

Alexis said...

I seldom work with sql server and files too. But once I couldn't use my files,because of they were corrupted. And fortunately I incidentally entered in the Internet and observed there - sql server repair database. The utility resolved my issue for a minute and free of charge as I bore in mind.

Raj said...

Hello Dear,

i had many confusion about mdf, ldf ndf files of sql server database. after reading your article, i am mostly satisfy.

I have also written article about database recovery software.

נמרוד כנען said...

Nice articcal

Andrei said...

This article helped me in shrinking the log file size. Very nice indeed. Helped me a lot... I recovered 7Gigs of space. Thanks!

All mankind love a lover. said...

i have a database my mdf fils is 139 mb & ldf file is 29.7 gb I've taken transaction log backup and then shrink database file it is reduced but only 1 gb what should i do to reduce the size of ldf file (gmailbackup@sify.com)

All mankind love a lover. said...

i have a database my mdf fils is 139 mb & ldf file is 29.7 gb I've taken transaction log backup and then shrink database file it is reduced but only 1 gb what should i do to reduce the size of ldf file (gmailbackup@sify.com)

Unknown said...

HI André,

I also wrote an article on this topic. I cover all the possible causes of growing transaction log file as well as possible solutions. Please have a look on this article: Decrease Transaction Log File Size

Unknown said...

All mankind love a lover,
Alter your database to simple recovery model and then shrink LDF to 1.

ALTER DATABASE SET RECOVERY SIMPLE

DBCC SHRINKFILE(,1)

Unknown said...

All mankind love a lover,
Alter your database to simple recovery model and then shrink LDF to 1.

ALTER DATABASE "DBNAME" SET RECOVERY SIMPLE

DBCC SHRINKFILE("Logical Name of your Logfile",1)

Unknown said...
This comment has been removed by the author.
Business Analytics Course said...

It's a smart blog. I mean it seriously. You have so much knowledge on this subject and so much passion. He also knows how to get people to join him, obviously from the answers.

360DigiTMG Business Analytics Course in Bangalore

Data Analytics Course said...

I really appreciate this wonderful message you have given us. I assure you that would be beneficial for most people.

360DigiTMG Data Analytics Course in Bangalore

Anonymous said...

Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Simple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained

Data Science Training said...

I truly like only reading every one your web logs. Simply desired to in form you which you simply have persons such as me that love your own work out. Absolutely an extraordinary informative article. Hats off to you! The details which you have furnished is quite valuable. Tableau Course in Bangalore

Data Science Institute In Banglore said...


Fantastic article I ought to say and thanks to the info. Instruction is absolutely a sticky topic. But remains one of the top issues of the time. I love your article and look forward to more.

Data Science Training Institute in Bangalore

Best Data Science Courses In Bangalore said...


Additionally, this is an excellent article which I truly like studying. It's not everyday I have the option to see something similar to this.
Data Science Course In Bangalore With Placement

Cyber Security Course In Bangalore said...


Very wonderful informative article. I appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks! .

Cyber Security Course In Bangalore

Mike Johnson said...

Maybe you can make short video about it for tiktok? On this site https://soclikes.com/buy-tiktok-likes you can get tiktok likes

Data Science Courses In Bangalore said...


I'm really thankful that I read this. It's extremely valuable and quite informative and I truly learned a great deal from it.

Data Science Course In India

Data Science Course Syllabus said...


Nice to be seeing your site once again, it's been weeks for me. This article which ive been waited for so long. I need this guide to complete my mission inside the school, and it's same issue together along with your essay. Thanks, pleasant share.

Data Science Course Syllabus

DataScience Specialist said...

I have to search sites with relevant information ,This is a
wonderful blog,These type of blog keeps the users interest in
the website, i am impressed. thank you.
Data Science Course in Bangalore

Datascience Course Analyst said...

Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
Data Science Course in Bangalore

Datascience Books said...

Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
Data Science Training in Bangalore

InstituteBlr said...

I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
data analytics course in bangalore

AI course in pune said...

I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
artificial intelligence course in pune

data analytics books said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
data analytics training in bangalore

Srigokul said...

Useful information, Thank you for sharing...

Data science training in chennai
Data science course in chennai

Huongkv said...

Đặt vé máy bay tại Aivivu, tham khảo

mua ve may bay di my

đăng ký bay từ mỹ về việt nam

vé máy bay đà nẵng nha trang

vé máy bay nha trang phú quốc

giá vé máy bay đi Huế

Mallela said...

Thanks for posting the best information and the blog is very helpful.data science interview questions and answers

Digital Marketing training - 360DigiTMG said...

Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.
Data Science Training in Raipur

Pallavi reddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
best data science courses in bangalore

Data Science in Pune said...

I found Habit to be a transparent site, a social hub that is a conglomerate of buyers and sellers willing to offer digital advice online at a decent cost.
Data Science Course in Pune

Datascience Books said...

Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
Data Science Training in Bangalore

data analytics books said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
data analytics training in bangalore

InstituteBlr said...

I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
data analytics course in bangalore

Unknown said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging endeavours.
data science course in bangalore with placement

Datascience Course Analyst said...

Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
Data Science Course in Bangalore

Data Analytics Courses in Bangalore said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
data science course fees in bangalore

Pallavi reddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
data scientist course in bangalore

Datascience Course Analyst said...

Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
Data Science Course in Bangalore

Pallavi reddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
best data science courses in bangalore

Mallela said...

Thanks for posting the best information and the blog is very helpful.data science institutes in hyderabad

Data Science said...

I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
Data Science Training in Chennai

Best Data Science Courses in Bangalore said...

I enjoyed the coursework, the presentations, the classmates and the teachers. And because my company reimbursed 100% of the tuition, the only cost I had to pay on my own was for books and supplies. Otherwise, I received a free master's degree. All I had to invest was my time.

Best Data Science Courses in Bangalore

Data Analytics Course in Bangalore said...

I like to see websites that include the price of free shipping from the excellent helpful resource. I really enjoyed reading your post. Thank you!

Data Analytics Course in Bangalore

Pallavi reddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
data scientist course in bangalore

Digital Marketing Course in Bangalore said...

Really impressed! Everything is a very open and very clear clarification of the issues. It contains true facts. Your website is very valuable. Thanks for sharing.

Digital Marketing Course in Bangalore

InstituteBlr said...

I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
data analytics course in bangalore

princika said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
data science course

Pallavi reddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
best data science courses in bangalore

princika said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
data science course in chennai

Data Science said...

I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
Data Science Course Syllabus

data analytics books said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
data analytics training in bangalore

Mallela said...

Thanks for posting the best information and the blog is very important.artificial intelligence course in hyderabad

Deekshitha said...

Informative blog
ai training in hyderabad

Data Science said...

I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
Data Science Training in Chennai

Data Science Course in Bhilai - 360DigiTMG said...

Honestly speaking this blog is absolutely amazing in learning the subject that is building up the knowledge of every individual and enlarging to develop the skills which can be applied in to practical one. Finally, thanking the blogger to launch more further too.

data science course in bangalore with placement

princika said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
data science training in chennai

Pallavi reddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
artificial intelligence training in chennai

Data Science Course in Bhilai - 360DigiTMG said...

Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.

data science course in faridabad

data science said...

Great to become visiting your weblog once more, it has been a very long time for me. Pleasantly this article i've been sat tight fosuch a long time. I will require this post to add up to my task in the school, and it has identical subject along with your review. Much appreciated, great offer. data science course in nagpur

Data Science said...

I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
Data Science Course Syllabus

Data Science said...

I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
Data Science Institutes in Hyderabad

Mallela said...

Thanks for posting the best information and the blog is very important.data science course in Lucknow

Unknown said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
data science course

Business Analytics Course said...

It's like you understand the topic well, but forgot to include your readers. Maybe you should think about it from several angles.
Business Analytics Course

Best Data Science Courses said...

It is late to find this act. At least one should be familiar with the fact that such events exist. I agree with your blog and will come back to inspect it further in the future, so keep your performance going.

Best Data Science Courses in Bangalore

Data Analytics Course said...

I wanted to leave a little comment to support you and wish you the best of luck. We wish you the best of luck in all of your blogging endeavors.
Data Analytics Course in Bangalore

Data Scientist Course in Dombivli said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data scientist course in delhi

Data Scientist Course in Dombivli said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. python course in delhi

Anonymous said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
aws training in hyderabad

Anonymous said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
business analytics courses

data science said...


I was basically inspecting through the web filtering for certain data and ran over your blog. I am flabbergasted by the data that you have on this blog. It shows how well you welcome this subject. Bookmarked this page, will return for extra. data science course in jaipur

Unknown said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, will provide more information on these topics in future articles.
data science course in london

princika said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
iot training in hyderabad

Nikita jawanjal said...

Amazing Article! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.If you are Searching for info click on given link
Data science course in pune

Deekshitha said...

Informative blog
best digital marketing institute in hyderabad

Data Science said...

I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
Data Science Course in Delhi

Deekshitha said...

Informative blog
ai training in hyderabad

Maneesha said...

Really impressive post. I read it whole and am going to share it with my social circles. I enjoyed your article and am planning to rewrite it on my own blog.
data scientist training and placement

traininginstitute said...

Your work is very good and I appreciate you and hopping for some more informative posts
data science course

Maneesha said...

Nice knowledge gaining article. This post is really the best on this valuable topic.
data scientist training and placement

Pallavireddy said...

i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
data engineering course in india

Professional Training Institute said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, will provide more information on these topics in future articles.

Digital Marketing Course in Bangalore

Educational Courses said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, will provide more information on these topics in future articles.

Business Analytics Course

Professional Courses and Training said...

It's like you've got the point right, but forgot to include your readers. Maybe you should think about it from different angles.

Best Data Science Courses in Bangalore

Educational Training and Learning said...

You have completed certain reliable points there. I did some research on the subject and found that almost everyone will agree with your blog.

Data Analytics Course in Bangalore

Digital Chandu said...

First You got a great blog .I will be interested in more similar topics.I commend you for your excellent report on the knowledge that you have shared in this blog.

digital marketing training in hyderabad
free digital marketing course in hyderabad

Unknown said...

Fantastic article I ought to say and thanks to the info. Instruction is absolutely a sticky topic. But remains one of the top issues of the time. I love your article and look forward to more.
Data Science Course in Bangalore

Unknown said...

I truly appreciate just perusing the entirety of your weblogs. Just needed to educate you that you have individuals like me who value your work. Unquestionably an extraordinary post. Caps off to you! The data that you have given is exceptionally useful.artificial intelligence course in noida

Maneesha said...

I really enjoyed this blog. It's an informative topic. It helps me very much to solve some problems. Its opportunities are so fantastic and the working style so speedy.
cloud courses in hyderabad

Tutorials said...

Nice article with valuable information. Thanks for sharing.

AWS Training in Chennai | AWS Training institute in Chennai

DataScienceEXPO said...

Thank you quite much for discussing this type of helpful informative article. Will certainly stored and reevaluate your Website.
Data Analytics Course in Bangalore

Unknown said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
iot training in noida

Data Science said...

Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one. Keep posting. An obligation of appreciation is all together for sharing.data science training in gwalior

Unknown said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
data scientist course in faridabad

DataBank said...

Nice to be seeing your site once again, it's been weeks for me. This article which ive been waited for so long. I need this guide to complete my mission inside the school, and it's same issue together along with your essay. Thanks, pleasant share.
Data Science training in Bangalore

Unknown said...

Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!data analytics course in bhubaneswar

Unknown said...

I truly like you're composing style, incredible data, thankyou for posting. data analytics course in kanpur

Professional Learning Institute said...

I'm always looking online for articles that can help me. I think you also made some good comments on the functions. Keep up the good work!

Data Science Course in Kolkata

Unknown said...

I am truly getting a charge out of perusing your elegantly composed articles. It would seem that you burn through a ton of energy and time on your blog. I have bookmarked it and I am anticipating perusing new articles. Keep doing awesome.data analytics course in ghaziabad

Professional Education Center said...

Very informative message! There is so much information here that can help any business start a successful social media campaign!


Data Analytics Course in Gorakhpur

360DigiTMG said...

Wonderful blog. I am delighted in perusing your articles. This is genuinely an incredible pursuit for me. I have bookmarked it and I am anticipating perusing new articles. Keep doing awesome!
data analytics training in hyderabad

Data Science said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.data science course in kolhapur

Data Science Course in Bhilai - 360DigiTMG said...

Extraordinary blog went amazed with the content that they have developed in a very descriptive manner. This type of content surely ensures the participants to explore themselves. Hope you deliver the same near the future as well. Gratitude to the blogger for the efforts.

Data Science Training

Data Science Course in Bhilai - 360DigiTMG said...

Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.

Data Science Certification in Bhilai

Unknown said...

I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, will provide more information on these topics in future articles.
data science course in london

Diksha Gupta said...

I like your post. I appreciate your blogs because they are really good. Please go to this website for the Data Science Course: Data Science course in Bangalore. These courses are wonderful for professionalism.

data science said...

wow, great, I was wondering how to cure acne naturally. and found your site by google, learned a lot, now i’m a bit clear. I’ve bookmark your site and also add rss. keep us updated. PMP Course in Malaysia

PMP Training in Malaysia said...

This post is very simple to read and appreciate without leaving any details out. Great work! PMP Training in Malaysia

Data Science said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
Continue posting. A debt of gratitude is in order for sharing.
data science training in gwalior

Data Science said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
Continue posting. A debt of gratitude is in order for sharing.data science course in warangal

Data Science said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting.
A debt of gratitude is in order for sharing.business analytics course in kolhapur

Professional Career Technology said...

Very informative message! There is so much information here that can help any business start a successful social media campaign!

Data Analytics Bangalore

Unknown said...

Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one. Keep posting. An obligation of appreciation is all together for sharing.data science course in bhubaneswar

Deekshitha said...

Informative blog
data analytics course in jamshedpur

Career Program and Skill Development said...

Very informative message! There is so much information here that can help any business start a successful social media campaign!

Data Science Course in Kolkata

DataScienceEXPO said...

Thank you quite much for discussing this type of helpful informative article. Will certainly stored and reevaluate your Website.
Data Analytics Course in Bangalore

data science bangalore said...

I finally found great post here.I will get back here. I just added your blog to my bookmark sites. thanks.Quality posts is the crucial to invite the visitors to visit the web page, that's what this web page is providing.data science course in rohtak

Career Academic institute said...

Very informative message! There is so much information here that can help any business start a successful social media campaign!

Data Analytics Course in Nashik

anonymous said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
data scientist course in delhi

Training said...

I am hoping the same best effort from you in the future as well and in fact your creative writing skills has inspired me.
Data Science Course near me

DataCharge said...

Very wonderful informative article. I appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks! .
Data Analytics training in Bangalore

Technical Knowledge said...

Very great post which I really enjoy reading this and it is not everyday that I have the possibility to see something like this. Thank You.
Best Online Data Science Courses

Anonymous said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
data science training in delhi

DataBank said...

Nice to be seeing your site once again, it's been weeks for me. This article which ive been waited for so long. I need this guide to complete my mission inside the school, and it's same issue together along with your essay. Thanks, pleasant share.
Data Science training in Bangalore

Courses said...

Nice Post i have read this article and if I can I would like to suggest some cool tips or advice and perhaps you could write future articles that reference this article. I want to know more!
Data Analytics Course in Gurgaon

Data Science said...


Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one.
Keep posting. An obligation of appreciation is all together for sharing.
data science course in gwalior

Data Science said...


Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
Continue posting. A debt of gratitude is in order for sharing.
data analytics course in kolhapur

EDU said...

I want to thank you for your time in this wonderful read which is really appreciable and put you in your favorites to see new things on your blog, a must-have blog!
Business Analytics Course in Noida

data science bangalore said...

I love your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone to do it for you? Plz reply as I’m looking to construct my own blog and would like to find out where u got this from. thanks a lot|data science course in jodhpur

prasad said...

I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
data science training in varanasi

IOT said...

Thanks for sharing this valuable information, we also provide instagram video download and,
really appreciate your hard work and good research that help us in for of your good valuable article. Keep updating us with your awesome content.

kumar said...

Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work! digital marketing course

Darkangle said...

Hey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work!

hr software in india
crm software in india

patna said...

The data scientists work on the raw data to take the right insights from it for making better decisions to make the business more prosperous.

data science training in patna

datascience course said...

A person who works on data, manipulates it, and takes the right outcomes from it, but did not deliver the message properly, then all the efforts are a waste of time.data science training in kolkata

deekshitha said...

Get the best Data Science online course at the comfort of your home. Flexible timings, Best industry trainers, and meticulously crafted curriculum. Avail now!!!!business analytics course in varanasi

nurturinghealth said...

Hii,
This is great and awsome post for me. i loved to read your blog. it's really-really amazing. thanks for inspired me by your blog.
Buy Online Pure & Natural Essential Oils
Buy Body Massage Essential Oil Online
Buy Hair Essential Oil Online Lowest Price
Buy Skin Essential Oil Online For Men/Women

Professional Academic Institute said...

Develop technical skills and become an expert in analyzing large sets of data by enrolling for the Best Data Science course in Bangalore. Gain in-depth knowledge in Data Visualization, Statistics, and Predictive Analytics along with the two famous programming languages and Python. Learn to derive valuable insights from data using skills of Data Mining, Statistics, Machine Learning, Network Analysis, etc, and apply the skills you will learn in your final Capstone project to get recognized by potential employers.

Data Science Course in Jaipur


Career Academic institute said...

Get a comprehensive overview of Data Science and learn all the essential skills including collecting, modeling, and interpreting data. Register with Data Science institute Bangalore and build a strong foundation for a career where you will be involved in uncovering valuable information for your organization. Learn Python, Machine Learning, Big Data, Deep Learning, and Analytics to take center stage in Data Science.

Business Analytics Course in Jodhpur

Professional Career Technology said...

Are you aspiring to become a Data Scientist and are confused about where to start? Enroll now with 360DigiTMG and begin your Data Science journey. A world-class curriculum, LMS Access, real-time projects, and assignments will aid you in becoming one.

Data Science Course in Bangalore with Placement

kumar said...

If your looking for Online Illinois license plate sticker renewals then you have need to come to the right place.We offer the fastest Illinois license plate sticker renewals in the state. data analyst course malaysia

Unknown said...

Simply just, take a log backup and shrunk the log file to the maximum possible. If it's not working, check log_reuse_wait_desc in sys.databases for a particular database. The values, Replication, AVAILABILITY_REPLICA, and TRANSACTION indicate a running transaction waiting at replication, waiting for acknowledgement from secondary or a long-running transaction, respectively, and troubleshoot accordingly. If you need any further clarification or help, email me on krunalpatel155@gmail.com
Thanks,
Krunal

Educational Courses said...

Learn to use analytics tools and techniques to manage and analyze large sets of data from Data Science training institutes in Bangalore. Learn to take on business challenges and solve problems by uncovering valuable insights from data. Learn from the comprehensively designed curriculum by the industry experts and work on live projects to sharpen your skills.


Data Science Course in Delhi

Professional Courses and Training said...

Companies are increasingly turning to data for decision-making and are depending on data professionals to do so. Develop strong logical and numerical aptitude and learn to work with R, Python, SQL, Hadoop, and statistical techniques like Linear Regression, Logistic Regression, etc. Sign up for the Data Scientist training in Bangalore, and gain expertise in using sophisticated analytical methods and statistical methods to prepare data for predictive and prescriptive modeling.


Data Scientist Course in Delhi

Educational Training and Learning said...

Are you searching for the best institute to start Data Science offline classes that will aid you in career growth, 360DigiTMG offers the best training with expert trainers and a job-ready curriculum. Enroll now!

Data Science Training in Delhi

sivakumar said...

This is because currently both SQL operators and Data Scientists come beneath the identical general definition of information science.data science course in indore

360digiTMG.com said...

Don’t let a pandemic affect your career growth, start your Data Science Online training today with 360DigiTMg and give your career the well-deserved boost it needs. Enroll now! best data science courses in chennai

360digiTMG.com said...

36DigiTMG offers top-rated courses in Data Analytics for your need and expertise. Get trained from industry experts with 170 plus hours of assignments that will help you bag a high-paying job. data science training in chennai

johnalvin said...


It's so good and so awesome. I'm just amazed. Thanks very much for sharing.
best hr software for small business | hr software usa