May you elaborate more your question please ..? It seems you are talking about RAM distribution between servers Is it right..?
The Table shift is just a lookup table so if you want to do a join between Trans table and this table based on each employee , you should have to...
Normally linked servers have some quirks related to security login mapping between the 2 DB servers so to be resolve them basically please try the...
If it is the case, you may try the below query but I am presuming first you have a table for Employee's tme sheet named employees_shift select...
You can try that one below: SELECT Relevant, COUNT(*) FROM LegalReviewView_ATW_2012_ECC WHERE (IsRepresentation=0 OR (IsRepresentation=1 AND...
If I can understand it well , you want to calculate the time spent compared to 9 hours , is it shorter or longer and how much it is shorter or longer...
We have 2 kind of master keys: · SMK (service master key) which should be installed on the entire of SQL instance to link it with the...
As per my simple understanding about your case, it is right you should install SSIS package on both DB principal and DB mirror servers to assure...
First welcome to Forums.. Performance Tuning is a big article and normally it is composed of 3 phases : · Capture Expensive queries using...
such circumstances need normally for a full healthy check on DB server level to find out all waits and bottlenecks that can impact negativity on such...
To avoid that delay related to update statistics , you can enable the option AUTO_UPDATE_STATISTICS_ASYNC which can help your queries to work...
Adding little bit more for what Luis said, update statistics can be useful here for that troubleshooting cases , you can do this also using exec...
If it is not the case neither variable length nor line break , I suggest to expand the length of @command to be nvarchar (max)because I doubt 4000...
First, welcome to forums … Usually XML performance is going badly unless you create a primary XML index at least , but I get afraid about the DB...
I do forecast it is related to DB having either : · Name size more than the defined DB size of @Databasename variable which is less probable...
First , welcome to Forums.. It seems your query has nothing to do with the amount of output records but it is impacted potentially by either “where...
Adding little bit moe for what Luis said , normally the consistency of query execution plan depends on lots of factors , one of them is buffer...
1-To know how is the principal mirror relationship established using a witness server , it needs for multiple steps to build DB mirroring of the...
First of all before judging on replication that it is the root reason beyond log file inflation , you should run dbcc opentranon your DB having...
For building a linked server between SQL Server and Oracle , we are usually install an appropriate Oracle client provider like Oracle 11g R2 client...
Separate names with a comma.
