Dave Ballantyne (1/13/2011)

---

Ahh , you fell for that one , it is a myth that replacing cursors with a while loop is...

Will improve performance

Have to write it this way ,like this if the condition is true it does not continues for secound

if col1 is null it does not check if col1 =...

You can also write this query it to tell you what are the missing indexes

This will work only on db witch people working and apps are sending queries to...

Many indexes can slow down the update queries and the insert queries is this the reason that no indexes on the table

Please give feedback

--and this will give you every row as a table

DECLARE @LotsOfText VARCHAR(MAX)

SELECT @LotsOfText = BulkColumn

FROM OPENROWSET(BULK N'C:\temp\1.csv' , SINGLE_BLOB) AS x

DECLARE @row VARCHAR(50)...

--try this first create the function

create FUNCTION [dbo].[fn_SmallSplitVarChar] (@sText VARCHAR(8000),

@sDelim VARCHAR(20))

RETURNS @ret TABLE(

Value varchar(800)

)

AS

BEGIN

DECLARE @i INT

SELECT @i = 1

DECLARE @j-2 INT

WHILE...

Can you attach a sample file with data

sql_lock (1/12/2011)

---

To support @grants post I would do some benchmarking to know exactly what future performance would be.

I use an excellent tool that will allow you to exec...

this will give the data type

Select column_name,DATA_TYPE from Information_Schema.Columns

where table_name='your table'

or

Select column_name from Information_Schema.Columns

where table_name='YourTable'

or you can use

sp_help 'tablename'

this

select c.Name, c.colid from

syscolumns c

inner join sysobjects o

on c.id = o.id and o.xtype = 'u'

where o.name = 'Your_table_name'

order by c.colid

When you want to create a clr function that download the file

to the computer, or a clr function that will return the XML

Notice must be given to clr function

EXTERNAL_ACCESS...