Question : I have a simple table in SQL Server 2012 which implements a processing queue. As data has been […]
Tag: sql-server-2012
Inserting fetched records into new table
Question : I’m fetching some records with below query: ;with tb1 as (select * from tb where condition), select … […]
Logs growing and took up entire log drive even with log backups [duplicate]
Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]
correct security and user setup for SQL Server database
Question : I am currently on setting a sql server database on a database server. A front end web application […]
SQL, SQLCLR objects & effective memory utilization
Question : We’ve recently converted our ERP system from IBM Universe to SQL Server. Application performance is generally tolerable but […]
Stored Procedure Execute as Owner Close Database Connections Not Working
Question : I created a stored procedure to allow users to Close All Db connections in the QA environment. I […]
A lot of ad-hoc queries impact on server
Question : We have a third party application which generates a lot of ad-hoc statements (our server has 16GB of […]
Unique index for subquery with RANK() function
Question : I have the following tables: CREATE TABLE Revision ( RevisionId INT PRIMARY KEY IDENTITY, UserName NVARCHAR(256) NOT NULL, […]
SQL Server Try_Cast returns Null value
Question : Related Questions ,TRY_CAST(Question_Text AS xml).value(‘(/p/text())[1]’,’nvarchar(1000)’) AS Question_Text2 With the help of CharlieFace on my previous post I discovered […]
What does a “Buffer cache hit ratio” of 9990 mean?
Question : I got this query from a blog post: SELECT object_name, counter_name, cntr_value FROM sys.dm_os_performance_counters WHERE [object_name] LIKE ‘%Buffer […]