Viewing 15 posts - 6,646 through 6,660 (of 22,226 total)
ANn -425914 (2/27/2015)
for indexes, does the order of column matters?
For example I want to create an index of ID, SchoolID, on terms table.
Does the order 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
February 28, 2015 at 12:05 pm
Jeff Moden (2/27/2015)
Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on home,
To one hundred bottles...
"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 28, 2015 at 12:00 pm
Jeff Moden (2/27/2015)
Grant Fritchey (2/27/2015)
Instead, I'd go with a more standard approach:Heh... why? Portability? 😛
Yes Joe.
"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 28, 2015 at 11:59 am
The whole idea around "best practices" is not that they fit in ALL circumstances, but that they fit in MOST circumstances (and most is substantially higher than 50.00001%). Of course...
"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 28, 2015 at 11:59 am
sql-lover (2/27/2015)
djj (2/27/2015)
Grant Fritchey (2/27/2015)
"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 28, 2015 at 11:53 am
It could be any number of things. The best bet would be to capture wait statistics before and after to understand where the slow down is occurring. That will help...
"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 27, 2015 at 1:01 pm
I'm not a fan of GUIDs, but they are not inherently evil. Before you replace it, I'd find out why you have it. If there's no good reason, then by...
"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 27, 2015 at 1:00 pm
Personally, the single most important thing here is getting rid of the multi-statement table valued function. Those things are nothing but trouble.
After that, I think everyone else has offered lots...
"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 27, 2015 at 12:57 pm
Assuming the Threadizens are aware of this since you're a giant bunch of nerds, but...
Spock is dead.
Leonard Nimoy passed away today.
"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 27, 2015 at 10:38 am
Lynn Pettis (2/26/2015)
... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...
Should have said something when I...
"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 27, 2015 at 10:37 am
Yeah, a derived table or a Common Table Expression would allow you to do that. Sorry I didn't understand what you were asking.
"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 27, 2015 at 8:09 am
There is no way.
Go to your last known good backup.
"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 27, 2015 at 6:34 am
You could try doing some of the work in 2014 using In-memory. It still logs things, but not in the same way, at all, especially if you use eventual consistency.
"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 27, 2015 at 6:33 am
Replacing just some of the spaces and not other spaces with no precise set of rules means the Mark I eyeball is going to have to be used to do...
"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 27, 2015 at 6:31 am
What situation are you seeing this in? I'm unclear as to whether we're inside SQL Server or in an application?
"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 27, 2015 at 6:29 am
Viewing 15 posts - 6,646 through 6,660 (of 22,226 total)