Forum Replies Created
Viewing 15 posts - 9,961 through 9,975 (of 22,219 total)
-
RE: table partitioning
ratheesh4sql (3/13/2013)
planning to do the partitioning for the main table with region wise.....So that we can split the data into a different file group and the data accessible also will..."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?
Stefan Krzywicki (3/15/2013)
Hey Grant,Good panel last night. Should be more of those.
Thanks! That was a lot of fun. And I didn't make Adam angry more than once or twice, so...
"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: Extended Events
Jonathan Kehayias (3/15/2013)
Grant Fritchey (3/13/2013)
SQLKnowItAll (3/13/2013)
When is the book coming out Grant? I am going to be one of the first buyers...Ha! Don't hold your breath. I still haven't...
"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?
SQLRNNR (3/15/2013)
Steve Jones - SSC Editor (3/15/2013)
hahaha
Should we show him how to work the site?
"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: Insert Performance
Sergiy (3/13/2013)
Grant Fritchey (3/13/2013)
But a few years ago, I did do a series of tests, not from ODBC, but through ADO.NET, and we saw serious performance degradation when using single..."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: Very frustrating performance tuning!
shannonjk (3/13/2013)
That is odd that the merge should be faster than the hash, since if I add hash to the join (i.e LEFT HASH JOIN) it executes in half the..."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: Extended Events
SQLKnowItAll (3/13/2013)
When is the book coming out Grant? I am going to be one of the first buyers...Ha! Don't hold your breath. I still haven't received the first chapter.
"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: Extended Events
SQLRNNR (3/13/2013)
It might be typical for your environment. But that doesn't mean it has to be acceptable.That many parallelism deadlocks can mean that you have a lot of poor...
"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: Extended Events
SQLRNNR (3/13/2013)
You are dealing with a Debbie Downer.XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information about spinlocks,...
"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: Insert Performance
Sergiy (3/13/2013)
Year, hard to argue.Except, probably, for this one:
Grant Fritchey (3/13/2013)
But, if you have to do individual inserts (and I'd be curious why), then small sets of transactions, say 10,000..."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: Extended Events
Extended events are the future. Trace events and Profiler are on the deprecation path. Just on that alone, you're doing the right thing. But the fact is, extended events operate...
"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: Recommended index causing query to run twice as long / HASH vs NESTED LOOP
What I meant was store the Month & Day values as those, either during the insert/update process or as calculated columns. Performing functions on columns in any kind of criteria...
"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: Recommended index causing query to run twice as long / HASH vs NESTED LOOP
That's a screen capture of an execution plan. Not the execution plan. There are properties behind all those operators that tell a more complete store than just the graphical pictures.
"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: Slow query - optimisation help required!
The amount of storage is the cause of IO, not the potential storage. If there are 300 bytes not used, they're not used. There's no additional cost for that. 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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Slow query - optimisation help required!
No, you won't get a conversion. You may see truncated data of course, but no conversion.
"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 - 9,961 through 9,975 (of 22,219 total)