Viewing 15 posts - 541 through 555 (of 583 total)
I think they were the originals right off the CD.
January 6, 2009 at 2:35 pm
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...
January 6, 2009 at 2:21 pm
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...
November 27, 2008 at 8:42 am
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...
November 9, 2008 at 1:02 pm
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...
November 6, 2008 at 8:38 am
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...
November 4, 2008 at 9:26 am
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...
November 4, 2008 at 8:15 am
I didn't even Realize this was the backup section 🙂
October 17, 2008 at 2:12 pm
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
October 17, 2008 at 1:20 pm
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,
...
October 2, 2008 at 9:47 am
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 ...
September 25, 2008 at 10:05 am
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...
September 25, 2008 at 9:23 am
DBCC SHRINKDATABASE will release unused space
September 17, 2008 at 12:11 pm
the stats on the name column were last updated August 26 and fragmentation is quite high, but gets reindexed usually three time a week.
September 9, 2008 at 10:42 am
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...
September 8, 2008 at 12:35 pm
Viewing 15 posts - 541 through 555 (of 583 total)