Search Results | SQL Server Performance Forums

Performance Benefits (Combined Index Vs. Single Index)

Thread by: Sandy, May 5, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I just come across a topic and trying to find out the differences between a combine Index and Individual Index. What I exactly I mean to say,...

SP_Executesql Issue

Thread by: Sandy, Apr 29, 2009, 6 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I just curious to know why this is not happening...?? Let say, I have 5 dynamic Sql statements like str1, str2, str3, str4, str5. When I am...

how to convert Excel File to ZIP file in CMD/TSQL

Thread by: Sandy, Apr 29, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I am facing a issues with Email sending with an attachment by using Stored Procedure. I am having a excel report which need to send to user...

LAG & LEAD Function in MS Sql Server

Thread by: Sandy, Apr 9, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, One of my friend just now asked me in Sql LAG & LEAD Function exists or not? for ex: { ---- LAG (Min(id), 1, 0) OVER (ORDER BY Min(type)) AS...

I need a Simple Select Query

Thread by: Sandy, Apr 8, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi Friends, I just curious to know why it is not happening with me I have a Sql select Statement which returns a 20 number of record set. The result...

Statistics & Index scripting Issue

Thread by: Sandy, Apr 7, 2009, 6 replies, in forum: SQL Server 2005 General Developer Questions

Hi Friends, I need a clarification. What is Statistics & Why it is used & why itâ€™s present in my lower level of table? I saw two statistics in...

What is Included Column?

Thread by: Sandy, Apr 5, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I saw new concept of included column in sql 2005, but when I was trying to create index. I just wanted to know what is it and I have a small...

Choosing Primary Key and Indexing on Table

Thread by: Sandy, Mar 30, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, In one of database in my production server, I found few table are not having primary key and some of the table missing indexes... So here my...

Transaction Open Error

Thread by: Sandy, Mar 26, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

HI All, I am using sql 2005 as my database and Excel is my Interface. I have written some macro's on it. Let say I have to insert 100 nos. of...

Change Background Color Dynamically in SSRS Report

Thread by: Sandy, Mar 26, 2009, 2 replies, in forum: SQL Server 2005 Reporting Services

Hi All, I need a small help for the above topic. I have report which displays the Details of expenses report in SSRS. Report Format...

View and Inner View

Thread by: Sandy, Mar 23, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, As per my requirement, I need a VIEW which gives a resultset from multiple tables. But my requirement is little different, what I wants that...

ER Diagram

Thread by: Sandy, Mar 10, 2009, 12 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, In my Development Box one Database having more than 200 tables is present and I want to know the Relationship between the entities. There is...

How to tunning my Sql Code.

Thread by: Sandy, Mar 2, 2009, 9 replies, in forum: General Developer Questions

Hi All, I wants to know how to excute my query faster. I have a code of line 1000 lines. I wants to tune it..can you please tell me what are the area...

How to Call a SP from another SP..

Thread by: Sandy, Mar 1, 2009, 2 replies, in forum: General Developer Questions

Hi All, I wants to call My Stored procedure from main stored procedure. Its working fine.. but how can I know if any error happen in the execution...