Viewing 15 posts - 14,626 through 14,640 (of 22,219 total)
Half way there.
Changed:
$job = Invoke-Command -ComputerName (Get-Content "c:\scripts\serverlist.txt") -ScriptBlock {Invoke-Sqlcmd -ServerInstance $instances.$env:computername -Query "exec sp_who2"} -JobName tsql -ConfigurationName MyShell
To:
$job = Invoke-Command -ComputerName (Get-Content "c:\scripts\serverlist.txt") -ScriptBlock {param($instances) Invoke-Sqlcmd -ServerInstance $instances.$env:computername...
"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
July 16, 2010 at 9:58 am
I freely admit to feeling extreme depression at times because I'm just not as smart as many of the people I know and I've met. It can be daunting just...
"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
July 16, 2010 at 5:29 am
True. Auditing is the complete package, sorry for being unclear. I still shy away from triggers though.
"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
July 16, 2010 at 5:23 am
SwedishOrr (7/15/2010)
"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
July 16, 2010 at 5:22 am
Tom.Thomson (7/16/2010)
Grant Fritchey (7/15/2010)
"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
July 16, 2010 at 5:15 am
Nat Na (7/15/2010)
thank you for answer me. I read the article you told me, but it only works for NHibernate and Im using Hibarnate (the property of hibernate.cfg.xml...
"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
July 15, 2010 at 12:40 pm
I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.
"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
July 15, 2010 at 12:37 pm
Jack Corbett (7/15/2010)
"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
July 15, 2010 at 12:12 pm
CirquedeSQLeil (7/15/2010)
With another one coming up very quickly 😉
Where? When? I don't know what you're talking about.... again
"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
July 15, 2010 at 12:10 pm
Alvin Ramard (7/15/2010)
Steve Jones - Editor (7/15/2010)
Grant Fritchey (7/15/2010)
Alvin Ramard (7/15/2010)
We're considering using LiveMeeting in Memphis so that more people could "attend" the meeting.
We've talked about it a few times,...
"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
July 15, 2010 at 9:33 am
Alvin Ramard (7/15/2010)
We're considering using LiveMeeting in Memphis so that more people could "attend" the meeting.
We've talked about it a few times, but there hasn't been a lot of interest...
"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
July 15, 2010 at 8:22 am
Does it hurt anything? Not really.
But what a total waste of space and time. Maintenance and long term readability is reduced, not enhanced. It's a throwback to the old days...
"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
July 15, 2010 at 6:50 am
Paul Farnell (7/15/2010)
"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
July 15, 2010 at 6:46 am
Please don't post in duplicate locations. It just diffuses the conversation.
All replies to this thread please.
"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
July 15, 2010 at 6:36 am
GilaMonster (7/14/2010)
Nat Na (7/14/2010)
About Parameter sniffing, I only saw it happens in procs. Is it possible for querys from appl?
Can happen any time there's parameterised queries.
And how can...
"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
July 15, 2010 at 6:16 am
Viewing 15 posts - 14,626 through 14,640 (of 22,219 total)