Viewing 15 posts - 7,951 through 7,965 (of 49,571 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...
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...
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.
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...
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...
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....
September 2, 2014 at 6:44 am
crazy_new (9/2/2014)
September 2, 2014 at 6:39 am
Remove the table from the publication, then drop it.
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/
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.
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...
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...
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...
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...
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...
September 2, 2014 at 2:23 am
Viewing 15 posts - 7,951 through 7,965 (of 49,571 total)