Viewing 15 posts - 6,931 through 6,945 (of 22,229 total)
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
That's awesome. Well done.
"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
January 13, 2015 at 4:49 pm
What Gail said.
I don't know how that started, but I've seen examples of that approach to naming files going back to when I started working with SQL Server 4.2... Sybase...
"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
January 13, 2015 at 8:00 am
You could try looking at third party tools then. Redgate SQL Compare for the structures and SQL Data Compare for the data. You'll have to do manual mapping on the...
"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
January 13, 2015 at 7:04 am
Break apart the transactions so that they're smaller. Only move chunks of the data in order to make the transaction size smaller. There are a number of different documents online...
"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
January 13, 2015 at 6:27 am
Unless we're looking at some of kind of terminology mix up. Maybe you meant RID, or Row Identifier, which is a marker placed on rows in a heap table. Just...
"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
January 13, 2015 at 6:24 am
You could use the ROW_NUMBER function and just add your starting value to output of the query. For example, if you want to start counting at 7, you add 6...
"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
January 13, 2015 at 4:50 am
I would just script out the dependent objects, drop them and recreate them. That's going to be the safest way to ensure you get it right.
I'm pretty sure that's...
"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
January 13, 2015 at 4:26 am
I've seen the output of ROW_NUMBER() referred to as row index (incorrectly), but other than that, I'm with Gail. I don't understand the question.
"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
January 13, 2015 at 4:20 am
You really can't. You're telling the engine to do anything it has to in order to remove the corruption within the structures. That will result in, at minimum, the loss...
"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
January 13, 2015 at 4:15 am
Maybe I misunderstood the question then. You're saying that they already have built an empty database, but this time it's got new structures, different table layout, etc., in addition to...
"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
January 13, 2015 at 4:10 am
A TOP without an ORDER BY means you could see data duplication or missing data. This is because you're not guaranteed to get the results back in any particular order,...
"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
January 12, 2015 at 8:14 pm
If it's a one-time data move, the easiest is going to be to just do a restore. You can drop all the objects on the other side after the restore....
"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
January 12, 2015 at 8:09 pm
Since you can't add a second tempdb, adding a file is the way to go. Here's a good review[/url] on how to pick tempdb file settings. There are a bunch...
"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
January 12, 2015 at 4:11 pm
If the SAN goes, and they do, you lose all your backups. Yes, I would absolutely have a second location. Tape at least.
"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
January 12, 2015 at 4:08 pm
Honestly I don't know where to go in the NAS, but that's gotta have some of the source of info.
"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
January 12, 2015 at 4:05 pm
Viewing 15 posts - 6,931 through 6,945 (of 22,229 total)