SQL Swerver (4/22/2014)

---

Thanks Grant. That is helpful info even if it's a 'no'! 🙂

How would one configure the Azure SQL Database firewall to allow an Application hosted in Azure PaaS...

Use correct data types. If you need a floating point number, use a float. If you're expecting an integer, use one of the integer data types, not the float.

I'm with Yogeshwar Phull. Don't use show_contig any more. The dynamic management objects are so much better for this type of information.

Deadlocks are fundamentally a performance issue. So, are the other databases the same size as the one that's getting the issue? Are the same indexes in place? Are the statistics...

Here's the Books Online entry on DDL Triggers.

The thing I'd look to are the wait statistics. What's causing the system to slow down? That will tell you if you are stuck on I/O or if it's something...

I'm pretty sure there's no way to trace by JobId. But, you can trace by application name, so that will make it so you only ever get calls from SQL...

You can get a bunch of information from the backup files themselves, all through T-SQL. I've got an article on it over at Simple-Talk[/url].

Steve has largely nailed it. Be cautious using extended events to capture all statements though. That can be a ton of information.

Now, if you're running SQL Server 2014, you can...

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...