SELECT * INTO NewTable FROM ... is the preferred method nowadays. That CREATE TABLE x AS SELECT ... sounds like an oracle command, since they like to make everything twice...

Were they charging by GB Transferred or something?

There are a million better ways to do it, including the one you mentioned. Merge is great. If you happen to have Record...

I'm pretty sure you don't even need to install BIDS to be able to connect to reporting services via SSMS.

That said, what permissions exactly are you trying to set? You...

Normalizing is great if you have a way to guarantee that you know all locations ahead of time...

How are these locations entered? If they are currently just free-typed into a...

Why not just script them out in a batch via object explorer details?

Then the only manual work you'd have to do is replace the passwords...and if you're using the same...

Thanks for replying and letting us know the root cause.

I actually just ran into a similar issue and this fixed it for me 😀

As gsquared said, there is no difference at all.

SQL will translate current_timestamp AND getdate() to the exact same code to be executed on the back end. There is no performance...

The SSIS package is independent of the SQL server version..it doesn't matter if the server itself is 32 or 64 bit. You can test a package on a 32 bit...

lol

What he's trying to say is that pic was edited after the screenshot was taken to just blank out those database names.

There is no way to actually hide them.

As with everything in SQL 🙂

But, one thing you really...

Roy Ernest (11/15/2010)

---

One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you are in...

Yes, that's pretty high for read times.

Your bottleneck might be poor coding/indexes though, which causes stress on the IO...check the execution plan for that query and try to tune from...

If you don't have a SQL login with sysadmin available to you (don't know the SA password), and your domain account is not an admin..well you're a bit hosed then....

Set your MAXDOP to half of your physical core count, ignoring hyperthreaded cores.

If you're running 2x Dual Core procs with HT, then you have 4 physical cores. Maxdop 2 would...

If you're doing a large cluster like that, there's still an extremely low chance that you'll have 2 servers down at the same time. Even if you did have two...