MS SQL Server :: Third Party Reindexing Utilities

16 Bit-client Utilities

Mar 30, 2000

Hi all,

I am going to upgrade a SQL server 6.5 box to SQL7.0. The 16 bit-client utilities are a prerequisite because there is a 16-bit application and requires some of the database libraries. My question is how does SQL7.0 deal with 16-bit application? In my case, could I upgrade the SQL6.5 box to SQL7.0?

I appreciate any input and help ahead,

Stella Liu

View 1 Replies View Related

Palm Utilities For DBA

Feb 23, 2001

Does anyone have any palm utilities, or reference docs, urls - I am administering SQL7 and would like info on Palm-3, using as a references. I have ModileDB installed, with Oracle Recovery references, but could not find SQL.

thanks,
Jason

View 3 Replies View Related

MS SQL Utilities For Documentation

Oct 16, 1998

I am looking for good utilities that document MS SQL table schema, indexes, layouts etc. I am currently looking at SQL auditor, but this product does not give me table schema or any kind of device revisions. I recently was given several SQL servers that have not been documented in any way.

thanks

ps SQL auditor gets a B+ in my book. Let me know what you think

View 2 Replies View Related

Sql Server Utilities

Apr 16, 2002

HI

Would like to know whether SQL server has the utilities do the following and the command to activiate the followings:
- limit the no. of login (ie to set the number of failed_login_attempts)
- password_reuse_max (eg password A can only be reuse 3 times)

tia
MK

View 1 Replies View Related

Reindexing

Apr 15, 2002

Attempt to fetch logical page (1:166354) in database 'pm_pmc_prod' belongs to object '837120', not to object 'ng_visit'.

I got his error while importing data into the error, when i ran dbcc checkdb it gave me Msg 8928,8942,8976 etct witl serverity level 16...

is it possible to fix this curropt tables?

View 2 Replies View Related

REINDEXING IN VER 7

Jun 22, 1999

We load tables from text files for inquiries.
My procedure is to truncate the table
Use DTS to move the text file into the table
do the command DBCC DBREINDEX (TABLE,'')

Am I wasting my time?
Does SQL 7 rebuild the indicis as it loads the data from the text file?

View 1 Replies View Related

How And When Reindexing A Db?

Aug 16, 2006

Hello guys,

Two things:

1) Could somebody explain me how to reindex all tables in my db?

2) How do I know when I should reindex my db?

Thank you very much for any help!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 4 Replies View Related

Client Utilities For MSDE

Mar 23, 2005

Hi,

I heard from a guy that the client utilities (Enterprice Manager and Query Analyser) that are on the Sql Server 2000 CD can be fetched separatly from Microsoft and that they can be deployed with MSDE to a potential customer.

Is that correct?

And if it is, where can I obtain those client apps?

TIA

Ohlywohly

View 2 Replies View Related

SQL Server Network Utilities

Jan 13, 2006

Hi everyone,
Can anyone tell me the basic difference between Client Network Utility and Server Network Utility and also when to use what..?????

View 1 Replies View Related

Removing SQL Utilities Off Server

Aug 27, 1998

