Viewing 15 posts - 10,426 through 10,440 (of 22,219 total)
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
sqlguy-736318 (9/19/2012)
Does Microsoft provide a standards document for SS design standards?For example: "Column names should be Pascal-cased - ex - FirstName"
Have you ever looked at the databases created by Microsoft?...
"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:17 am
I'm not sure how SQL Server is going to deal with all those correlated queries. I'd love to see the execution plan for this. Can you get the actual execution...
"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:15 am
It's not a problem that I've run into or heard about. Are the connections being made from up to date libraries? The appropriate version of ADO or whatever? That might...
"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:11 am
19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not parameterized queries or stored procedures? If so, 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
September 20, 2012 at 3:54 am
Joy Smith San (9/19/2012)
Suppose a transaction was started before the backup process starts, only one transaction for example.
Backup process back up the pages.. transaction...
"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 3:51 am
Viewing 15 posts - 10,426 through 10,440 (of 22,219 total)