Jeff Moden (4/17/2012)

---

GSquared (4/17/2012)

---

Jeff Moden (4/15/2012)

---

vm.chowdary85 (4/14/2012)

---

hello everyone.

i got a scenario like this i got 5 parent tables and 30 child tables in the source using SSIS control flow and...

Rebuilding an index automatically rebuilds the stats on it.

If you reorganize an index, you might need to rebuild stats, but not if you rebuild the index.

If I'm not mistaken, the best way to validate the addresses before sending them would be to query the AD data. Here's an article about doing that: http://www.databasejournal.com/features/mssql/article.php/3849891/Query-Active-Directory-Data-from-SQL-Server-using-T-SQL.htm

What I...

If you think that's fun, trying Googling "&"...

CELKO (4/15/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how,...

Jeff Moden (4/15/2012)

---

vm.chowdary85 (4/14/2012)

---

hello everyone.

i got a scenario like this i got 5 parent tables and 30 child tables in the source using SSIS control flow and data flow ...

vm.chowdary85 (4/14/2012)

---

hello everyone.

i got a scenario like this i got 5 parent tables and 30 child tables in the source using SSIS control flow and data flow i need...

You'd have to build it as dynamic SQL. It looks like that's the direction you're already going.

Have you looked into using a third-party solution? RedGate (site owner here)...

Floor. Exactly like grade-school division.

8 divided by 3 is 2, with a remainder of 2. It gives you 2 as the answer, because "remainder 2" isn't expressable in...

The point in the article about partial (piecemeal) restores is that if you exclude a filestream file from the restore process, you can't restore to point-in-time anyway.

There isn't an option...

I'll second the motion for moving the whole process into SSIS.

I have a package that outputs three files every night, dynamically names them, encrypts them using GnuPG, and then FTPs...

You'll definitely need to make sure SQL Server doesn't start up till the drives are available for the system databases and user databases, at the very least. Otherwise, you'll...

Will it harm anything if you end up with some zeroes at the end of the number, after the decimal place? If not, try casting to Decimal instead of...

Are you mounting the installation ISO as a virtual drive using VMWare? If so, you'll have problems with that.

Try using something like MagicDisk to mount the ISO from within...

Set up a shared directory on the second server, with "Full" permissions for an account on both domains. Then robocopy the files over.

If you can't do that, can you...