Viewing 15 posts - 20,551 through 20,565 (of 22,219 total)
He's right. With very, very few exceptions, every table should have a clustered index. Further, every table should have a primary key and that constraint can be clustered (since it...
"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
April 29, 2008 at 9:25 am
Kevin Durham (4/29/2008)
"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
April 29, 2008 at 9:23 am
codevault33 (4/29/2008)
"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
April 29, 2008 at 9:17 am
No, it's an implicit commit. I just got the same results. I ran this query against Adventureworks:
SELECT soh.[SalesOrderID]
,sod.[SalesOrderDetailID]
FROM Sales.[SalesOrderHeader]...
"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
April 29, 2008 at 9:12 am
It is a small world. I was on SSN606, Tinosa (a pile of glowing razor blades now). I was nuclear power machinist mate. In other words I used a slightly...
"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
April 29, 2008 at 8:52 am
It sure beats working on a nuclear powered submarine in terms of pay, benefits, hours, cleanliness... Yeah, I'd say it's still a good career.
"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
April 29, 2008 at 6:47 am
I'd have to see the procedure to understand why you're getting a difference. But I think, and I could be wrong about this, the batch includes the commit, but 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
April 29, 2008 at 6:45 am
To give you a specific answer you need to post specific information, the two tables & some sample data. See here: http://www.sqlservercentral.com/articles/Best+Practices/61537/
In general, you shouldn't have to do cursors or...
"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
April 29, 2008 at 6:05 am
To give you a specific answer, sample structures and data and code are necessary. To give you a general answer, take a look at the execution plans for the queries...
"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
April 29, 2008 at 5:58 am
A statement is a single piece of work, whereas a batch is a whole set of work.
So, for example:
DECLARE @Id INT;
SET @ID = 52;
SELECT *
FROM dbo.MyTable
WHERE Id = @Id;
That...
"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
April 29, 2008 at 5:48 am
I posted the same question at Connect. One of the MS reps gave me a good response.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=244214
"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
April 29, 2008 at 5:44 am
I've been burned way too many times by poor use of functions to be any kind of advocate for them. However, if you really want to drill down on them,...
"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
April 29, 2008 at 5:37 am
The queries work well when the data is loaded, but don't work when the tables are empty? I think the previous post may be right, the execution plans are still...
"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
April 28, 2008 at 6:52 am
Doggone it! I was getting excited that I might be able to tell you something rather than ask you something.
😛
"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
April 28, 2008 at 6:40 am
As to your initial question, it's two schema's in one database, not two databases.
As to your further explanation that you'll be bringing other applications online. As the other applications come...
"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
April 28, 2008 at 5:24 am
Viewing 15 posts - 20,551 through 20,565 (of 22,219 total)