Topics
Started by
Posts
Last post
select count(*) from products where prodID between 20987 and 21003 go declare @ProdID1 int declare …
8 replies
Hi all I'm looking for some general advice and hope someone can help 🙂 I have a database which is a…
14 replies
Working with PerfMon, using SQL Server: SQL Statistics: Batch Requests/sec SQL Server: SQL Statisti…
4 replies
Hi Sir , Some one , Please help me !! I am trying to optimize one store procedure The problem is…
3 replies
Hi there Which monitoring software do you guys and girls prefer to monitor about 5 sql servers ? An…
1 replies
I have attached DDL and test data, and also the actual execution plan of this query: DECLARE @url …
7 replies
how do i compar the two diffrence of the two tables having 900000 records Urgent Query
8 replies
i have a db with transaction log initial size as 40 and it is increasing to 100mb then again it get…
9 replies
Hi all I need the links for the query optimization , controls of the CPU USAGE ,.. regards sat_S…
4 replies
Background System: Windows 2003 R2 Enterprise SP2 24GB Ram 8 Processors SQL Server Standard (64-bit…
16 replies
Dear All, One person asked me the following questions in an interview. Pls help. 1. Suppose I have…
5 replies
Hi all, Recently I learned about CURSOR and I found most experts advise not to use it due to perfor…
15 replies
Which one is Better and why ? Use SQL subselects to consolidate queries on multiple tables into a s…
10 replies
I WRITTEN A STORED PROCEDURE LIKE THIS BUT ITS TAKING LONG TIME TO EXCEUTE,WE HAVE 50 TO 100 TABLES…
5 replies
Perfmon is throwing me the next error: The exception unknown software exception (0xc0000409) occur…
2 replies
Viewing 15 topics - 1,756 through 1,770 (of 3,249 total)
You must be logged in to create new topics.