Viewing 15 posts - 406 through 420 (of 1,518 total)
ALZDBA (10/14/2010)
- can you post the actual tsql you tried ?
(and their results)
- what's the relation between the service account and...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2010 at 11:51 am
ALZDBA (10/14/2010)
did you try "sp_changedbowner newlogin, true" ?
This looks equivalent to what I did through SSMS, but I'm still not sure why the service account was not as good as...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2010 at 11:31 am
OK, I fixed it, but I don't understand how... :hehe:
In SSMS I right-clicked on the database, chose Properties, clicked on Files tab, and changed Owner to sa (it was...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2010 at 11:02 am
Here is something odd:
in the said database, under Security/Users, I right-click on the database user "dbo", select "Properties: the User name is "dbo", but the Login name is the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2010 at 10:49 am
When I right-click on the database, select Properties, in the General page the owner is the SQL service account and not the login I am trying to unmap. (I'm on...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2010 at 10:31 am
I think your idea has a lot of merit. I'm actually also planning to do something similar, if for no other reason than to get a feel of doing things...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 13, 2010 at 1:33 pm
You may have already seen this link, but here it is; it describes an alternative way to what you are trying to do, and complications that come with it:
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 12, 2010 at 10:06 am
reggie burns-317942 (10/11/2010)
Thanks for all the input.
After running update statics on 5 of the must active tables the queries are running much better, as if it was still in...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 11, 2010 at 3:43 pm
See "SQL Server 2008 Upgrade Technical Reference Guide":
Here are the steps:
1. Change db compatibility level to 100 on all upgraded databases
2.(ONLY...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 9, 2010 at 4:25 pm
I sent it to all developers on my workplace, and after that no one was talking to me that day...
I loved it! 😀
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 8, 2010 at 10:07 am
Hmm, it may not be too surprising that I cannot upgrade from SQL 2008 R2 to SQL 2008 SP2.
SQL 2008 R2 is probably on a different version stream, so it...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 2:47 pm
Shawn Melton (10/6/2010)
Just curious but how much memory do you have on the server? Is the server do something else other than SQL Server?
48 GB.
I know, I can't explain what...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 2:35 pm
Now I'm getting following error;
can I not upgrade from SQL 2008 R2 to SQL 2008 SP2?
There are no SQL Server instances or shared features that can be updated on...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 2:29 pm
After restarting, I can get past that point, so it seems it was an issue with memory resources on the server...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 2:22 pm
It looks like I ran out of memory while applying the SP (!), so setup assumed there was an actual problem with the server configuration;
I have restarted the server and...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 2:16 pm
Viewing 15 posts - 406 through 420 (of 1,518 total)