Search Results | SQL Server Performance Forums

TOP 100 PERCENT Performance

Thread by: muko67, Sep 5, 2008, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I have a query like the following statement. My Problem with TOP 100 PERCENT takes this query 12 Seconds time, but if I remove TOP 100 PERCENT I...

Difference between INDEX and CONSTRAINT

Thread by: muko67, Sep 1, 2008, 5 replies, in forum: T-SQL Performance Tuning for Developers

Hello, Suppose I have a huge table with 10 Columns. I create a unique constraint on the columns (col1, col2 col3) If I use theese columns in a...

Object_name function

Thread by: muko67, Jul 6, 2007, 4 replies, in forum: General Developer Questions

Hi, I'am looking for an alternative function of object_name(objid) with a second parameter database_id, because I'am working in master database and...

syslockinfo rsc_objid

Thread by: muko67, Jul 3, 2007, 2 replies, in forum: Performance Tuning for DBAs

Hi, How can I get the right object_name of rsj_objid column in SELECT statement using master database. Is there any another function like...

SQL Profiler Procedure-Subqueries

Thread by: muko67, Jun 18, 2007, 3 replies, in forum: Performance Tuning for DBAs

Hi, Is there any possibility to measure start/endtime of a subquery in the procedure like in the following example. I can see start/endtime, if a...

fn_getsql function

Thread by: muko67, Jun 12, 2007, 2 replies, in forum: Performance Tuning for DBAs

Hello, Why I don't get any resultset, when I execute the following SQL Statements. SPID is valid. Thanks in advance. declare @handle binary(20)...

SELECT * FROM DBCC xxx

Thread by: muko67, Mar 21, 2007, 5 replies, in forum: T-SQL Performance Tuning for Developers

Hi, Is there any possibility to use the output of DBCC xxxx commands as a subquery? Because I didn't achieve it. My goal is to insert certain...

Buffer/Stored procedures Cache content

Thread by: muko67, Mar 7, 2007, 2 replies, in forum: General Developer Questions

Hi, Just I want to read buffer cache content, but I didn't find out any information about. If someone does know how to read or another source where...