Probably a double hop on Kerberos and I was going to link to the same article. That's the place to go.

Again, for PDW, I strongly advise you track down information from PragmaticWorks. They're the experts. Here's their web site.[/url]

Yeah, I've applied to Maine, but no word on if I got picked. I'm doing a pre-con at Albany, so I'm pretty sure I'm picked there. See you at both!

In general, I would consider this a very dangerous position. You may have dirty data in your systems and you won't know it.

Now, you may be in one of...

PDW might be a little different. I'm not sure. I've never worked with it. You might be better off tracking down someone from Pragmaticworks. They're the real PDW experts.

ramana3327 (4/18/2014)

---

Thanks Steve.

So depends on the user seeks count, we can get idea about the dropping of the Index.

Suppose if you have index1 with one key column and index2 with...

Yeah, Brandie has a good point. Reports can usually afford to wait a bit. Active OLTP systems can't.

I'm not crazy about either approach. I prefer what you've done in the first approach. An employee has one or more salaries, so the Employee table (Not sure I'd call...

Since you're working for a non-profit, I'd probably concentrate on keeping licensing costs down, so, as few servers as possible. While you can split your databases across multiple instances, you...

Oh, I don't know. I don't use SQL Server to send emails except for alerts. If I had to do that, I'd probably go to Powershell for it anyway. There's...

The only way to know indexes with a partial match are good or not is to evaluate those indexes with your code. There's no way to say for sure based...

This is an article[/url] that I wrote on statistics. Here's another[/url] answering a series of common problems about statistics. If you have specific issues, let us know.

You can't really do this yet because SQL Database doesn't support Windows logins, so there's no way to add it to a network. Since it only supports SQL Logins, you...

No, a backup needs to be restored. You can only attach a database that has been detached (or at least shut down).

Does your backup use WITH INIT? It really sounds like the backup is stacking up. What is the precise command you're using to do the backup. If you're using the...