Viewing 15 posts - 7,951 through 7,965 (of 49,552 total)
Books online is again wrong. It is supported, providing there are no minimally logged operations in the log interval containing the time that the DB is being restored to, as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 10:21 am
crazy_new (9/2/2014)
That's why in this case I cant do set base, because I need to use data from other tables as well, not just the inserted data.
Why not?
That's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 8:30 am
river1 (9/2/2014)
Can I use Express Edition ?
Yes. It's a per-database limit
I have 4 maintenance plans. Dés the Express edition support maintnance plans?
No. Express does not include SQLAgent.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 8:28 am
crazy_new (9/2/2014)
In the inserted/deleted tables, does it contain all of the records of the last single transaction made?
It contains all of the rows which the statement that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 7:41 am
crazy_new (9/2/2014)
But by writing it to deal with batch inserts, would you write a cursor in to execute this for all the new ID's inserted?
No.
You'd write is using...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 6:55 am
cliffgettings (8/29/2014)
All I have it the order I it appears in the table, data is appended each time
There's no such thing as the order of rows in a table....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 6:44 am
crazy_new (9/2/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 6:39 am
Remove the table from the publication, then drop it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 6:34 am
peter larsen-490879 (9/2/2014)
Hi John,Yes COALESCE is the way.
It works, providing good performance is not a requirement. If performance is a requirement, see http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 5:59 am
Perry Whittle (9/2/2014)
jamessdba (9/2/2014)
3) In BulkLogged can we take Point in time recovey?You don't, they're not supported
You can. It depends on whether or not there's been a minimally logged operation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 5:58 am
crazy_new (9/2/2014)
SET @PAMID = (SELECT
MAX (PAT_ACCOUNT_MANAGER_ID)
FROM
PAT_ACCOUNT_MANAGER
)
Still assuming that the highest value in the table is the one you're dealing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 5:48 am
Firstly, why?
Is it a problem? Costs in a plan have to add to 100%, so a single operator with a 'high' cost is not necessarily a problem. Is the query...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 5:45 am
In-memory OLTP is for very, very, very specific scenarios (very high speed inserts mostly). It's not a magic silver bullet for everything. It can easily be slower for inappropriate uses...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 2:35 am
sej2008 (9/1/2014)
I make changes in datatbase and before restoring take last log backupBackup log db1
to disk='c:\myfolder\Taillog.trn'
That's not a tail-log backup. That's just a normal log backup. It doesn't have the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 2:27 am
jamessdba (9/2/2014)
Hi experts please answer these doughts. in sqlserver 2005/8R2
Interview questions? (btw, 'doubts')
1) If principle server down what willl happen to Mirror DB & Transactions
Depends on how the mirroring is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2014 at 2:23 am
Viewing 15 posts - 7,951 through 7,965 (of 49,552 total)