Viewing 15 posts - 8,176 through 8,190 (of 22,232 total)
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
The ANSI connection settings can be changed by the connecting application. That's where I'd focus.
"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:01 am
And if that index is needed by the queries, while it's gone you'll see table scans instead of index access, so that impact could be substantial.
"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:00 am
Viewing 15 posts - 8,176 through 8,190 (of 22,232 total)