Jeff Moden (2/7/2014)

---

wak_no1 (2/6/2014)

---

Bob, thank you, this is working as I'd hoped. I can sort of see what I needed to do.

One thing has just occurred to me though, I...

With the plans to move to 2008 right away, I don't think I would chase this too far. It sounds most like a "feature" with 2000. I haven't...

MyDoggieJessie (2/7/2014)

---

Just so you know, it's kind of dangerous to be using queries like this if you're not sure what they actually do (just saying). This being said, the...

Currently that script is looking for the data to be first

SUBSTRING (Col1, 1, 20)

Your backup file format has the date much later in the file name. You will want...

What is the exact script you are using?

krishna.vijayawada (2/6/2014)

---

HI,

I am in need of a script. Which have to pick the latest LSN with sequence automatically and restore it "XXXDB" in no recovery mode. can any one help...

I have had interviewers ask me these questions.

I have also asked these types of questions. I ask it to try and get the candidate to divulge a little bit...

I agree with the change to use the UNC instead of a mapped drive.

Are you running SSMS as the agent service account (i see you RDP'd to the box using...

You can try SQL_Latin1_General. It is reported to show as Latin1_General_CP1_CI_AI after installation.

Well you were close and did a fine job of posting your exact problem.

Those who answer questions...

homebrew01 (2/6/2014)

---

I run this as a SQL scheduled job on my Windows 2003 server:

[font="Courier New"]ForFiles /P D:\objectscripts /D -180 /C "CMD /C if @ISDIR==TRUE echo RD /Q /S @FILE...

Jeff Moden (2/6/2014)

---

What would be interesting now is to have a couple of drag races between your very much improved XML method, the UDTT method identified in this article, and...

Your best bet is to try that in Dev first.

While compression is great, I have seen it cause significant slowdowns in queries on very large tables (over 1TB).

I'd also evaluate...

Yes that could in some cases be the most efficient means of getting the script to run properly.

But...that is not always the case.

You really can't determine that until you fully...

Ok, it's not a terrible thing that they don't have clustered PKs.

Do they have any clustered indexes in the database at all?

You mentioned that the app has to be restarted...