Topics
Started by
Posts
Last post
Hi All, I was wondering if using CTE could lead to performance enhancement. My idea was if i have a…
11 replies
I have two almost identical queries. IDS INSERT_DML_FRAGMENTS.txt and GMS2 INSERT_DML_FRAGMENTS.txt…
6 replies
JOIN on date range is very slow.. Look at the bottom where it's using ">=" and "<=" FATCA_STG…
25 replies
Hi All, Can any one help me to get the script to find current queries /process that are running whi…
3 replies
HI. I have verified at DB level for Index farg and statistics are normal but still execution take l…
5 replies
Hi Guys, In below scenario we have 1033 BYTE free size on data page after adding 7 records & D…
1 replies
I am using SQL Server 2008, Enterprise Edition I have a piece of code that, when filled in with all…
2 replies
Hi Experts, Was checking an SP execution plan and found an Clustered Index Scan with cost 33% .Ther…
5 replies
Dear All, I was checking the execution plan of attached sql query and i found a strange behavior at…
5 replies
Hi, Ex : My backup strategy is like the following every 24 h full backup, every 3h differential bac…
3 replies
Hi, At our company we have a program that is fetching data from our SQL-server. There is not so muc…
2 replies
Hello SSC, Currently another developer and I are prototyping using a Table Type Parameter in a c# a…
4 replies
Hi All, Can any one help me to get the script to find the current queries and process that are caus…
2 replies
Hi All, I have attached a screen shot of a part of my plan. I couldn't understand why there is a th…
12 replies
I have a simple query, Select Max(Substring(nd_num, 12,3) from NDE where datepart(dd, nd_adate)=2. …
4 replies
Viewing 15 topics - 151 through 165 (of 636 total)
You must be logged in to create new topics.