Viewing 15 posts - 17,011 through 17,025 (of 22,219 total)
I love it. Integrating our builds with the development builds makes everything so much easier. The power that comes from knowing exactly what has changed, when, by whom, makes all...
"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
July 15, 2009 at 11:12 am
In 2000, it's a pain and you can't really do it unless you post a text plan. In 2005/2008, it's easy. Just right click on the execution plan, assuming it's...
"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
July 15, 2009 at 7:50 am
frecal (7/15/2009)
I am using sql 2008...is this easy to do..are there any examples i can work with?thanks
Fred
It's very easy to do. Look it up in the Books Online for examples....
"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
July 15, 2009 at 7:31 am
mchid (7/15/2009)
My investigations are now with the code itself where I have found some issues (LINQ...
"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
July 15, 2009 at 7:31 am
Randy (7/15/2009)
"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
July 15, 2009 at 7:29 am
Without a lot more details, it's hard to know for sure, but on a guess, you've got the GUID clustered. That's going to lead to huge amounts of page splits...
"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
July 15, 2009 at 7:03 am
There must be a function or something that's radically changing the execution plan. You'll need to post both execution plans and please make them actual execution plans, not estimated.
"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
July 15, 2009 at 6:59 am
Instead of intentionally violating the key (not something I'd encourage), why not just change the query slightly so that it selects the TOP 1 value and inserts that? You wouldn't...
"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
July 15, 2009 at 6:56 am
A backup of a database is just a file, so you can move it any way you want. Copy & paste, as mentioned before will work. XCopy will work. 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
July 15, 2009 at 6:53 am
You need to ensure that all connections are clear with the database you're attempting to restore, even your own. Once all the connections are clear, you can restore.
If it's an...
"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
July 15, 2009 at 6:51 am
There is no way to update multiple tables from a single TSQL statement. If you want to update multiple tables, you will need multiple statements. I'm not sure that you'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
July 15, 2009 at 6:44 am
Assuming that you're working with SQL Server 2008 since you posted to this forum, you could also look at using the Hiearchy data type. That's for establishing Parent/Child type of...
"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
July 15, 2009 at 6:41 am
Jan Van der Eecken (7/14/2009)
GilaMonster (7/14/2009)
Jan Van der Eecken (7/14/2009)
Are you saying I'm out of the office at an inapproriate time?
It's 10pm. What self-respecting IT person is not still working...
"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
July 15, 2009 at 5:36 am
I agree. That's a pretty poor choice for design. Not to mention the horrible chattiness of the app on your network, it's going to cause some major league contention within...
"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
July 14, 2009 at 1:23 pm
RBarryYoung (7/14/2009)
Grant Fritchey (7/14/2009)
"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
July 14, 2009 at 1:18 pm
Viewing 15 posts - 17,011 through 17,025 (of 22,219 total)