Does anyone know how to remove SQL utilities off the server manually.
When I run the setup.exe from the SQL CD to remove SQL from server that option button is
shaded, I try reinstalling SQL utilities and then I try removing and still it won`t let me?
Help!!!

View 2 Replies View Related

DTS Version Control Utilities?

Jun 15, 2001

We are looking for utilities to help us manage DTS packages. Specifically to help us track changes in the packages in a fairly fine-grained fashion; several layers deeper than the version listing under package info, for example. Think of it as an object-oriented diff utility if you will, something that can report on changes in a package very specifically; for example, we need to know that step 4 of a package is a SQL widget and the text has changed between versions, and what the changes are. Converting the package to a VB project & versioning the source text doesn't work, for several reasons too complicated to state here.

Is there aything like this available? We would rather buy than build, but I haven't seen anything like this yet. If anyone has experience with such a utility I would appreciate knowing about this. Thanks.

Jim Rivera
Software Engineer
Grange Insurance Graoup
Seattle, WA

View 1 Replies View Related

Reindexing Tables

Sep 17, 2001

I've just recently tried to perform a scheduled reindexing job with the following command:

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"

Unfortunately, this command has only finished once of the five or six times I've tried to run it. The times it has failed, it deadlocks behind what seems to be a succession of other transactions. How can I make sure this command finishes?

View 1 Replies View Related

Reindexing Tables

Dec 27, 2002

Hello Everyone,

I need to rebuild all indexes in one table, is there any command that will do automatically instead of deleting and recreating them all?

Any help will be appreciated.

Thanks

View 3 Replies View Related

Table Reindexing

Nov 15, 2007

Hi All,
is it really improve performance that making table reindexing?

what i mean to say is i've one script, which will automatically drops all the indexes in a database, and reconstruct them with the same name.

is it really worth doing that?.....

thankyou very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 10 Replies View Related

Reindexing A Database...

Oct 18, 2007

All,

I've got a medium sized database in a mirror configuration with witness. The database size is about 300gb and I would to reindex all of the tables in the database. My process would go something like this:

1) Backup principal
2) Break the mirror
3) Set the principal database to simple recovery mode
4) Perform the reindexing
5) Backup the principal and transfer that backup to the mirror

6) Restore the backup
7) Re-establish the mirror

Does anyone see any issues with the process itself?

Regards,

Ian

View 4 Replies View Related

Refragmentation And Reindexing

Dec 27, 2007

Hi experts,
For defragmenation and reindexing they are using the below cursor, and now they have asked me to remove the cursor and schedule the job accordingly to do the same functionality, so what will be the other way we can do without cursor? can you plase let me know the solution?

DECLARE @Database VARCHAR(255)
DECLARE @Table VARCHAR(255)
DECLARE @cmd NVARCHAR(500)
DECLARE @fillfactor INT

SET @fillfactor = 90

DECLARE DatabaseCursor CURSOR FOR
SELECT database_name FROM dbadmin.dbo.tdbstatus WHERE status='y'
AND database_name NOT IN ('master','model','msdb','tempdb')
ORDER BY 1

OPEN DatabaseCursor

FETCH NEXT FROM DatabaseCursor INTO @Database
WHILE @@FETCH_STATUS = 0
BEGIN
SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT table_catalog + ''.'' + table_schema + ''.'' + table_name as tableName
FROM ' + @Database + '.INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE'''

-- create table cursor
EXEC (@cmd)
OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @Table
WHILE @@FETCH_STATUS = 0
BEGIN

SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'
EXEC (@cmd)

FETCH NEXT FROM TableCursor INTO @Table
END

CLOSE TableCursor
DEALLOCATE TableCursor

FETCH NEXT FROM DatabaseCursor INTO @Database
END
CLOSE DatabaseCursor
DEALLOCATE DatabaseCursor

Your help will be appreciated.

View 1 Replies View Related

Loadbalancing Utilities - For Clustered SQL 2000

Feb 20, 2001

Hi all ,

I would like to know about third party tools available or sites where I can get some evaluations on this tools to load balance our Clustered SQL 2000 on Windows 2000. Thanks for the help In Advance.

Shaji

View 2 Replies View Related

Maintenance Plan, Reindexing

Mar 24, 2005

In the Enterprise Manager of SQL Server 2000 I have set up a maintenance plan which rebuilds my indexes. I've stuided the documentation, and from what I've learned what happens behind the curtain is that several DBCC REINDEX commands are being issued.
Question:
If I have 20 tables and 40 indexes: Will SQL Server do the maintance plan in 1 single transaction, or will it divide the it up to eg. 20 or 40 transactions?

-h

View 1 Replies View Related

Reindexing Vs Update Statistics

Nov 22, 2004

Hi

We are upgrading from sql 7 to 2000.During the upgrade process do we have to do a reindexing of all tables or will update statistics take care of that.

Or do we have to do both?
What is the difference between reindexing and update statistics.

Thanks

Madhukar Gole

View 5 Replies View Related

Reindexing And Transaction Logs

Dec 14, 2004

Hi All,

Just after some feedback on a scenario where we have full logging setup on one of the databases, and the transaction logs are backed up every 60min. At 0000-0100 the log jumps from being a few thousand k up to over 1.7gb.
I did some profiling for this time, and it appears that this jump is related to the reindexing of the indexes on the database.

Is this normal for the log file to jump in size so much? Or is this an indication of some other issue (potentially with the indexes)?

Is there any way that the reindexing can be excluded from the log files or is this a necessity?

Thanks in advance for your help.

Cheers
Troy

View 4 Replies View Related

Reindexing Of Database Tables

May 27, 2008

hi
i have reindex of the tables
is it really improve performance that making table reindexing ?

View 1 Replies View Related

Effect On Snapshots While Reindexing

Apr 30, 2007

Does someone know if doing a reindex on a clustered or non-clustered index cause the snapshot file to grow? In other words, is the data that makes up the snapshot copied from the source to the snapshot database? If a normal reindex is done on the underlying database, will it block users from acessing the snapshot? Any help would be appreciated.

View 1 Replies View Related

ReIndexing All Tables In A Database

Sep 5, 2006

I need to reindex all tables in my database and would like to do this without using a Cursor. What is the simplest way to achieve this.

Cheers

Nat

View 2 Replies View Related

Reindexing On A Mirror Environment

Oct 18, 2007

All,

I've got a medium sized database in a mirror configuration with witness. The database size is about 300gb and I would to reindex all of the tables in the database. My process would go something like this:

1) Backup principal
2) Break the mirror
3) Set the principal database to simple recovery mode
4) Perform the reindexing
5) Backup the principal and transfer that backup to the mirror

6) Restore the backup
7) Re-establish the mirror

Does anyone see any issues with the process itself?

Regards,

Ian

View 1 Replies View Related

Database Reindexing And Mirroring

Apr 25, 2008

Hi,

We have scheduled a job for DB Reindexing (Maitinance Plan) for a OLTP database on sunday.

We have used mirroring for automatic failover with a witness server now the DR Reindexing job fails after 30 mins without any error.

Please let me know why Database reindexing gets failed.

Regards
Sufian

View 16 Replies View Related

Installing SQL 6.5 And 2000 Client Utilities On The Same Machine

Aug 24, 2004

Can I install the client utilities for Microsoft SQL versions 6.5 and 2000 in the same machine?

Please, provide me with any information or links in this matter.

View 5 Replies View Related

Utilities To Check For Errors In Stored Procedures

Jul 20, 2005

I have written a utility that checks our stored procedures forpotentially incorrect code (eg = null as opposed to is null, unusedvariables/parameters etc). It also ensures that parameters/variablesetc match our naming conventions and data types/sizes are the sames asthe corresponding type in the database (if appropriate)Are there any other utilities that do this sort of thing?

View 1 Replies View Related

Utilities For Comparing Stored Procedure Results?

Dec 11, 2007

I have large stored procedures in SQL Server 2005 that often get updated. Sometimes it is very difficult to recognize how one change could impact the overall results. I would like to have some sample input that I could test during changes and see it compare the data results before & after my changes. This would help me quickly identify if the results are fine to pass through.

So basically I would like an easy way to compare the results of 2 stored procedures. Any suggestions or utilites that would help me do this?

View 3 Replies View Related

CLR Programming: Best Place To Define Utilities Functions

Apr 27, 2007

Hallo,

I find the CLR integration very handy and I would like to use it in the proper way but I need some helps because is not easy to find "best practice" programming info.

This is what I have to do: from a "period" coming from the DB I have to compute start/End date and save them in the DB.

The computation involves regular expression and several functions that makes several calculations on date type variable.

I have created my UserDefinedFunction class that contains the TV function to return a row with 2 fields (startdate,enddate).
Now my question is: what is the base place to define my utilities functions that perform the computation?
In the same class or it is better to add a new class?

For example I have created a module that contains all the Regular expressions patterns.

Any help is appreciated!

Thankx

Marina B.

View 1 Replies View Related

Reindexing Tables On A Databse That Is 36GB

Nov 3, 2005

Hello,

I'm looking for the query command that will go out to all the user Tables and will tell me what Indexes need to be reindexed.

We are having a problem with some of the tables and we don't know when our tables need to be reindexed other than when operations are stopped for our company.

Thanks,

Ron

View 2 Replies View Related

Extent Fragmentation High Just After Reindexing

Jul 18, 2007

Hello. When reviewing the DBCC SHOWCONTIG immediately after reindexing all indexes on a database, I see the ExtentFragmentation has values like 50 to 70%... These are SQL 2005 tables with clustered PK's, no large varchars/blobs, and at least 100 pages in the index... The numbers related to PAGE fragmentation are ok after reindexing, but not the EXTENT fragmentation numbers.

I noticed the drive is in need of being defragged at the disk level. Is that a reason why reindexing doesn't fix the Extent frag numbers?? ANy other ideas on this? I can try defragging the DISK over the weekend, bringing the database offline then, but any other thougths on why the Extents show these high %'s? Is there any command to reset them and maybe that isn't happening? Like must I do update usage to get valid Extent frag #'s??

If there were MANY autogrows on the files, is that a different level of fragmentation? and how could all those small pieces of files be pulled back together? Thanks, Bruce

View 7 Replies View Related

Compare Utilities For Comparing Stored Procedure Results?

Dec 10, 2007

I have large stored procedures in SQL Server 2005 that often get updated. Sometimes it is very difficult to recognize how one change could impact the overall results. I would like to have some sample input that I could test during changes and see it compare the data results before & after my changes. This would help me quickly identify if the results are fine to pass through.

So basically I would like an easy way to compare the results of 2 stored procedures. Any suggestions or utilites that would help me do this?

View 6 Replies View Related