CREATE FUNCTION [dbo].[uf_utl_SplitNString]

(

@InStr nvarchar(4000) = null ,

@token nvarchar(4000) = ','

)

RETURNS @RtnElement TABLE ( item nvarchar(4000))

AS

BEGIN

declare @rec_no int

declare @pos int, @tokenlen int

declare...

/************************************************************************

*

* Author: Rafal Skotak

* Purpose: Procedure displays amount of disk space used by databases per directories

* Date: 2008-01-14

*

************************************************************************/

if exists(select * from sysobjects where id = object_id('dbo.proc_get_db_files_size') and xtype = 'P')

drop...

finally i got fix for this problem instead oif having concatenated email id , i replaced it with group ( active directory email group ) which contains all email...

tosscrosby (5/4/2010)

---

Bhuvnesh (5/4/2010)

---

Brandie Tarvin (5/4/2010)

---

There's...

Paul White NZ (5/4/2010)[hrHave you considered using a SELECT...INTO statement to create the table at the same time as loading? This can be minimally logged too, and is generally...

Brandie Tarvin (5/4/2010)

---

There's a joke here I...

Santosh Bandhu (5/4/2010)

---

What I read I can use PARTITION BY clause with aggregate functions to more or less achieve similar result set as with using GROUP BY clause (probably event...

can you give any example ?

now i am curious to see execution plan

still you need any help , you are welcome:-)

NewBeeSQL (5/4/2010)

---

Nope..you misunderstood..

overlapping indexes are the indexes which overlapped over the columns...for example..if i have 3 indexes..

index 1 is on Table1 on col1,col2,col3

index 2 is on Table1 on col1,col2

index 3...

ok thats fine , find out the culprit...

what do...

Drammy (5/4/2010)

---

Yes, there is indexing on the source tables.

I have run this through the SQL Database Engine Tuning Advisor on a few different sample databases now and have built the...

and what about the source tables (included in left joins ) ?