Viewing 15 posts - 14,896 through 14,910 (of 22,227 total)
dbowlin (6/3/2010)
Ray K (5/18/2010)
Hey Dan, anything to report on this?Haven't heard from you in a while, so I was just wondering!
I am working through the information from Blythe. We...
"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
June 3, 2010 at 2:19 pm
Nils Gustav Stråbø (6/3/2010)
Grant Fritchey (6/3/2010)I personally like Cognos Ignite.
Oops!
Yeah, Confio. Sorry about that. There's been lots of Cognos discussions around here recently and I clearly...
"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
June 3, 2010 at 12:50 pm
Steve Jones - Editor (6/3/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
June 3, 2010 at 11:03 am
I've got no problem piling on in this situation. The principal problem with the inplace upgrade is that if you hose the system, you have to rebuild. That means your...
"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
June 3, 2010 at 10:46 am
I would still recommend using Red Gate SQL Compare. You can call the Pro version from a command line, passing parameters, and hit every single instance through a PowerShell script...
"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
June 3, 2010 at 7:26 am
Do you mean you want to know how to do backups?
Here's an old article I wrote[/url] that can get you started.
"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
June 3, 2010 at 6:51 am
Do a search. There are probably hundreds of them. Here are a list of companies & products:
Microsoft System Center Operations Manager
Cognos Ignite
Red-Gate SQL Alert
Idera Diagnostic Manager
Quest Fogloght
SQL Sentry
There are lots...
"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
June 3, 2010 at 6:50 am
I'm with the previous poster. If you've upgraded the server itself, then no, you can't reconnect to the 2000 instance because it's not a 2000 instance any more. If you've...
"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
June 3, 2010 at 6:47 am
This really gets down to personal preference to a large degree. Here's the question, will that two character abbreviation EVER change? If a country named the United States of Ted...
"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
June 3, 2010 at 6:45 am
I agree. Do the backup locally and then ftp the file or whatever to the remote site. If you run backup across the internet, connection interruption, etc., could cause lots...
"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
June 3, 2010 at 6:37 am
It only backups up the database if it's configured to and it doesn't take into account logs at all. If you want a full point in time recovery system, you...
"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
June 3, 2010 at 6:33 am
From the sounds of things, you should be setting up a server side trace to capture the completed queries along with their performance metrics. That way you can see what...
"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
June 3, 2010 at 6:28 am
CirquedeSQLeil (6/2/2010)
Me: Why are we doing it that way?
other: Because it is being done this way.
Me: Why can't we do it...
"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
June 3, 2010 at 5:31 am
GilaMonster (6/2/2010)
What a waste of good sarcasm...http://www.sqlservercentral.com/Forums/Topic930338-1291-1.aspx
Breaking my Thread-free streak...
At least his current icon is appropriate.
"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
June 2, 2010 at 11:59 am
Sandy2704 (6/1/2010)
Thanks for the information....My statement recompiles around 6 times a day and it doesn't take too much time(around 2-3 sec)....So i guess i am okay with Statement Recompilations
2-3 seconds...
"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
June 2, 2010 at 6:14 am
Viewing 15 posts - 14,896 through 14,910 (of 22,227 total)