I had a similar issue a while back trying to add components to a sql server installation and it turned out that the windows installer registry key for the sql...

Thanks Rbarry. the server.logins namespace worked correctly. I will look into the enumerator object but if I cannot figure it out i will do it through sql. the reason i...

there will be 5 columns. The string to be parsed takes the form of

123456*123456*ABCDE*9876*1

columns 3 (ABCDE) and 4 (9876) are variable length of unknown...

Why do you want to do this? In other words, what is the actual requirement? I ask because sometimes there's a better way available.

And, what would the column...

I seem to have gotten it to work (kind of). i have created a stored proc which outputs what i need but i would like it searchable so I added...

The tally table is definately something I can use, thank to all who pointed it out. But I am now having trouble now getting all the parsed values into the...

I didn't even Realize this was the backup section 🙂

you could try making you stored proc use dynamic sql.

create procedure proc_name(@parameter varchar(200))

as

declare @sql nvarchar(max)

set @sql = 'select * from employee '+ @parameter

exec sp_executesql @sql

Could you assign the market rate to a variable then use that variable in you query?

declare @rate float

set @rate = select dbo.get_mkt_rate( ,...)

Select ord.amount,

...

in testing I see that nulls do in fact take up some space. Possibly my test is flawed. Could someone verify.

create table null_tst

(col1 varchar(4000) null)

sp_spaceused null_tst

yields result

null_tst0 ...

any copy would be sufficient(xcopy, copy/paste, drag/drop) for the sql installation files. And for the registry you can just open it with regedit and export. this will create file with...

DBCC SHRINKDATABASE will release unused space

the stats on the name column were last updated August 26 and fragmentation is quite high, but gets reindexed usually three time a week.

Thanks Michael. Adding the index hint to the query forced it to use the primary key thus performance is good(at least in test environment)

select A.name from validname with (index (PK_validname))as...

In my production environment the application runs query so it hasn't changed with or with out index. and the difference in time for me is 10 ms without name index...