Forum Replies Created
Viewing 15 posts - 6,376 through 6,390 (of 22,219 total)
-
RE: Are the posted questions getting worse?
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting...
"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?
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:
"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: "normal" non-clustered index vs INCLUDE index
Lynn Pettis (4/10/2015)
Grant Fritchey (4/10/2015)
Lynn Pettis (4/10/2015)
RonKyle (4/10/2015)
but by avoiding key lookups, or worse table/index scans
assuming the table is not a heap (which it shouldn't be, right?), why would it...
"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: "normal" non-clustered index vs INCLUDE index
Lynn Pettis (4/10/2015)
RonKyle (4/10/2015)
but by avoiding key lookups, or worse table/index scans
assuming the table is not a heap (which it shouldn't be, right?), why would it (at least as 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: "normal" non-clustered index vs INCLUDE index
RonKyle (4/10/2015)
If I can add two include columns to an index and get a query that runs 10 times a second down from 400ms to 10ms, you bet I'm going...
"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: "normal" non-clustered index vs INCLUDE index
RonKyle (4/10/2015)
Interesting. I haven't personally made much use of include indexes since they do make the indexes bigger and I'm not convinced the performance gains are significant. I..."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: Connection string that works for SQL Server 2012
Pretty sure this is not needed for a normal connection:AttachDbFilename=C:\path\App_Data\db.mdf
"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 to find Primary key table name and field name of a foreign key
You want to use the information_schema views to look for that type of information. Here's an article[/url] telling all about how they work.
"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: Temp DB question
Don't use up all the space on any of your drives. Always have a one or two mb file called "deletemeinemergencies.txt" that you can use to gain a little space...
"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: Presentation Advice
Oh, and don't try to move them out the room. You only have 15 minutes. You can't move kids anywhere in less than 10 minutes.
"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: Presentation Advice
Here's an idea. Something similar to this could work. We did a "deployment" by blowing up balloons, not tieing them off and then asking the audience to get it...
"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: Enter today's date etc
Sean Lange (4/9/2015)
sqlfriends (4/9/2015)
Yes, I rarely do that too, but if it is a very simple change, I do that to save time.Just curious if SQL server have ability to...
"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: Presentation Advice
That's tough, but for a 10 minute presentation, focus on communicate a single idea. Don't try to cover too much. You want to show the magic of development, find 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: How to find the needle in the haystack
It does sound more and more like a bad plan.
"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: Enter today's date etc
sqlfriends (4/9/2015)
Yes, I rarely do that too, but if it is a very simple change, I do that to save time.Just curious if SQL server have ability to do that...
"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 - 6,376 through 6,390 (of 22,219 total)