-3
Is there any complex EE session that can be used to collect performance data on SQL server on daily basis (Queries and their plans , waitings , blockings ,lockings ) , I want to create such session and just want to be sure that there is enough data to analyze and if it possible please provide scr...
I have one written one query as per below. Its not giving result when i did sub- string.
Declare @Result varchar(max)
set @Result=(select top 1 value from empkeyValue)
select *
from department d
where (SUBSTRING('department4', 1, 11)+Convert(varchar(10), 4)) = @Result
Here when i wrote th...
How can I capture the query or performance metrics over a period of time, say a month, so that later they can be analysed for performance? I'd like to use DMVs or extended events.
I am trying to achieve something similar to query store but since we are on SQL Server 2012 and 2014, I can't levera...
I am trying to run a simple ...
SELECT * FROM TableName
... on a database table. SSMS intelligence does not recognize the table and query also returns error on execution. When I R-click and Select Top 1000 Rows, then there is no problem. To play it safe I use copy and paste the TableName to m...
I am using SQL Server 2005 (I know...it is old!) and I wrote a stored procedure where the main part makes a few JOIN and OUTER APPLY between tables with 500.000-1.000.000 rows table, then INSERT the results into a table.
I know that is not clear, but it is very hard for me to explain how the SP ...
when i run query to ConcatRelated()
SELECT DISTINCT TblBooksDetail.AccassionNumber, ConcatRelated("AuthorName","TblAuthorsDetail","BookIDFK=""" & [BookIDFK] & """") AS AllAuthors, TblAuthorsDetail.AuthorName, [JTblBooks&Authors].BookIDFK
FROM TblBooksDetail RIGHT JOIN (TblAuthorsDetail RIGHT JOI...
Please forgive my question if it sounds trivial. I would like to dump the result sets of a query to a csv file on remote postgres server (on a very large table), so that when done I can copy the file to localhost and read to a destination table.
Here's the query:
SELECT
be.temperature_data AS...
