Slowness in SQL server. - social.msdn.microsoft.com
Sep 19, 2014 · Thanks. You said SQL server is under utilizing and then you mentioned SQl Server was using only 31 G out of 128 and CPU was somewhere around 22 % don't you think …
Decrypting returns a NULL value - social.msdn.microsoft.com
Jul 14, 2008 · Now, I tried to backup this Database1 and restore it to another server with SQL 2005 instance called Server2. Of course the columns Card and SS Numbers were encrypted. I …
How to know installed Reporting Services is which Edition?
Dec 12, 2012 · I have installed SQL server 2005 Reporting Services Standard edition On Server A and the Created the ReportServer & ReportServerTempDb on Server B which is a SQL …
Column 'rowguid' in table 'Table_1' is invalid for creating a default ...
Jan 30, 2017 · I have a merge replication publication on a SQL 2008 R2 CU3 machine I am trying to replicate to a subscriber that is same SQL version.
permission to access database properties
Dec 11, 2013 · OK, I was too quick and I should have asked about the version of SQL Server you are using, and particularly the version of SSMS. Some more research reveals that what you …
Normally fast EF LINQ query suddenly starts timing out - works …
Feb 4, 2016 · Here is an odd one. We have a website application using EntityFramework to connect to an MS SQL Server database (SQL2010). We recently ran into a case where a …
SQL CLR stored procedure to return a result set.
Apr 3, 2015 · Been playing around with SQL 2008R2 CLR stuff in the last few days, really quite impressed. I've replaced a load a scalar & table valued functions that ran slowly and now it's …
Configuration Manager sites requires a supported SQL server …
Jul 18, 2012 · The strange thing is the SQL version still reads Version: 10.50.2500.0…which is the sp1 version…should this change? Why won’t the hotfix (update 6) fix my install problem?
Windows Home server 2011 compatability
Jul 31, 2018 · I have just started working with SQL Server 2012 in my career and would like to install SQL Server Developer on my Home Server (WHS 2011), however it is saying that:
Syntax error when creating database - social.msdn.microsoft.com
Nov 10, 2014 · It is a temporary database that gets recreated or altered frequently. The code checks for SQL Server, gets it's version number in order to use the default SQL Server path. If …