Topics
Started by
Posts
Last post
Hi pals, We have installed new server(W2K8 and sql 2008). The database has many tables and mill…
5 replies
I know most people advise logging to log files, and then moving them from log files into SQL Server…
2 replies
I have an Execution Plan which contains 9 queries, the following is a breakdown of their cost, rela…
4 replies
I just got in a new contract... get a load of this beautiful query : SELECT BIO_SR_ENVOI_ELEC_…
7 replies
I ran a profiler to capture activities on the production server for performance tuning, I then used…
9 replies
Hi... I have two functions that were taking 10-27 seconds to run. They were basically each getting…
7 replies
Hi, What are the recommended settings if iam using 64-bit os and sqlserver enterprise edition 2005,…
5 replies
Quick question, maybe you folks can point me in the right direction. I have a SQL instance that is …
5 replies
select distinct a.empid from ViewEmpployee a inner join #Empdates b on a.empid=b.empid,#researchtab…
5 replies
Hello, I am trying to trace execution of Informatica workflow against SQL Server 2008.I don't see a…
1 replies
Hi all, The total RAM is around 7.75 GB, but SQL server is consuming more than 5.5GB due to which …
4 replies
Hello, Any way to rewrite this query to better perform? Select SD.ORDER_ID,,MD.Origin, TR.Origin f…
2 replies
Roughly 50% of the total wait time in our production server is due to the BROKER_TASK_STOP wait typ…
1 replies
What wrong or time consuming thing in this query ? GROUP BY UPPER(C3), UPPER(C4)? NO OF ROW 500k+…
1 replies
Hi there everyone, We are trying to improve the way we doing this we our DB's: We have this new pro…
1 replies
Viewing 15 topics - 1,531 through 1,545 (of 3,249 total)
You must be logged in to create new topics.