Viewing 15 posts - 21,586 through 21,600 (of 22,219 total)
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
2005 has a more granular time field internally. It deals in micro seconds instead of milli seconds. That might explain it. It still stores datetime fields as milliseconds. I had...
"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:24 pm
It's just a series of joins & where clauses. If you've paid any attention in the course, you should be able to do this stuff. If you get stuck on...
"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 9:06 am
GilaMonster (10/29/2007)
Oooh, Grant, you've got a fan... 😀
Oh that's all right. You have one too. 😀
"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 8:25 am
Sandy (10/29/2007)
Can you have a look on to my last post..
I will be happy if you and jeff will have a
sharp eye on my post.
Thanks a lot for...
"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 6:19 am
Honestly, one table... Why put it into a relational data management system? Assuming at least a good primary key, this can be accessed faster from a file than from 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 29, 2007 at 5:43 am
Viewing 15 posts - 21,586 through 21,600 (of 22,219 total)