Topics
Started by
Posts
Last post
I've been having some pesky tuning problems with Stored Procedures running via DTEXEC and through B…
8 replies
How do I optionally include a Contains search in my query, based on the input? In the below situati…
7 replies
Hi Polks, ;With Cte as ( --- some joining query here with 3 tables --first table has 30 crores rec…
5 replies
Hi Experts, We have a DB user names Supply . Application will hit the DB with this username. Is th…
2 replies
Hi, We have a stored procedure which updates table A every 5 mins whole day(9AM to 7PM).Table A has…
6 replies
Hi, Checking if anybody has a tsql script to display top 10 high MEMORY consuming queries? Thank yo…
8 replies
Hello! Do you have any good websites or books to read about best practice or advice for performance…
3 replies
Hi Experts, We got below error please help Msg 8951, Level 16, State 1, Line 2 Table error: table '…
14 replies
Hi Experts, This is kind of wired behaviour on part of SQL Server. 1. I have a query whose executi…
3 replies
We're planning to install a named instance of SQL 2008 R2 on a server that already has a default in…
3 replies
Hi, I'm using the Extended Events to monitor query perfomance in a SQL Server 2008 R2 instance, pro…
1 replies
Is it normal for this lastwaittype to last for the entire duration of a backup database command? We…
2 replies
In an Insert Trigger this code is sometimes quite slow: "SELECT @numrows = @@rowcount" This code i…
14 replies
how does With (Index (Index_Name)) help in fast query execution?? Does this emphasis on index menti…
7 replies
I was analysing an execution plan before and after creation of an index. Disk IO decreased consider…
9 replies
Viewing 15 topics - 496 through 510 (of 636 total)
You must be logged in to create new topics.