Viewing 15 posts - 17,626 through 17,640 (of 22,226 total)
Ah, different world. I think you're right.
"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 23, 2009 at 12:49 pm
I use Team System Database Edition. You don't connect to the .mdf/.ldf files with that tool either. You connect to a database through a connection string, or you have a...
"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 23, 2009 at 11:52 am
You're trying to open the file. You can't.
You need to provide a server and instance name as part of the connection string for Visual Studio. It's the same server name...
"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 23, 2009 at 11:19 am
I'm sorry, I don't have my abstracts in a readily digestible format anywhere. Something else to do next time.
However, if you register as a speaker you can look at 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
April 23, 2009 at 8:28 am
GSquared (4/23/2009)
You just gotta love posts like these:http://www.sqlservercentral.com/Forums/Topic703170-338-1.aspx
http://www.sqlservercentral.com/Forums/Topic703094-147-1.aspx
"Here's a pile of something brown & smelly. Turn it into shiny gold for me... Now!"
"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 23, 2009 at 8:01 am
Ah, well, that's where you'll need to back to the Waits & Queues article that Matt posted to see what's causing the slow down. From the description, it's either CPU...
"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 23, 2009 at 7:44 am
You've got today and tomorrow to put an abstract together. The worst that'll happen is they say no. Go for 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 23, 2009 at 7:42 am
It could be two things causing the slow down, since your views are calling views, the resolution of all those database objects is going to slow things down, as you...
"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 23, 2009 at 6:22 am
Since the code is unusable, I don't see the point of keeping it intact. Comment it out. That will leave it in place if you really must.
"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 23, 2009 at 6:17 am
Yeah, a pretty standard solution for avoiding NULL values.
"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 23, 2009 at 6:16 am
The thing is, the query window in SSMS is for manual entry, not automation. It's unlikely they'll automate it when MS is already providing sqlcmd.exe and PowerShell scripts (another option)....
"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 23, 2009 at 5:52 am
Actually you can register on the last day of the conference if you want to. I don't know why you would, but it's possible.
"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 23, 2009 at 5:17 am
If the data is being pulled from a covering non-clustered index, absolutely. I'm not so sure it would happen during a key lookup.
"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 23, 2009 at 5:14 am
Glad I could be at all useful. I'll post anything I find and I'm running up a blog post about this 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
April 22, 2009 at 9:52 am
...and that's when the fight started...
😀
Yeah, that alone is going to cause you performance issues. SQL Server is going to have a hard time resolving everything and optimizing 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 22, 2009 at 9:23 am
Viewing 15 posts - 17,626 through 17,640 (of 22,226 total)