USERSTORE_TOKENPERM growing very fast - social.msdn.microsoft.com
Jul 15, 2019 · To me it seems like a bug, MS had such bugs in SQl Server 2008/2008 r2. I would also see amount of ad-hoc queries hitting database because that affects "userandtokenperm" the relation …
Moving SQL DB Transaction Logs to Another Drive
Mar 28, 2016 · SQL Server 2014 with 1 default instance in a failover cluster of 2 nodes. We finally got another drive for the SQL server and want to move the transaction logs to this drive.
subscription management from within SQL server.
Mar 15, 2012 · long story short, i need my subscription management to be run from within SQL server, so that all applications can use subscription management features. several of our applications have …
SQL Server Windows NT 64 bit - very high memory usage - Have to …
Mar 6, 2016 · On our newly configured SQL Server Windows NT 64 bit - very high memory usage show up. We have to reboot it to get it to normal (like to 10% RAM) - RAM usage grows continuously - and …
NEWBIE : how to create a new instance of ms sql server database
Nov 26, 2012 · When you install SQL Server you can install it as a default instance or named instance. Only one default instance and a maximum of 50 named instance per server. in your case try install …
ERROR 1101 : Could not allocate a new page for database because of ...
Sep 1, 2011 · There is a very good book exist to discuss about the disk performance issues and various DBA ACTIVITY If not planned well which might affect the DB. If you get a chance please refer to …
Restarting a sql server 2008 r2 - social.msdn.microsoft.com
Feb 26, 2014 · i restated a sql server 2008 r2 in my local system and suddenly i lost all my Databases except system databases.
What's the value of avg_page_space_used_in_percent when checking …
Apr 9, 2013 · I see that the avg_page_space_used (returned from sys.dm_db_index_physical_stats) value for one of my heap tables is high (99.4924), but I don't quite understand the meaning of this …
Is it possible to create dynamically user defined table types
Mar 25, 2015 · OP, technically it is possible to do whatever you want with dynamic SQL, but as Scott suggests this is somewhat at odds with what a relational database is all about.
Huge Tempdb usage - social.msdn.microsoft.com
Jul 8, 2016 · Hogwash. There are SQL Server databases out there which exceeds 1PB. Compared with that 2-3 TB are toy databases. The only thing that as such that comes with size is manageability, that …