Viewing 15 posts - 6,661 through 6,675 (of 22,219 total)
Have a full deployment testing process that builds your test scripts and test databases from a source control system. That way you can ensure that what you're deploying works and...
"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:02 am
ANn -425914 (2/26/2015)
For SQL performance tuning for a query, does the order of columns in where filter clause matters?
In most cases, no. But, that's because the optimizer will arrange and...
"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:00 am
Nuts. Just spent 20 minutes looking through the books. Wonder if I hallucinated this book.
"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 26, 2015 at 1:07 pm
SQLBill (2/26/2015)
Sioban Krzywicki (2/26/2015)
Grant Fritchey (2/26/2015)
Brandie Tarvin (2/26/2015)
Jeff Moden (2/25/2015)
Brandie Tarvin (2/25/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 26, 2015 at 12:29 pm
Clearly clarity and computer science don't always go hand in hand.
I'm pretty sure using the query should get you ballpark close. It won't be perfect. I'm pretty sure the value...
"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 26, 2015 at 11:27 am
Wait, so that means it wasn't a column, but part of a result set?
"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 26, 2015 at 11:23 am
It's actually 1024, not 1000. That equates to 359kb. Probably what's not included is header information and meta-data about the backup itself. That would explain the extra 19kb.
"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 26, 2015 at 7:56 am
spaghettidba (2/26/2015)
Lowell (2/26/2015)
arrjay (2/26/2015)
The results don't include objects which have not been written/read to/from i.e. nulls. Is there a way of returning these stats? ...
"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 26, 2015 at 7:51 am
It's not a perfect solution because if you have heaps it won't work, but you can look to the sys.dm_index_usage_stats for everything else.
"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 26, 2015 at 6:12 am
Brandie Tarvin (2/26/2015)
Jeff Moden (2/25/2015)
Brandie Tarvin (2/25/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 26, 2015 at 4:44 am
Thanks for posting the answer to your question. That'll be helpful when someone else with the same one finds this using a search.
"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 26, 2015 at 4:27 am
And go and have the discussion with the business people about the recovery point objectives and recovery time objectives for this database.
"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 26, 2015 at 4:26 am
If the text isn't visible from sys.dm_exec_sql_text, then it's gone. But, you can prove it's an open transaction by looking at sys.dm_tran_active_transactions.
"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 26, 2015 at 4:25 am
The column is storing the entire name? Up front, that's a bad design.
You could use the LEFT function in combination with the CHARINDEX function to find the location of 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
February 26, 2015 at 4:22 am
Yeah, it just grows. There isn't a default size. Best to follow an approach similar to what Shafat suggests above.
"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 26, 2015 at 4:18 am
Viewing 15 posts - 6,661 through 6,675 (of 22,219 total)