ekknaveen (11/18/2010)

---

Thanks for your information, I dont want to change the current desing. Keeping the current design is there any way sothat blockings can be eliminated. Is it good idea...

Drop the snapshot and create a new snapshot with the name you want.

Adiga (11/17/2010)

---

Even though the "password" option encrypts the backup file, the encryption is not strong enough. You can encrypt the entire database using TDE or use a third party tool...

LiteSpeed supports encrypted backups.

Redgate web site says their Backup Pro (not Lite) supports encrypted backups.

I'm fairly certain that there is no ANSI standard for SSIS. ...

The best thing to do would be to switch to using an identity column.

If you must keep the current bad design:

1. Make one table for each table you are maintaining...

Solution to the OP's question using a calendar table:

select

WEEK_NO=

min(a.WEEK_STARTING_TUE_SEQ_NO-b.WEEK_STARTING_TUE_SEQ_NO+1) ,

WEEK_START_DATE=

min(a.[DATE]),

WEEK_END_DATE=

max(a.[DATE])

from

-- Date Table Function F_TABLE_DATE available here:

-- http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

F_TABLE_DATE('20100901','20100930') a

cross join

F_TABLE_DATE('20100901','20100901') b

group by

a.WEEK_STARTING_TUE_SEQ_NO

order by

a.WEEK_STARTING_TUE_SEQ_NO

Results:

WEEK_NO WEEK_START_DATE ...

Experienced developers, like Jeff, understand that doing a crap job the first time around and then having to fix it is much more expensive than doing a good job the...

Learner1 (11/15/2010)

---

thanks ,,,,,,,no it's not a home work

its again an interview quetion but I got an answer already...

this can be done using a corelated query

SELECT DISTINCT (a.age) FROM test55...

Craig Farrell (11/15/2010)

---

"So, that's your...

GilaMonster (11/15/2010)

---

I've used that...

There have been a lot of alternative suggestions posted, so maybe it’s time for a performance test… 🙂

FYI: I never vote on anything, so don't blame me for the...

Restore simply creates the database file the way they were when the backups was made.

If you need to shrink them after the restore, you will have to set that up...

It's...

David Lester (11/15/2010)

---

Ha! Ha!

The consultant they hired came in and after all day told them what I was telling them. The problem is in the hardware, or configuration of...