Viewing 15 posts - 10,426 through 10,440 (of 22,224 total)
golak_senapati (9/20/2012)
After migrating to SQL Server 2008, how can I get to know that all the tables are migrated successfully with its data (accurate data)?
It's a backup and restore, or...
"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
September 20, 2012 at 1:23 pm
Ooh, just spotted this, for examples, unless you're trying to set a standard as @parm1, etc. (and if so, no, no, no) I wouldn't use those in any examples. Make...
"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
September 20, 2012 at 7:42 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
"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
September 20, 2012 at 6:54 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
"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
September 20, 2012 at 6:45 am
ananda.murugesan (9/20/2012)
Total server memory 8 GB, I have set it max memory 6GB but SQL side using 5.79 GB, so it seems ok in sql side....
"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
September 20, 2012 at 6:42 am
First, Microsoft supplies a tool called the Upgrade Advisor. You can download it. Run that against the existing databases to ensure there are no issues for the upgrade. Fix anything...
"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
September 20, 2012 at 6:39 am
anthony.green (9/20/2012)
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4 - memory management
+1000
"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
September 20, 2012 at 6:36 am
SQL Server will allocate all the memory you tell it can allocate. It will take it all, and keep it. It manages it's own memory internally. So if 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
September 20, 2012 at 6:24 am
Brandie Tarvin (9/20/2012)
Thanks, guys. I'll take a look at those.FYI, there's a "new" IE flaw: http://redmondmag.com/articles/2012/09/18/ie-flaw-being-actively-exploited.aspx
Running only on the POF now, I no longer worry about viruses or exploits because...
"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
September 20, 2012 at 5:57 am
Well, an SP is going to do the code correctly, yes. But the idea behind a constraint is to make sure things are enforced, regardless of where the code 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
September 20, 2012 at 5:53 am
PiMané (9/20/2012)
Is it possible to have a column on table A that references table B or table C depending on another column on table A?
For example:
EntityAddresses (EntityAddressId, EntityType, EntityID, Address)
Customers...
"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
September 20, 2012 at 4:41 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
"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
September 20, 2012 at 4:41 am
Brandie Tarvin (9/20/2012)
HowardW (9/20/2012)
Brandie Tarvin (9/19/2012)
Lynn Pettis (9/19/2012)
Do you ever feel that no matter how many times you tell someone what the problem may be that they just aren't listening?
Yep.
My...
"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
September 20, 2012 at 4:39 am
I have built a document like this before. It was a mixed success. Those who I was able to get to use it, loved it, and it made a huge...
"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
September 20, 2012 at 4:35 am
sqlguy-736318 (9/19/2012)
"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
September 20, 2012 at 4:24 am
Viewing 15 posts - 10,426 through 10,440 (of 22,224 total)