Mirroring and Server database performance issues
Sep 3, 2013 · I have a database mirroring server with Sql server 2012 service pack 1 standard edn on windows server 2012 standard edition Processor Intel Xeon I350 and 8 GB of Ram on both principle …
Can I shrink the database for database mirroring
Jun 29, 2013 · There are some tables which would like to be deleted and can I know whether I can free up some space (shrinking the database) after I delete the tables ? .
Limiting the number of concurrent sessions per user
Feb 12, 2019 · As following to my local security policy, I have to establish the limit appropriate to the type of user account accessing the SQL Server instance on SQL Server 2014 Enterprise.
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 …
TSQL Script to restore the latest full backup from shared path
Sep 19, 2019 · I need a Script to restore the latest full backup from shared network path.
SSRS configuration manager - social.msdn.microsoft.com
Jun 28, 2013 · Can anyone point me to a simple explanation of using the SSRS configuration manager to manage different servers for shared data sources and project properties per configuration. It …
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · USE [databasename] GO StoredProcedure [dbo]. [sp_RebuildIndexes] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo]. …
Sending data from one system to another
Oct 29, 2014 · That's what MS SQL Server Service Broker is for in this type of senario. You would have SB Triggers on the tables in DB1 that did inserts, updates and deletes where the transaction is …
DB role unable to delete-The database principal owns a schema in the ...
Aug 8, 2019 · The database principal owns a schema in the database, and cannot be dropped.
How to write calculations for CurrentWeek,CurrentMonth, Current …
Feb 3, 2016 · I need to write the MDX Expressions to calculate the [Incident Count] for CurrentWeek,CurrentMonth, Current Quarter.