Topics
Started by
Posts
Last post
hi I found index defragmentation as 66.66666667 % by executing SELECT database_id,OBJECT_ID,index…
5 replies
We have a SP with input parameter of date , but we got huge difference excution time between two da…
2 replies
Hi , I got Dead lock error message from error log file . its showing line number and object id .But…
5 replies
I need to perform a test where I have to gather performance metrics like consumed memory, CPU, I/O …
3 replies
Hello When i run the local report through reporting services at that moment system perfomance get…
4 replies
Am moving the table from one data base to another by using the select * into newdb..tablename from …
5 replies
Hi, We currently uses an SSIS package to import data from a flat file, every few minutes. These fi…
19 replies
I have a stored proc "spEmailList_Search" that takes two parameters: --If CampaignID is passed, we …
9 replies
Hi, I've SQL Server 2005 Dev Edition and Windows Server 2003 ENT SP2. in the task manager i see tha…
3 replies
We have a production database that has queries that took 15-20 seconds when the same query on a sim…
5 replies
I am told that Proc #2 is more efficient over Proc #1 due to the Begin/Commit when Proc(#1 or #2) i…
5 replies
Hi, I am using IBM websphere 6.1.0.9 and sql server 2005. I have a doubt on this websphere and sql …
3 replies
Can anyone let me know what are the steps to take or check if the query is taking more time than ye…
1 replies
I have the following code that I am trying to use the Tally table method to make this more set base…
9 replies
I'm testing a query in the same database. I have a table1 and table2 where table2 is a copy of tab…
5 replies
Viewing 15 topics - 2,731 through 2,745 (of 3,249 total)
You must be logged in to create new topics.