Viewing 15 posts - 16 through 30 (of 52 total)
I ran into the same issue when executing a MDX query against an SSAS 2014 database via an SSIS 2008.
The SSIS package is for cache-warming purpose.
The Profile Trace shows that...
June 10, 2015 at 8:48 am
Gail,
Thanks.
Now I understand. MaxDop sets the max # of threads/processes per operator, not per query/spid. If the query plan of my query decides to use 15 operators, and each of...
May 8, 2015 at 9:06 am
Gail,
With the MaxDop set as 3, I got 41 threads count at one time, using "exec sp_who2 70", where 70 is the spid of my query. I am confused. Is...
May 7, 2015 at 11:53 pm
Thanks. The cost threshold was set to 50 initially. Now I see the # of processes for my query stay as 4. So my MaxDop change did take effect.
April 29, 2015 at 3:11 pm
Thanks.
I think I understand it now. Because NetworkService or LocalSystem accounts are LOCAL accounts, they are not visible outside the local server and makes no difference outside the server.
So...
April 29, 2015 at 3:02 pm
I might have confused others with the code below. Its purpose is to show that SQL Convert function can handle date in Year 200, while ISDATE function cannot.
select convert(date,'04/01/0200')
select...
April 8, 2015 at 12:56 pm
Sean Lange (4/8/2015)
April 8, 2015 at 12:50 pm
Thanks.
I think this is what I am looking for from the Wiki link.
"The range 49152–65535 (215+214 to 216-1)—above the registered ports—contains dynamic or private ports that cannot be registered with...
April 6, 2015 at 9:58 am
Thanks.
I did some googling and found out that I can use:
Netstat -ano
to list all listening ports.
Is there a range of ports that are rarely used? I checked my workstation...
April 3, 2015 at 4:34 pm
I tried to load the log file into "Performance Monitor" but got the error "Data Source xxxxx is either invalid or cannot be found. System message: At least one of...
March 31, 2015 at 4:18 pm
WHERE (CONVERT(SmallDATETIME, RTRIM(h.run_date)) +
(h.run_time * 9 + h.run_time % 10000 * 6...
March 31, 2015 at 3:42 pm
My recommendation is to disable the SQL Server firewall completely and test it.
If still no connection, use
netstat -ano
It will show you which ports SQL Server processes (you have two...
March 28, 2015 at 9:47 am
My second try is
[Code]
With MEMBER [Status].[Status].[All].[Inactive To Active] AS
COUNT
(
NONEMPTY
(
NONEMPTY
(
[Member].[Member ID].[Member ID].MEMBERS,
(
[Status].[Status].&[Active], [Measures].[Member Count]
)
),
(
[Measures].[Member Count],
[Status].[Status].&[InActive],
[Month].[Year Month Hierarchy].CurrentMember.PrevMember
)
)
)
select
{
[Status].[Status].[Inactive To Active]
}
on columns,
{[Month].[Year Month Hierarchy].&[2015].&[2015Q1].&[201503]}
on rows
FROM [SnapshotCube]
[/Code]
The code returns...
March 27, 2015 at 4:15 pm
My first try is to do something like
WITH
MEMBER [Product].[Beer and Wine].[BigSeller] AS
IIf([Product].[Beer and Wine] > 100, "Yes","No")
SELECT
{[Product].[BigSeller]} ON COLUMNS,
...
March 27, 2015 at 4:06 pm
Most likely a firewall issue.
The following link provides step by step diagnosis.
http://blogs.technet.com/b/mdegre/archive/2011/06/04/resolve-sql-server-connectivity-issues.aspx
March 27, 2015 at 3:24 pm
Viewing 15 posts - 16 through 30 (of 52 total)