Viewing 15 posts - 12,061 through 12,075 (of 22,224 total)
Wow, I didn't even know DBGhost was still around.
Getting your database into source control is actually pretty easy. The hard part is establishing a disciplined development and deployment process around...
"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
August 17, 2011 at 5:50 am
If you don't create tables with FILESTREAM, why set it up on the database 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
August 17, 2011 at 5:37 am
Just remember that while an identity value does uniquely identify a row, it doesn't uniquely identify it for the business. So, just as an example, you need to store first...
"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
August 17, 2011 at 5:37 am
In general, throw disks at the problem. Assuming a reasonably well tuned set of queries, good cpu and enough memory, the most likely issue with that much data is I/O,...
"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
August 17, 2011 at 5:29 am
Statistics are stored with the database. They will be the same on the restored database as they were on the backed up database. This is true even between versions, except,...
"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
August 17, 2011 at 5:27 am
What level are you looking for? Low level, this is how indexes are stored kind of stuff, or high level, this is what SSRS is for which is different than...
"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
August 17, 2011 at 5:24 am
BrainDonor (8/16/2011)
Grant Fritchey (8/12/2011)
"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
August 16, 2011 at 5:26 am
Have you had a radical increase in the size of the database? If it's exactly the same size (or near enough to it), then I'd guess some form of contention....
"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
August 15, 2011 at 12:18 pm
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Anyone you need to check with to say nice things about Red Gate? Nope!
However, pass the word on how the presentation went, how many people attended, if...
"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
August 15, 2011 at 11:35 am
Kiara (8/15/2011)
"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
August 15, 2011 at 10:21 am
Steve Jones - SSC Editor (8/15/2011)
Grant Fritchey (8/15/2011)
"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
August 15, 2011 at 10:18 am
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Kiara (8/15/2011)
GilaMonster (8/14/2011)
Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too
*sigh*...
"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
August 15, 2011 at 6:19 am
GilaMonster (8/15/2011)
Grant Fritchey (8/15/2011)
He's young and male. Therefore, he's a moron.
My take too, and why I mostly ignored that comment. Plus for the last year I've been working with...
"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
August 15, 2011 at 6:18 am
There's no easy way to move a sub-set of the data. You have to take into account that there are so many relationships to maintain between all the tables, 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
August 15, 2011 at 6:10 am
Kiara (8/15/2011)
GilaMonster (8/14/2011)
Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too
*sigh* I wish I...
"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
August 15, 2011 at 6:03 am
Viewing 15 posts - 12,061 through 12,075 (of 22,224 total)