Σε Εξέλιξη

SQL Server script to delete all non-clustered indexes with their history from a SQL server 2008 database

We have an accounting database in SQL Server 2008, we are unhappy with its performance. To this end, we want to use optimization tools like Qure optimizer, SQL Doctor etc. to tune it. There are many non-clustered indices and hundreds of SQL query statements in the database. We would like to delete all the non-clustered indices and their historical statistics and create a workload to subject it to the Optimizer for recommendations for the creation of new indices. We need SQL statements that will do this task.

Δεξιότητες: SQL

Δείτε περισσότερα: php script sql server database backup, perl script connect sql server database, script server database information, freeradius server database store process, update sql server database csv file, save images sql server database telerik, pdf files sql server database, convert sql server database access database, automatic backup sql server database, net client code connect sql server database, converting access sql server database, sql server database java servlet, ping sql server database, asterisk server database

Σχετικά με τον Εργοδότη:
( 6 αξιολογήσεις ) Jeddah, Saudi Arabia

ID Εργασίας: #11755857

Ανατέθηκε στον/στην:

manu0417

I am a Microsoft Data Platform MVP who work on SQL Server Database day in and day out. I deal with performance tuning databases and queries. Trust me, I will be the best you will get to get this work done on Freelancer Περισσότερα

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0

6 freelancers are bidding on average $24 for this job

$23 USD σε 10 μέρες
(27 Αξιολογήσεις)
5.3
vinaysinghh

A proposal has not yet been provided

$25 USD σε 1 μέρα
(18 Αξιολογήσεις)
4.1
designsmaker0

A proposal has not yet been provided

$15 USD σε 0 μέρες
(1 Αξιολόγηση)
1.1
lkrajahar81

I have more than 5 year experience in database and web development. I believe long term relationship with customer satisfaction.

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
dat2na

Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs lik Περισσότερα

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0