Topics
Started by
Posts
Last post
My original understanding is for best performance, one should put data (with clustered index) seper…
1 replies
Hi guys, I am executing this query in the query analyzer 2005.I am the sysadmin to the server. wh…
3 replies
Hi Everybody, I have a table having Five Columns CREATE TABLE TABLE_X ( Col1 INT NOT NULL, Col2 var…
5 replies
in my project, per second, i fire 14 insert query which insert two fields (1)time(varchar(11)) and …
1 replies
I have a very large table called People, with a field (int) named PersonID serving as the primary k…
12 replies
Hi Guys I have two queries which gives same results Query 1--------------> SELECT ColA ,COUNT…
10 replies
Hi all, I have two tables tableA and tableB.tableA is the parent of tableB.The primary key o…
1 replies
I have application who like to use HTTP Endpoints in our cosolidate enviornment. How I can measure …
1 replies
We are running SAP on sqlserver 2k5 and having high I/Os. Does anyone know what the optimum block s…
5 replies
I have been reviewing some older code, and found a delete statement without a where clause. Not a b…
15 replies
I've read and noticed SQL 2005 handles memory differently then 2000. In 2000 if I told a serv…
23 replies
What are the differences between a seek and scan index? why and when do we use them? When exactly t…
5 replies
Hi All, 🙂 I'm working in an MNC.presently i'm dealing with performance issues related to que…
10 replies
Hi, Facing a situation where the execution plan shows both an index seek as well as KeyLookUp. The …
9 replies
Hello.... I use some Nested Set Tables to generate Rights to a Different Tables. The Following View…
5 replies
Viewing 15 topics - 2,896 through 2,910 (of 3,249 total)
You must be logged in to create new topics.