how to database create fast through sql script with data?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hello,

I am creating c#.net windows application for run script for sql server database created, it's running very slow, It's a lots of data in my database.

I want to improve performance during database create.

How could that possible?

Thank You.

Ankit Agarwal
Software Engineer

Posted 16-Jan-13 20:37pm

ankit.agg1984

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*dan!sh* · Answer 1 · 2013-01-16T20:53:00

Solution 1

There are lots of reasons why that is happening.

1. Check you database schema: data types, indexing, constraints etc.
2. Check your queries, stored procedures etc.
3. Check the hardware and the way SQL server is set up.

Posted 16-Jan-13 20:53pm

dan!sh

Updated 16-Jan-13 21:06pm

v2

Shanu2rick · Answer 2 · 2013-01-16T21:03:00

Solution 2

You can see the possible reasons of your problem in Solution 1.
If you are using scripts, then don't. Use Stored Procedures, they are faster than queries. The reason is here here[^]

Posted 16-Jan-13 21:03pm

Shanu2rick

__TR__ · Answer 3 · 2013-01-16T21:15:00

Quote:
It's a lots of data in my database.

Here are a few CP articles on database performance optimization you might find helpful
SQL Server DO's and DONT's[^]
Database performance optimization part 1 (Indexing strategies)[^]
Database performance optimization part 2 (Index maintenance)[^]
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]
SQL Query Optimization FAQ Part 1 (With video explanation)[^]
SQL Server Performance Tips and Guidelines[^]
Video Tip:- Improve SQL Server performance by using SQL server profiler[^]