Viewing 15 posts - 6,931 through 6,945 (of 22,221 total)
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
Restarting the server because of a NAS problem, even if it's just backups, doesn't give me a warm & fuzzy, at all. Combining the fact of your NAS problems 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
January 12, 2015 at 12:30 pm
That wait type means that SQL Server is waiting on the operating system. It sounds like you may have a problem with your NAS. Is it sharing the network 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
January 12, 2015 at 12:04 pm
And cross-posting doesn't help. We just get fragmented conversations.
Please redirect further posts to here.
"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 11:57 am
You're measuring the length of the expression, not it's internal storage structures. So that's why it shows as 5.
"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 11:56 am
Nope. You can go and install it on a 16 core server. But, when Microsoft comes along with an audit, your company will pay one heck of a lot more...
"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 11:51 am
Nothing you have to do to the installation. You've paid for your license, install the product and go to work.
"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 6:14 am
Benki Chendu (1/12/2015)
Grant Fritchey (1/12/2015)
Yes. They could be. As I said, putting activity monitoring through trace or extended events will let you know what they're doing.
ok...Would I be able 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 12, 2015 at 6:12 am
Yes. They could be. As I said, putting activity monitoring through trace or extended events will let you know what they're doing.
"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:58 am
Viewing 15 posts - 6,931 through 6,945 (of 22,221 total)