Viewing 15 posts - 14,416 through 14,430 (of 22,219 total)
WayneS (8/30/2010)
For those that go to both this and the SQLPass summit (Steve, anyone else...) - which one has the better ROI? What are the differences?
My take on the two...
"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
August 30, 2010 at 7:07 pm
jcrawf02 (8/30/2010)
Grant Fritchey (8/30/2010)
"It was interesting"
"I liked it"
"Interesting"
"You just made me sit through 45 minutes of a slow zoom...
"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
August 30, 2010 at 12:29 pm
Steve Jones - Editor (8/30/2010)
Art sucks( I saw as I swig from a can of Pabst and watch XXX)
Now I'm really confused. I thought XXX was art?
"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
August 30, 2010 at 12:25 pm
You guys are starting to sound like my film school criticism class...
"It was interesting"
"I liked it"
"Interesting"
"You just made me sit through 45 minutes of a slow zoom across the room...
"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
August 30, 2010 at 12:12 pm
Scans don't automatically present performance issues, but I'm usually worried about them and more often than not, eliminating a scan improves performance. So, yes, I'd be concerned.
The next step is...
"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
August 30, 2010 at 11:22 am
Management Studio doesn't usually mess with layout unless something else is running. Do you have Red Gate SQL Prompt or one of the other layout tools?
"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
August 30, 2010 at 11:18 am
Ninja's_RGR'us (8/30/2010)
Grant Fritchey (8/30/2010)
Lots of columns, one table... eh.Try messing with an 86 table join. That's when life gets interesting.
especially if the columns are not qualified and that you don'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
August 30, 2010 at 8:47 am
Sounds like you're talking about the DAC Pack.
Steaming pile if you ask me, but here's some info on it[/url].
"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
August 30, 2010 at 8:40 am
110ms isn't that long, so my initial take, look at sys.dm_exec_requests to see what it's waiting on, probably won't work, but you could try. If it's XML, that run time...
"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
August 30, 2010 at 8:37 am
From a structural stand point, they're the same. But, using the system generated keys becomes problematic when you need to support multiple environments for the same database. Let's say 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
August 30, 2010 at 8:14 am
Lots of columns, one table... eh.
Try messing with an 86 table join. That's when life gets interesting.
"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
August 30, 2010 at 8:09 am
Is your database set to Full Recovery mode? If so, you need to be backing up the log files too.
When you back up a database, it backups up the data...
"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
August 30, 2010 at 7:57 am
I'd also suggest reading Books Online. It really is some of the most complete documentation available. But, some additional places to look include, this article that I wrote quite 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
August 30, 2010 at 7:54 am
It may or may not be indexes, who knows based on the information at hand. What I'd suggest is taking a look at sys.dm_exec_requests and see if there are processes...
"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
August 30, 2010 at 7:47 am
RBarryYoung (8/28/2010)
"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
August 28, 2010 at 9:37 am
Viewing 15 posts - 14,416 through 14,430 (of 22,219 total)