Viewing 15 posts - 6,316 through 6,330 (of 22,219 total)
Steve Jones - SSC Editor (4/14/2015)
Ed Wagner (4/14/2015)
Grant Fritchey (4/14/2015)
And this makes 14,001 posts. My fingers are tired.
Well done, Grant. I'd say you've earned a victory beer, so enjoy...
"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
April 14, 2015 at 10:51 am
And this makes 14,001 posts. My fingers are tired.
"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
April 14, 2015 at 8:43 am
It's not in the system_health extended events session. I know that.
"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
April 14, 2015 at 8:41 am
xsevensinzx (4/14/2015)
Grant Fritchey (4/14/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
April 14, 2015 at 8:29 am
t.pinder (4/14/2015)
Grant Fritchey (4/14/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
April 14, 2015 at 6:52 am
Yeah, it's all largely still applicable. Having more than one disk helps I/O. Further, having more than one file/filegroup helps too. You do have to take into account the number...
"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
April 14, 2015 at 6:07 am
Ville-Pekka Vahteala (4/14/2015)
Grant Fritchey (4/14/2015)
OK. Fair enough. Let's try this one. It might also be found somewhere in here... maybe.
These did not have those numbers what I asked, but they...
"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
April 14, 2015 at 6:02 am
GilaMonster (4/14/2015)
Grant Fritchey (4/14/2015)
You could try searching sys.dm_exec_query_stats in combination with sys.dm_exec_sql_text to find DELETE/TRUNCATE statements.Truncate doesn't get cached iirc, because it's a DDL statement
Ah, true. Hadn't thought that...
"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
April 14, 2015 at 6:01 am
All this "never use public WIFI" and "never work in public" might be viable when you have a job that requires you to show up in an office from 9-5....
"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
April 14, 2015 at 6:00 am
MotivateMan1394 (4/14/2015)
HiCan I use this command to check my databases every night. (in a job)
(Before I get caught)
And I should read the report every morning ?
Piling on with Gail.
Yes....
"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
April 14, 2015 at 5:53 am
With modern SAN "drives" actually consisting of some number of shared drives, the whole idea of splitting your storage between data and logs gets kind of weird. For most systems,...
"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
April 14, 2015 at 5:49 am
It might be part of the white paper that's available here[/url]. I'm just not sure.
"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
April 14, 2015 at 4:36 am
OK. Fair enough. Let's try this one. It might also be found somewhere in here... maybe.
"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
April 14, 2015 at 4:35 am
You could try searching sys.dm_exec_query_stats in combination with sys.dm_exec_sql_text to find DELETE/TRUNCATE statements. It will tell you when the last execution time was, if the query is still in cache....
"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
April 14, 2015 at 4:31 am
You can force the literal string to be NVARCHAR by using the N'Somestring' syntax. Try that with the same code.
"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
April 14, 2015 at 4:29 am
Viewing 15 posts - 6,316 through 6,330 (of 22,219 total)