Topics
Started by
Posts
Last post
I've been studying the possibility of indexing a particular view that takes 26 minutes to run, tryi…
9 replies
Hi Experts, Need some help on MERGE statement. It is failing, with below error message. Eventhough…
1 replies
Hello All,I'm trying to create a trigger that will encrypt a column when an insert operation is don…
4 replies
Hi, I am trying to write a script that will delete data from a given table using cursors. As shown …
8 replies
I have a Query which works fine but when I convert that query into a dynamic query, I get NULL valu…
4 replies
Hi Team, How to get execution plan of a SQL which has executed two days back? And how to comp…
2 replies
Hi,I am working on an Invoice summary query. I have multiple queries which need to be merged …
10 replies
All, I have gotten this backup script from the web. It seems to work but it is overwriting to the e…
10 replies
Hi, Can anyone help ? I have a view, an individual sales view. SET QUOTED_IDENTIFIER ONGO CREA…
4 replies
Below is the stored procedure which is supposed to return News Article data based on the parameter …
1 replies
I am optimizing an inline table-valued function that performs calculations by heavily using OVER, L…
8 replies
So.. I'm working on writing a generic CATCH block what will insert into a log table the following i…
3 replies
We are currently using SQL Server 2014 (enterprise) for our source system and data warehouse. …
4 replies
I've a table where record of different users is saved. I differentiate records based on UserID in t…
1 replies
Hello All, I have a table that has encrypted columns in it. Currently, I'm using a view to present …
2 replies
Viewing 15 topics - 1,411 through 1,425 (of 3,067 total)
You must be logged in to create new topics.