Ah from New Zealand you are.

Tomorrow is a big day for India and New Zealand at Hamilton. What a day it will be. 🙂

lmu92 (3/16/2009)

---

Did you notice, foxjazz didn't have to say anything within the last 70 (or so) posts? So he missed about 50% of the replies.

Maybe he's not interested anymore.

Or...

Setting up DB back up should not be a big problem. So start there.

What you will need to do is to get their trust and to show that you...

Put a Square bracket around the column INDEX in the select statement

INDEX is a Keyword in SQL. So you do a select as

Select col1, col2, col3, [INDEX] from dbo.view

where...

What would happen is that if there are any users or roles in your DB that has Select update insert and delete permission on this table, you will have to...

Maybe Fox should just stop using Database and start using flat files. That should solve his issues. 😀

Just kidding.... Fox, You should try to learn how to write efficient T-SQL....

Fox, You actually use a cursor for that kind of operation??? :crazy:

Hi Steve, I have a question for you. I tried to read the article " Is not encrypting personal info worth the risk?". Is it not hosted by SSC itself?...

Glad I could help.. 🙂

Do you have any Jobs, Scheduled tasks or something running that connects to that DB?

Yea, that is a max someone set up. I am not sure for what. Usually the default is Unrestricted growth if I am not mistaken.

This is not production right? If...

The NOT FOR REPLICATION is put when you create the table in the publisher. This is a valid configuration.

As per BOL NOT FOR REPLICATION is used in

Foreign key constraints

The...

Log files will grow when you snapshot is being done, But to this extent? I gig DB with a 45 gig Transaction log growth is certainly out of the ordinary....

Steve Jones - Editor (3/13/2009)

---

I'm torn here. I wouldn't be surprised if he got the job since most candidates can't answer those questions. At least not from the stories I...

I liked Steves answer to the OPs post asking for info about Clustered Index and fragmentation.. 🙂