Viewing 15 posts - 8,161 through 8,175 (of 22,224 total)
Ed Wagner (5/14/2014)
Koen Verbeeck (5/14/2014)
GilaMonster (5/14/2014)
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)Sorry, am a little short on patience today.
I pretty much laughed with the "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
May 14, 2014 at 6:04 am
Since you now know that you need to replace the one character, you could try using the REPLACE T-SQL statement on the string (not on the column) to replace 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
May 14, 2014 at 6:03 am
yuvipoy (5/14/2014)
for the test of 1000 record on a table with...
"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
May 14, 2014 at 5:49 am
Well done. That's great to hear.
"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
May 13, 2014 at 5:21 pm
Sorry, it took me a little while to write that up and in the mean time others have posted roughly the same stuff. I kept getting distracted. Doggone twitter.
"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
May 13, 2014 at 4:38 pm
You could UNION the two together, but you'll have to have the text in two columns. So, how about we put the UNION query into a derived table. Something 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
May 13, 2014 at 4:35 pm
Yeah, you have to set max memory. SQL Server will attempt to use all the memory available to it, so the only way for sure to limit that is to...
"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
May 13, 2014 at 3:52 pm
Also, be cautious using views in SQL Server. They're a fine way to obfuscate queries and implement security and other functionality. But, people start treating them like tables and joining...
"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
May 13, 2014 at 10:59 am
I'm going.
One session on Friday and one on Saturday. I'll be there Thursday afternoon until Sunday morning.
Last Bits was probably the single best event I've ever been to. I'm really...
"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
May 13, 2014 at 10:56 am
If you have the file compressed, additional compression is usually not possible. You can either just move the file as is, or try splitting it up and moving the smaller...
"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
May 13, 2014 at 10:54 am
And, depending on what features you have in use in your 2008 database, you won't even be able to migrate your databases over.
"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
May 13, 2014 at 10:53 am
ChrisM@home (5/13/2014)
Lynn Pettis (5/13/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
May 13, 2014 at 10:30 am
And based on that, I still don't see any way to speed this up. Oh, and I know you obfuscated the query, but we can see the objects and 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
May 13, 2014 at 10:24 am
lkennedy or LK (5/13/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
May 13, 2014 at 8:07 am
Megha P (5/13/2014)
but just try by taking filtered records of
first query [select from table1 where PartitionID...
"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
May 13, 2014 at 8:07 am
Viewing 15 posts - 8,161 through 8,175 (of 22,224 total)