Viewing 15 posts - 1 through 15 (of 78 total)
We had same issue on a sql 2008 Sp1 box.
The Analysis Service was pointing to folder "d:\program files\microsoft sql server\msas10.mssqlserver\olap\config" for the msmdsrv.ini file. However the config folder was at...
November 24, 2010 at 7:12 am
Nice to see comments after long three years..:)
August 8, 2008 at 7:44 am
Oh finaly its done..
changed regional setting to US (english) and went to custom setting and opted for SQL collation 1252..;)
Thanks you all for ur valuable comments..
binu john
November 20, 2007 at 6:32 pm
Thaks..But any ways I can change the SQL Server 2000 collation to SQL_Latin1_General_CP1_CI_AS(which is default to SQL7)..I have tried to re install and opted for custom setting--collation--sql collation..still No luck;)
How...
November 20, 2007 at 5:36 pm
Just try this also
SELECT
'EXEC sp_change_users_login ''Update_One'', ''' + su.name + ''', ''' + su.name + ''''
FROM
sysusers su
LEFT JOIN master.dbo.syslogins sl ON su.sid = sl.sid
WHERE
uid > 3-- exclude public, dbo, guest,...
October 31, 2007 at 8:56 pm
Do you give computerName\userName or DomainName\userName?
Just a workaround..just activate your builtin administrator..let us see how it works.
binu john
October 23, 2007 at 1:14 am
Probably this would be appending the backup to same file.:D
binu john
October 22, 2007 at 11:33 pm
That is it Matt.
If we can maintain an index with proper fill factor and reorgs, identity or non identity coulmn wudnt be a performance bottleneck...;)
But I dont think I can't...
October 22, 2007 at 6:50 pm
Jeff can you please tell me If I creates a Clustered index on a Primary (Not a indentity) column on table that has good amount of writes how it...
October 22, 2007 at 2:25 am
Hi rudy
Can you please tell me how this effect performance..
--------Got clustered primary keys on big transactional tables?
binu john
October 21, 2007 at 8:20 pm
Thanks Arun..that too doesnt suit to my requirement.:hehe:
I have a script which does dbcc index defrag and if required reindexing but can do for one database and need to run...
October 17, 2007 at 9:33 pm
Thanks Arun..
The given script does a index defrag, but my requirement is slightly different. :hehe:
If the fragmentation level is low (eg ~30) then opt for index defrag or if...
October 14, 2007 at 10:50 pm
Thanks Lowell..
It doesn’t help me either.:w00t:
This script reindexes all user and system indexes in the database using the original fill factor allocated to that index.
I am looking for something...
October 14, 2007 at 9:37 pm
Viewing 15 posts - 1 through 15 (of 78 total)