Question : I have 2 table in my database. Table #1 ————————————————————————- | name | family | phone | email […]
Tag: sql-server-2014
Who is using my worker threads? SQL Server 2014 – HADR
Question : We had recently a problem on our SQL Server 2014 HADR environment, where one of the servers ran […]
How to find column which causing “Conversion failed” error
Question : I’ve run into quite a lot of issues specially when it comes to conversion errors: convert(datetime, [fieldname]) or […]
Getting a list of active objects that use cursors but don’t explicitly close/deallocate them
Question : Sometimes our developers will write a query that uses cursors, but doesn’t close them out explicitly. I’m trying […]
sa doesn’t have permissions to other database through synonyms with the Service Broker
Question : I’ve been trying to get this Service Broker and timers thing to work for over a week straight […]
How To Grant A User In AD Groups Which Is Denied To DML Commads, To Update On A Spesific Tables
Question : I have a Active Directory user account named SQLQRY in my sql server. SQLQRY is permitted only read […]
Finding the row with the latest date for each row type
Question : I’ve got an SQL database (SQLAzure V12 version running on Azure) that looks like the following: DECLARE @VehicleData […]
Querying system health data becomes slow as event volume increases
Question : We get the data from system health XE from SQL server and load into table for later querying. […]
What is the date time format for msdb.dbo.agent_datetime scalar value function?
Question : Looking at msdb.dbo.agent_datetime scalar value function. What date / time format is this expressed in, UTC? Same question […]
Wingdings font in SSMS’s column
Question : I do want to create a column which should has check marks and cross marks. Here is the […]