Viewing 15 posts - 9,001 through 9,015 (of 22,232 total)
Greg Edwards-268690 (1/29/2014)
GilaMonster (1/29/2014)
Ed Wagner (1/29/2014)
GilaMonster (1/29/2014)
Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously unpleasant.
That sounds seriously...
"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
February 3, 2014 at 4:40 am
rodjkidd (1/29/2014)
Talking of Grant, did anyone see the picture of him on the SQLCruise yesterday- almost as red as the livery of that company he works for!Rodders...
Unless it was while...
"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
February 3, 2014 at 4:37 am
Jeff Moden (1/25/2014)
"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
February 3, 2014 at 3:48 am
Lynn Pettis (1/24/2014)
Has anyone else ever heard that it is a best practice to have enough server memory to hold your entire database in memory?
Yeah, it's called SQL Server 2014.
But...
"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
January 24, 2014 at 1:53 pm
Greg Edwards-268690 (1/24/2014)
Koen Verbeeck (1/24/2014)
Anyone with a better grasp of SQL Server security and auditing can take this one?http://www.sqlservercentral.com/Forums/Topic1534372-2799-1.aspx?Update=1
Trust Me, but audit all the other Admins!
Something missing in that picture.
Sounds...
"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
January 24, 2014 at 6:24 am
Like I said. Opinions differ.
"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
January 24, 2014 at 6:21 am
Another consideration is the width of the key. The wider it is, the fewer key values are stored per page, which means possibly deeper B-Trees on the index and more...
"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
January 24, 2014 at 6:15 am
I suggest you always set the max memory. You're right. Your server doesn't seem to be under stress and the chances are, it won't be. But, SQL Server will attempt...
"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
January 24, 2014 at 6:10 am
ChrisM@Work (1/24/2014)
I tend not to. If I'm about to spend a few minutes reading and understanding a chunk of code, reformatting it easily becomes part of...
"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
January 24, 2014 at 6:05 am
ChrisM@Work (1/24/2014)
Grant Fritchey (1/24/2014)
Nice job Chris. I'd love to see what the execution plan of the original query looked like.
Thanks Grant. Me too, there are over 70 reads of the...
"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
January 24, 2014 at 6:01 am
Nice job Chris. I'd love to see what the execution plan of the original query looked like.
"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
January 24, 2014 at 3:13 am
Getting UNION ALL to work is just a question of, sort of, writing the same query twice:
SELECT a.Column1,
b.Column2
FROM TableA...
"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
January 24, 2014 at 3:09 am
Code validation takes place before any of the other optimizer steps, so it has to read correctly as the others have stated. And the order can matter if you have...
"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
January 24, 2014 at 3:06 am
Take a look at T-SQLT[/url]. That's a unit test framework for T-SQL. You can also check out SQL Test[/url]. That's a framework that Red Gate wrote around 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
January 23, 2014 at 2:09 pm
Oh, if they're mapped to a single user, yeah, you're kind of stuck. There's no easy way there. You'd have to modify your structure so that instead of mapping them...
"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
January 23, 2014 at 8:08 am
Viewing 15 posts - 9,001 through 9,015 (of 22,232 total)