Viewing 15 posts - 6,946 through 6,960 (of 22,226 total)
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
Make sure you have backups in place and that you've tested them by running a restore prior to starting this process.
"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:49 am
I'm not aware of a process that will tell you what changed a specific page on the database. I think you're just going to have to go with standard activity...
"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:45 am
Yeah, tuning the queries so that they run correctly is always a good option.
"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:38 am
Then the implication is that you have some process or other that's hitting 400 of the 500gb worth of pages on your database. Is there a nightly load or some...
"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:34 am
Are you initializing each backup file or are you stacking them together into a single file?
"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:17 am
You should take a look at the Resource Governor.
"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 11, 2015 at 10:41 am
Functions on columns like this are going to lead to scans on your indexes
and iif((@StartDate = '1900-01-01' or @EndDate = '1900-01-01'), '1900-01-01',PO.CalendarDate)
...
"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 11, 2015 at 6:15 am
The amount of time it takes is completely dependent on the size of the index in combination with the ability to get access to resources. At 1.5tb, it's going 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 11, 2015 at 6:06 am
100% agreement with all that Jeff said.
One question. If you're not doing differential backups, is it any big deal that they have an extra full backup going on?
"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 11, 2015 at 6:02 am
You may also see this if the extension is different. It's one of the many reasons I prefer using scripts for restore anyway. The GUI is limiting and difficult.
"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 11, 2015 at 6:00 am
Viewing 15 posts - 6,946 through 6,960 (of 22,226 total)