devullapallymanidhar (9/14/2012)

---

I have a tricky situation where we have a server with a default and an instance.In the default we have 4 databases

for example (A,B,C,D) and we mirror them to...

There are any number of FTP utilities you can use to accomplish this. Once you get the file onto the dev environment, decrypt it and put it into another location...

Okay, try this on for size (it's just a wag, but...)

The order of query evaluation is supposed to be:

1) FROM

2) ON

3) JOIN

But the FROM clause is a CROSS JOIN, which...

The execution plans on both of them are identical. Same objects, same percentages. (Once I swap the tables in the FROM clause, that is). Same results, same everything.

But wouldn't something...

Stefan Krzywicki (9/14/2012)

---

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index column ordering], but I still want a...

Not knowing anything about Oracle, I can tell you that there is a problem with the way the data is being translated between the two (numbers are getting cut off)....

If you have multiple queries trying to update the same table that is...

Check to make sure the Hindi collation is setup on the server on which you are doing the query.

Other than that, I don't know what answer to give you....

Tangently related to the post under discussion, I've found there are a lot of rookie writers who think that when you tell them "this won't work" that you are not...

Do we recommend the consultant before or after someone posts "Take the database offline. Delete all the .MDF and .LDF files. Recreate only the .MDF and .LDF files that you...

Lynn Pettis (9/13/2012)

---

Brandie Tarvin (9/13/2012)

---

SQLCrazyCertified (9/13/2012)

---

I am trying to shrink to see how much it will free up......if that does not help enough, what about creating a secondary file.....ndf...in another...

Wow. That does sound cool. Thanks for letting us know about it.

You use a combination of PerfMon and a SQL Server server-side trace to monitor the package while it's running.

SQLCrazyCertified (9/13/2012)

---

I am trying to shrink to see how much it will free up......if that does not help enough, what about creating a secondary file.....ndf...in another drive......we have another drive...

primadona