Forum Replies Created
Viewing 15 posts - 5,266 through 5,280 (of 22,227 total)
-
RE: Query performance question - temporary tables vs. local variables vs. table variables
Roughly the same execution plans really translates as, different execution plans. As Gail says, look to the row estimates to understand where the differences are coming 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: Table-Valued inputs for stored procedures
It really depends on what you're doing with that data. If you're doing any kind of filtering or joining against it, then the table variable structure that the table valued...
"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: Where to start...
In addition to what's already mentioned, I'll add Itzik Ben Gan's book, Inside T-SQL Querying.
Additionally, because taking multiple approaches to learning is always best, I'd suggest tracking down your local...
"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?
Brandie Tarvin (1/4/2016)
Eirikur Eiriksson (1/4/2016)
Koen Verbeeck (1/4/2016)
A bit late, but best wishes for everyone!BLTN:-D
😎
BLT... Nom. Now I'm hungry.
Oh, wait. Wrong thread. Thought we were doing Random Words here for a...
"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: Surface Book
Andy Warren (1/4/2016)
Grant, I've been using Parallels on my MacAir since I bought it. Works well, though battery life suffers. Its an i7/8G. Not industrial strength, but reasonable. I can'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: Surface Book
Walter Levy (1/4/2016)
Kind of sad to hear that Toshiba isn't the sterling laptop vendor they once were.Steve & I bought the same model about a month apart. Mine is older...
"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: Surface Book
My problem with the Mac is that I truly hate the OS. I guess if I were shopping (and I'm not, and hope not to be for at least one...
"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: SQL Server Installation Help
That's extremely abnormal. If it's not a window out of focus as defined above, there must be something wrong on your machine. Check the error logs and try uninstalling unnecessary...
"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: Surface Book
Andy Warren (1/4/2016)
I'm intrigued by the Surface Book, but the sleep bugs (Sleep!) in this first iteration worry me. I'd want to see it stable first and I suspect a..."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: Surface Book
It's so weird that your Toshiba is dead and mine is chugging along (knock wood).
Maybe you're just hard on machines. Ha!
(For those who don't know, I dropped a...
"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: Can i use option(recompile) for Functions?
The biggest issue for multi-statement table valued functions is that, regardless of recompile, since they don't have statistics and are always based off of 100 rows (in 2014 using 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: Normalized Database, view, subquery which is a better practice
As Jack says, in the scenario described, the optimizer is likely to arrive at the same plan regardless of the approach you take. However, what you're proposing to do with...
"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?
"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?
Phil Parkin (12/29/2015)
Grant Fritchey (12/29/2015)
Eirikur Eiriksson (12/29/2015)
I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence..."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?
Eirikur Eiriksson (12/29/2015)
I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review and..."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 - 5,266 through 5,280 (of 22,227 total)