It's also possible that in addition to the client not keeping up, the client is asking for too much data. In addition to looking to the client coding, you should...

Hello,

Disclosure: I work for Redgate

Thanks for the kind words.

We have a web site that has a ton of articles on how to automate your deployments using our tools. The samples...

Really? What about in the case of recompiles?

Here's an example of a Powershell script that will do this. You should probably still plan on exporting to a file first and then import from that file for the...

mlorek (8/12/2015)

---

Thanks for the replys everyone. I have tried from different versions of ssms 2014 and the same behavior exists. If I use 2008r2 it sees the revoceryplan...

Hard to say. I've driven my career by interest and opportunity. What am I interested in and what do I have the opportunities to do. So far, that's by and...

Me too. I sent an email to RG support. Maybe someone did something.

I'd say neither.

Instead, I'd suggest normalizing the scores/marks out to their own table. Then, store them as the correct decimal values. Rounding and prettying can occur on the application/reporting side...

For unstructured or semi-structured data within the Microsoft sphere, you're looking at HDInsight[/url], they're version of Hadoop, or DocumentDB[/url]. If you want to stay within the Microsoft stack, and I...

You can use DBCC FREEPROCCACHE to target a single execution plan. Something like this:

SELECT @PlanHandle = deqs.plan_handle

FROM sys.dm_exec_query_stats AS deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

WHERE dest.text LIKE 'CREATE PROCEDURE dbo.MergeSalesOrderDetail%'

IF...

WayneS (8/11/2015)

---

We've known how to stop SQL Injection for over a decade now. I'd be curious to know others thoughts as to why they think that SQL Injection is still...

Full disclosure, I work for Redgate.

There are really two tools on the market that provide everything you need for database build and deployment. The first is Redgate SQL Source Control...

The SQL Server Database Tools (SSDT) can do most of the work it sounds like you're doing manually. You just have to use the CREATE PROCEDURE syntax to put the...

JManuelN (8/12/2015)

---

Hi,

Have you tried to attach a SQL Server Profiler so you can see what is doing while you open the restore window? It maybe give you some hint.

Sorry for...

Something must be wrong with your SQL Server Management Studio then. I just validated that it does exactly the same thing on my system as it has always done, open...