Viewing 15 posts - 1 through 15 (of 27 total)
Under Cubes I can find dimension but how to find which dimension is coming from which data source ?
--------------------------------------------------------
I am Learner -- SQL
August 27, 2014 at 2:51 am
I am in SSMS -Analysis Service ,i want to find list of Fact tables and Dimension tables coming from each data source.
--------------------------------------------------------
I am Learner -- SQL
August 27, 2014 at 2:26 am
we are manually doing for long time,but i need to automate that one.
--------------------------------------------------------
I am Learner -- SQL
March 18, 2014 at 12:42 am
How to overcome this one ? pls guide me.
--------------------------------------------------------
I am Learner -- SQL
March 18, 2014 at 12:17 am
if you dont mind can you share any script or batch file to map network drive in start up task.
--------------------------------------------------------
I am Learner -- SQL
March 14, 2014 at 1:24 am
Can you try the below query.i hope it will help you.
select tbl.[name] TableName,
ind.[name] IndexName,
mn.index_type_desc IndexType,
mn.avg_fragmentation_in_percent [FRAG_%]
from sys.dm_db_index_physical_stats (null, null, null, null, null )as mn
inner join sys.tables tbl on tbl.[object_id] =...
--------------------------------------------------------
I am Learner -- SQL
March 14, 2014 at 12:39 am
I tried various possibilities,no luck...
here my small doubt i need IIS service in Server or i need to enable SMTP service in server ?
IIS and SMTP services are not available...
--------------------------------------------------------
I am Learner -- SQL
March 13, 2014 at 1:05 am
I am using my own mail Id for DBmail account.Test mail itself not going.
--------------------------------------------------------
I am Learner -- SQL
March 12, 2014 at 10:41 pm
Other server we are using window authentication credentials only.
--------------------------------------------------------
I am Learner -- SQL
March 12, 2014 at 5:48 am
I restarted SQL Server Agent also.But no luck.
--------------------------------------------------------
I am Learner -- SQL
March 12, 2014 at 4:53 am
SMTP Server IP is configured in Database mail Account.but mail is not delivery.Any services i need to enable in the server ?
From other server Database mail is working.
--------------------------------------------------------
I am Learner -- SQL
March 12, 2014 at 4:31 am
hi all
still i cant find the solution. please help me out.
this part get the latest seqno from table EPOSSDataExtractSequence, this seqno update every 40 min, once the scheduler run...
--------------------------------------------------------
I am Learner -- SQL
October 29, 2012 at 1:35 am
no bulk insert , reading line by line and inserting in to the table using .net scheduler.
--------------------------------------------------------
I am Learner -- SQL
October 25, 2012 at 8:37 am
Thanks for the help. we sort out the problem.we rework on the cursor which taking more time.
--------------------------------------------------------
I am Learner -- SQL
October 16, 2012 at 4:44 am
Really very thanks for all, i will work on it to increase the performance.
thanks alot.
--------------------------------------------------------
I am Learner -- SQL
October 15, 2012 at 7:10 am
Viewing 15 posts - 1 through 15 (of 27 total)