Viewing 15 posts - 21,586 through 21,600 (of 22,224 total)
Marcus Farrugia (10/30/2007)
What is the difference between if and iif?Thank you in advance for your help.
IIF is an MDX expression used to build cubes. It corresponds to the immediate if...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 1:02 pm
This works:
create table #t
(Col1 nvarchar(50))
GO
create table #s
(Col1 nvarchar(24)
,Col2 nvarchar(24)
)
GO
insert into #t (col1) values ('a')
insert into #t (col1) values ('b')
insert into #t (col1) values ('c')
insert into #t (col1) values ('d')
insert into...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 12:59 pm
No. Analysis Services is for cubes. Totally different application. You just need to do the stuff in the post above to identify the appropriate SPID and then use the command:
KILL...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 12:02 pm
Adding the other column will only help if it turns the index into a covering index. If you're doing SELECT *... I probably won't do anything.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 10:04 am
Shy details, it sounds like you're talking about temporary tables.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 9:03 am
Nah, neither method is "wrong". If you're opening the XML from a file, definiately do what Andras suggested. If you're receiving the XML from an application through a parameter, I'd...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:53 am
I think they want the loan guarantees because, quite frankly, the next administration (regardless of individual or party, not picking a fight with anyone), can reverse the directions & decisions...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:50 am
I'm not entirely sure on this, but I believe that the statistics maintained don't include NULL values.
If I recall correctly, statistics are based on 200 rows from within the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:42 am
Use the suggestion above, or if you're passing the XML in as a parameter use the OPENXML syntax
DECLARE @Handle int
EXEC sp_xml_preparedocument @Handle OUTPUT, @XmlParameter
INSERT INTO TABLE x
SELECT ...
FROM OPENXML (@DocHandle,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:23 am
Lowell (10/29/2007)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:16 am
happyme_01_cool (10/30/2007)
SELECT dbo.course.cname, dbo.enroll.classno
FROM dbo.course INNER JOIN
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:12 am
Nice job Gail.
Talk to you later Sandy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:09 am
That's a really interesting wind power generator. The cost does look interesting. We're already off the grid for heating the house (outdoor wood burning furnace), water and waste disposal, so...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 6:07 am
Michael Fried (10/29/2007)
* Concurrency Problems - there will...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2007 at 5:58 am
Save it to disk with the extension .sqlplan. You can then reopen it as a graphical execution plan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2007 at 12:31 pm
Viewing 15 posts - 21,586 through 21,600 (of 22,224 total)