• Analyzing Existing Indexes

    Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

    Sqloholic25 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 (Performance Trace)

    Hi All, I have a job which is running since last 6 months. The job was taking around 2-3 hrs to be completed. However, for the last couple of weeks, its taking more than required time (Max-26 hours)and we have to kill the job for users to acces the database. I am not able to find any clue to it. I...

    Bakash0 pointsBadges:
  • LSXODBC and MS-SQL Stored Procedure Parameters

    Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.

    Mzrn1x5 pointsBadges:
  • Using answer as criteria in sql server

    I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is get the supply orders and so on. So essentially...

    Jeremyj545 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 pointsBadges:
  • SQL 2005 and Security Account Delegation

    I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.

    alessandro.panzetta9,725 pointsBadges:
  • Windows XP power settings not staying…

    The setup: Server: Windows server 2003. Workstations: Windows XP Mandatory roaming profiles. All computers login as the same user. I do not want the computers to go into standby or hibernate or turn off the monitor. I have configured mandatory profiles, set the workstations into 'Presentation'...

    Skepticals0 pointsBadges:
  • netgear storage with sql7

    i have a database stored in my netgear storage central. When I start my PC, it runs sql7 BEFORE the drivers for the Netgear, so my database can not be found. What can I do ?

    Simonedp5 pointsBadges:
  • Tracking Table Changes SQL Server 2005

    Is there a SQL Server 2005 script that would give all the table_names in a database, the last time they were updated and by whom? I've gotten as far as: select name, modify_date from sys.tables order by name but I can't figure out the "user" part.

    VelameLaCosa110 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • Connect SQL Server 2005 Express db to Visual Basic 2005 Express

    I get an error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but "Test Connection" gives me the same error. What can I do to resolve this error?

    Dhanson20 pointsBadges:
  • Copy old database as new

    Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com

    Krrish25 pointsBadges:
  • Upgrading RAM on SQL Server 2000

    We use Windows 2003 Server Enterprise Edition and SQL Server 2000 Enterprise Edition. We use the /3GB switch in the boot.ini in an attempt to use more memory, and we are considering upgrading to 8GB of total RAM on our server. Could this negatively impact us at all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading clustered SQL 2005 64 bit standard to enterprise

    Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

    Gazzer5 pointsBadges:
  • Achieving merge replication with SQL Express 2005

    I wish to achieve merge replication with multiple publisher nodes replicating to a central distributor which merges the data and publishes back out. However, I only have access to SQL Express 2005 with only one license for the full edition. Is it possible to achieve this with what I currently have?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Re-linking database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Update in SQL

    I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE SET SUBSTR(FLAT_FILE,2,2)= 'AA' WHERE SUBSTR(FLAT_FILE,1,2) = 'HH' The above SQL Query is throwing an error SQL0104 for missing token. Can anybody suggest me on the above. Thank...

    Vids295 pointsBadges:
  • Resetting the database

    I received the following error:RMAN-20042: invalid tablespace creation change# when i dried reseting the database after doing a restore from an Rman backup. I tried to unregister the database than register it back in rman but the problem still exist and getting the following even when i try to...

    Oradbsm5 pointsBadges:
  • Why do IT projects fail?-3

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    Dbrazeau10240 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following