Forum Replies Created
Viewing 15 posts - 15,646 through 15,660 (of 22,221 total)
-
RE: SQL 2008 - Query analyser crashes when 100 connections reached
I guess it's a silly question, but why would you want to open 100 procedures all at the same time? You can't possibly look at or manipulate them all at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Records missing
I doubt it has anything to do with statistics. You're either hitting an error that is causing the rollback, the transaction is rolling back because the connection was dropped, or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Help with tuning the Query
Looking at it, you're getting almost nothing but clustered index scans. That means it's reading every single row on the table. Things in the queries that are causing this include:
CellGroupName..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: help on the performance based queries
ekknaveen (3/24/2010)
Hi,I need the help to solve the below mentioned questiones.
1. <>. > =. LIKE what is the order as per performance
2. select * from tab1 where lower(name)='name' is fast...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Question on refactoring an inherited (very) wide table
It sounds like a classic design error on normalization. Yes, given the opportunity, I'd suggest redesigning the structure and migrating the data. It won't be that hard and you should...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Clustered Index Modification
The uniquifier (or uniqueifier) is a 4byte integer value. So from that you can estimate the cost to the size of the index. So that not only increases the size...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Anybody knows by chance if this book will be ever released?
virgilrucsandescu (3/24/2010)
Of course it helps! My favorite chapters are those on SQL Query Performance, Indexes, Statistics, Query Design and Blocking.And the last chapter (the checklist) should be on the desk...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Utilize SSC forum/posts
I agree with Gus and I'll add that I still learn more when I answer a question wrong and it gets fixed by one of the SQL-Monsters that run around...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Injecting Your Own Bias
Steve Jones - Editor (3/24/2010)
...many of the more vocal people on the East Coast...Now who the heck are you talking about?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Table Splitting
If you're seeking to break it up in that way, then instead of ID & foreign key, maybe breaking it up by date makes more sense.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Injecting Your Own Bias
I'll try to attend the Summit regardless of where it's held. That said, I'd still like to see it move around a bit. Seattle is a pretty major travel commitment...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (3/23/2010)
Changing the subject (if there is one), any art critics here?Been fiddling with this on and off for a couple years now. Initial idea was just the light from...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Good to have you back Barry!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Clustered Index Modification
Nice high level of paranoia. Good job.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Lynn Pettis (3/22/2010)
GSquared (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.My main subjects of conversation so far today have been politics (Obamacare passed...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 15,646 through 15,660 (of 22,221 total)