Viewing 15 posts - 9,151 through 9,165 (of 22,224 total)
Yeah, same space. At least it should be.
"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
January 3, 2014 at 7:37 am
If you feel like your log files are getting too large, you probably should take the backups more frequently. But, that will mean you have to manage more backup files...
"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
January 3, 2014 at 7:02 am
If your needs are small, I'd go with CDC. It's easy to set up. Easy to maintain. No worries, especially on a small system as you say you have here.
"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
January 3, 2014 at 5:16 am
And also, if you drop and recreate the indexes, that also defrags them.
"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
January 3, 2014 at 5:14 am
You just want to access SQL Server and look at the data, but you don't want to write any T-SQL code? None of the standard management tools can do this...
"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
January 3, 2014 at 5:04 am
It's a connectivity error from distributed replay. You approach it the same way you do any connectivity error. What login is it attempting to use? Does that login have access...
"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
January 3, 2014 at 5:00 am
There are lots of examples right here on the site. Just do a search for xp_cmdshell and zip.
Here's one example here. And another. And one more[/url]. There are still others...
"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
January 3, 2014 at 4:57 am
I'm with Jeffrey. You could use detach to unlink the databases from your server, then load them to the FTP server, then the other party can download and attach 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
January 2, 2014 at 4:13 pm
I'm assuming we're talking Performance Monitor. The best way to collect the data is not to use the GUI that lets you look through the data. Instead, in the GUI,...
"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
January 2, 2014 at 9:35 am
In general, CDC is a good way to track data changes over time. It does add overhead to the system, but it has fairly reliable performance. Whereas, you have to...
"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
January 2, 2014 at 7:37 am
GilaMonster (1/2/2014)
Grant Fritchey (1/2/2014)
Badly written apps provide nothing, or, as in this case, something misleading. But it can be anything.
Implying that Management Studio is badly written (but we already knew...
"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
January 2, 2014 at 6:28 am
david.alcock (1/2/2014)
Grant Fritchey (1/2/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
January 2, 2014 at 5:56 am
Perry Whittle (1/2/2014)
Grant Fritchey (1/2/2014)
If you want faster performance for the system databases, you might consider local storage.
Unless its an FCI then you are required to use shared storage 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
January 2, 2014 at 5:53 am
The only way to determine "normal" for any system is to measure it over time.
"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
January 2, 2014 at 5:29 am
The application name is a connection string bit of information that you can put anything in. You could say "Bob" for the application and SQL Server wouldn't know what you're...
"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
January 2, 2014 at 5:27 am
Viewing 15 posts - 9,151 through 9,165 (of 22,224 total)