Viewing 15 posts - 14,896 through 14,910 (of 22,219 total)
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
Sure, Sharepoint writes it up to a varbinary data type and you can do the same. You just have to take into account that you need to stream that data...
"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 1, 2010 at 11:49 am
So after you run a log backup, there is no extra free space within the log, at all?
"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 1, 2010 at 9:13 am
If your transaction log continues to grow after a log backup, it sounds like your transactions are in an uncommitted state. You should see committed transactions cleared from the log...
"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 1, 2010 at 7:43 am
Not to argue, but since R2 is a basically just a really big service pack, I'd suggest just leaving things alone. I think R2 can fit right into the basic...
"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 1, 2010 at 7:35 am
I'm running a system that has millions of rows from about eight years of data. It's based on inserts only. It runs fine. The issue is not the amount of...
"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 1, 2010 at 6:44 am
Not really. I've been posting about it on my blog for the last two years. Our project is... well, we'll see how it turns out. At the moment, I don't...
"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 1, 2010 at 6:22 am
PaulB-TheOneAndOnly (5/28/2010)
david.ostrander (5/27/2010)
I have been reading so much on data warehousing that I feel like I should know this but here I go. How does it get installed?
"Data Warehouse" is...
"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
May 30, 2010 at 5:44 am
I would argue that while all three compile and run, none of them is "correct." If they were correct, then so would this be, and you know it's not:
SELECTmycolumnFROM MyTable;
SELECTmycolumn...
"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
May 28, 2010 at 11:51 am
Viewing 15 posts - 14,896 through 14,910 (of 22,219 total)