Forum Replies Created

Viewing 15 posts - 541 through 555 (of 583 total)

  • RE: SQL Server 2005 SP 3

    I think they were the originals right off the CD.

  • RE: SQL Server 2005 SP 3

    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...

  • RE: user,role, and login namespaces

    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...

  • RE: Parsed string into a view

    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...

  • RE: Parsed string into a view

    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...

  • RE: Parsed string into a view

    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...

  • RE: Parsed string into a view

    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...

  • RE: T-SQL sql server 2005

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

  • RE: T-SQL sql server 2005

    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

  • RE: Embedding function calls in a query

    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,

    ...

  • RE: Tables are big?

    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 ...

  • RE: What to backup before installing a Service Pack?

    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...

  • RE: Space for Database SQL Server 2005

    DBCC SHRINKDATABASE will release unused space

  • RE: specific character validation

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

  • RE: specific character validation

    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...

Viewing 15 posts - 541 through 555 (of 583 total)