Topics
Started by
Posts
Last post
Okay, I'm editing my request per Lynn's suggestion. Below, in the comments, I'm posting the DDL to …
18 replies
The view gives the below output. CREATE VIEW V1 AS SELECT SELECT DISTINCT PT.PRO…
8 replies
Hi, I have a dataset that looks like this:CREATE TABLE [dbo].[PivotData]( [P…
7 replies
Hi, I have one indexed view. when I checked it through SP_SPACEUSED and DMVs, it gave me different …
1 replies
WHERE (B.ELIGIBILITY_FLG <>'Y' or B.ELIGIBILITY_FLG is NULL) and DM.ELIGIBILITY_FLG <>'…
10 replies
Working on a legacy procedure with multiple select statements . From dm_exec_query_stats was able t…
1 replies
I am working with a system in which I can query prerequisites for course enrollment in a query like…
11 replies
I want to know the different ways to search fast, efficiently in MS SQL Server. Someone please help…
2 replies
I have insert trigger for inserting records from T_PDF table into T_WV_RESULT Table.…
6 replies
Long time reader, 1st time poster here. I'm trying to build a stored procedure that creates a table…
10 replies
I have created a view using below tables. This view takes a lot of time for returning output. I am …
9 replies
I have a table with only 1 column "fldID". That column is a primary key (to ensure uniqueness), ide…
5 replies
I am creating the following statistics on a memory-optimized table: CREATE STATISTICS STATS_MyMemO…
2 replies
I'd like to be able to index a view having a WHERE clause on date. Index DDLUSE [Distribution…
3 replies
Hi AllI found this for 2012 that shows the new commandshttps://www.itprotoday.com/sql-server-2012-t…
2 replies
Viewing 15 topics - 646 through 660 (of 3,067 total)
You must be logged in to create new topics.