Dec 12, 2008 · The solution for me is to perform the spit in SQL server, as part of the query that retrieves the database. I'm using the fn_split and a cross apply to retrieve the data from SQL in a …

Feb 23, 2011 · - Run sp_who2 proc and check the blocking SPIDs. - Then run: DBCC INPUTBUFFER (SPID) to get the SQL query, script, or proc which is causing the blocking.

Mar 6, 2016 · On our newly configured SQL Server Windows NT 64 bit - very high memory usage show up. We have to reboot it to get it to normal (like to 10% RAM) - RAM usage grows continuously - and …

Nov 22, 2018 · I tired to Update SQL Server 2014 Enterprise to SQL Server 2016 Enterprise today. All components succeeded except Client Tools SDK and Client Tools Backwards Compatibility.

Jan 4, 2012 · Previously I was using SQL Server 2008 R2 Ent, but recently Downgraded this to SQL Server 2008 R2 Std, on same box OS having Windows Server 2008 Ent. (64) , after installation my …

Dec 21, 2013 · This happens because either the rights to the user running SQL Server Agent have been revoked, or the server instance name has been renamed.

May 14, 2020 · Thanks for your suggestion .Is there a way, to perform cross apply with dynamic values from another look up table. Say in your example you had mentioned CROSS APPLY (Values …

Feb 23, 2011 · With SQL Server 2005, the maximum number of supported instances that can be deployed on a Windows Server failover cluster in a clustered SQL Server configuration is 25 for …

Mar 9, 2016 · From your description, I would assume that you have SSMS 2008. Erland Sommarskog, SQL Server MVP, [email protected] Tuesday, March 8, 2016 10:42 PM 1 Sign in to vote No, I …

Dec 25, 2019 · (Because SQL Server instances should not be exposed on the net.) If you are developing a web app that is to run on your domain on godaddy, the SQL Server may on the same …