Viewing 15 posts - 8,161 through 8,175 (of 22,219 total)
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
OK. Sounds fine. But, you still don't know why the log was that big. Maybe there are load processes or something that require that level of log space. You may...
"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 7:09 am
ashok84.kr (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 7:06 am
You can just run the shrink operation on the file.
But, the bigger question is, what caused the log to get so big? Was it a one-time event that's not...
"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 6:24 am
Excellent point on the storage of the cluster key in nonclustered indexes Ed. I completely missed that one.
"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 6:08 am
Again, because I can't see the behavior of your queries, I don't know.
A view doesn't do anything but store the query. It won't help performance at all unless you're talking...
"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 6:03 am
Viewing 15 posts - 8,161 through 8,175 (of 22,219 total)