Viewing 15 posts - 14,911 through 14,925 (of 22,232 total)
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
Greg Edwards-268690 (5/28/2010)
Adventure Works has a transactional data base and a data warehouse model.
Exploring this, and possibly some sample labs, might be helpful.
On...
"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 10:15 am
If you've done a regular install of Operations Manager, Reporting Services was installed as a component. It has to be there.
As far as getting at the datawarehouse, again, you have...
"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 8:31 am
Viewing 15 posts - 14,911 through 14,925 (of 22,232 total)