RE: Log backups and Trun. Log on Chkpt.
No you won't lose data b/c only active portion of the transaction log is backed up by SQL Server MW Edited by - mworku on 06/12/2003 6:32:19 PM
2003-06-12
1 reads
No you won't lose data b/c only active portion of the transaction log is backed up by SQL Server MW Edited by - mworku on 06/12/2003 6:32:19 PM
2003-06-12
1 reads
tulcanla, I played around with it a bit and found a HUGE difference when adding a where to the query. Normal selects and counts made no differance. Did you use a condition in your select? If so, why is it so much faster for me? Cheers, Crispin
2003-06-12
1 reads
Be sure the sql server is running. Also are you using NT authentication or mixed? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-12
Try changing your client Net Lib to Named Pipes MW Edited by - mworku on 06/11/2003 8:34:40 PM
2003-06-11
OK Frank, but Do you know, because SELECT * FROM [dbname].dbo.table_name_2 work instead SELECT * FROM [serverName].[dbname].dbo.table_name_2 not work ?? Bye Bye bye Flavio
2003-06-10
2 reads
sp_serveroption @server = 'SERVERNAME' ,@optname = 'DATA ACCESS' ,@optvalue = 'TRUE' Execute this on the machine you want to remotely access.
2003-06-10
1 reads
2003-06-10
1 reads
2003-06-10
2003-05-30
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers