Duplicate post, please post any replies here.

Modified slightly to put the test data into a table and use that table as input to the code:

create table #TestData ( -- create temp table for the test data

...

Simply done using the code I provided you on this thread.

with TestData as (

select

PassM,

cast(EnterDt as datetime) EnterDt

from

(values

('Boo K...

It also is dependent on what you are porting to Oracle what needs to be done differently between PL/SQL and T-SQL.

george sibbald (1/15/2013)

---

sjimmo (1/15/2013)

---

Lynn

To restore to 1/13 4:00 AM you will need the previous days (1/12) full backup file plus all the t-log backups since that backup up to the...

nihal9200_kwada (1/15/2013)

---

Thanks ALL. i got it.

so current situation:

i need to restore database to test something (need to restore before 4 AM 1/13/2013)

1/13 backup started at 1 AM and finished...

Ramdas Baghel (1/15/2013)

---

Hi,

Why SQL Database files ware called "Virtual File" in sys.dm_io_virtual_file_stats - defination of this DMV is "Returns I/O statistics for data and log files. This dynamic management...

finno (1/14/2013)

---

hi Lynn

this is great, thanks for the outer join used also as making more sense to me now 🙂

would it be difficult if a value was to be...

Or:

DECLARE @start_of_day int = 15156;

select DATEADD(dd, @start_of_day, '19700101');

This help?

DECLARE @year_col INT = 2011,

@day_of_year INT = 182;

SELECT DATEADD(dd, @day_of_year - 1,DATEADD(yy,@year_col - 1900,'19000101'))

Something like this would work.

CREATE TABLE [dbo].[Client](

[clientID] [int] NOT NULL,

[expected] [int] NOT NULL,

CONSTRAINT [PK_Client] PRIMARY KEY CLUSTERED

(

[clientID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS =...

Also, iirc, if the files are being backed up to another location by another process and are locked by that process the delete will not delete the file and it...

cygne17_2 77208 (1/14/2013)

---

Hi,

yes I read this article.

I understand the possible data loss with high-performance mode(asynchronous).

But I still don't understand why we can have possible data loss with high-safety mode?

In high-safety...

SQL006 (1/14/2013)

---

thanks vinu

Now i am trying to join this query with a table to get the desire results

CREATE TABLE #tProduct

(

tProductID bigint PRIMARY KEY,

tProductCode nvarchar(128),

tProductName nvarchar(256),

tManufacturerName nvarchar(256),

tProductDescription nvarchar(4000)

)

EXECUTE...

Hard to say, we can't see what you see. Please read the second article I reference below in my signature block regarding assistance with performance problems. It will...