Performance Tuning

• Topics

  Started by

  Posts

  Last post

• SPROC's calling SPROC's and the Plan Cache...

  Yes forgive me I still maintain some VLDB's on SQL 2000 and trying to improve performance where I c…

  WaIIy

  2 replies

  11 years, 5 months ago

  By: WaIIy

• Request for the script of indexes

  Friends, Could any one help me to get the script which is suitable to below scenario. 1) It should …

  SQLAli

  2 replies

  11 years, 5 months ago

  By: Jake Shelton

• CAST Issue on join Creating index scan - poor performance

  I am having an issue with a query causing Index scan and poor performance: Here is an example of wh…

  JohnDBA

  1 replies

  11 years, 9 months ago

  By: LutzM

• Index views on SQL 2000 Standard

  Hi, My understanding is that it is possible to use create an indexed view in SQL2000 standard editi…

  krypto69

  1 replies

  11 years, 9 months ago

  By: Sean Lange

• Anyone any experience of Quest ActiveRoles QuickConnect?

  For some time now, we've been running Quest's ActiveRoles product for administering our Active Dire…

  majorbloodnock

  1 replies

  11 years, 9 months ago

  By: donpresidente

• Big View with many Union All

  Hello, i have a little problem with the performance for an view and i don't know which solution is …

  PowerUser

  2 replies

  11 years, 10 months ago

  By: malleswarareddy_m

• Cursor Issue

  Hello, I am using cursor for the first time. I have to print employee first and last name whose sal…

  pavithrareddyc

  6 replies

  11 years, 10 months ago

  By: Sean Pearce

• Weird timing with Audit Logout Event

  We are experiencing an issue involving a stored procedure run multiple times on 2005 on two differe…

  tedwards

  3 replies

  11 years, 11 months ago

  By: viv2484

• what is cross server query

  Hi,Good day anybody can provide me the details like a) what is cross server query b) how we can imp…

  RKGoriparthi

  3 replies

  11 years, 11 months ago

  By: Koen Verbeeck

• Protection level in SSIS

  "EncryptSensitiveWithPassword" stores the password in the package itself".But whenver I store the p…

  harsimranjeetsinghwasson

  3 replies

  12 years ago

  By: Koen Verbeeck

• Any Catalog view to find objects referred in other database in dynamic query

  Hi, Is there any catalog view for finding reference objects in other database or same but is writte…

  harsimranjeetsinghwasson

  5 replies

  12 years ago

  By: harsimranjeetsinghwasson

• Stored Procedure Performance

  I have one Stored procedure That takes around 2 hour to execute. it runs in 2 hours on server with …

  amardesai89

  1 replies

  12 years, 1 month ago

  By: Sean Lange

• Doubling up of Alpha numeric password

  I have a vb6 application and the database is housed on an SQL2000 server. My problem is that the v…

  glycere2000

  6 replies

  12 years, 2 months ago

  By: glycere2000

• Shrink large database

  I have been asked to look a a sql 2000 database that has been neglected for some time. It has an au…

  terry.home

  13 replies

  12 years, 2 months ago

  By: sqlsurfing

• SQL server performance troubleshoot using performance counters

  I am having sql server 2008 r2 server. I saw that yesterday the server so slow. When i see performa…

  IT researcher

  1 replies

  12 years, 2 months ago

  By: pnauta