Topics
Started by
Posts
Last post
I've been running perfmon and analysing the results on a production Windows 2008 R2 server running …
8 replies
Hi All,I have a sql statement working on static tables (no Insert,Update,Delete) on our testing ser…
27 replies
Hi Everybody,The wait stats on the database I am assigned for performance tuning , shows that the P…
9 replies
Hi Everybody,In some query plans we see some iterators have a non-zero cost even when the query cos…
2 replies
Hi, I'm a DW/ETL developer and I've created a data load process to load an aggregated table in my d…
8 replies
Hi All, I have a question please about caching and buffering.Is there a difference between how a vi…
9 replies
Hi I have some SQL code that is producing multiple execution plans. SQL Handle …
2 replies
Hi!I'm investigating into some slow transaction log restores - mostly they are from the larger tran…
9 replies
Hello All, I'm tracking down a performance issue with merge replication. I found a query that is ex…
1 replies
Hi All, Yesterday on a production environment we got complaints about very bad performance.I logged…
5 replies
We just took over this SQL server application and have been working on the really bad queries. We t…
1 replies
Dear colleagues,I am setting up extended events in a SQL Server 2008R2 SP3 with an interests in get…
5 replies
Hi all, I don't think there's a greater test of one being a DBA than being faced with a performance…
5 replies
following qry is taking more than 3 hrs to run , it has billion records in each table, is there an …
6 replies
Hello, after having made an archive on a database (pruge outdated rows in tables), I have a query t…
10 replies
Viewing 15 topics - 46 through 60 (of 635 total)
You must be logged in to create new topics.