Topics
Started by
Posts
Last post
Hi I have been asked to convert the results from a select statement into a single row of data.…
8 replies
Good morning, I manage a SQL Server in which I have scheduled several jobs that are executed automa…
5 replies
I have added the code that was missing. Column A is not a dollar figure but a limit payed out. When…
1 replies
Hi All, Today, I came across a term which I wasn't aware of all these days. What is login less use…
7 replies
Hi All, I am using a Function code below for each row, this is called for 15000 rows. and it is wor…
2 replies
Running Idera DM and got some alerts for high signal waits and cpu was at 40 (usually 12)%. F…
6 replies
Hi All, How can I tell/prove, whenever I run a stored proc or an ad-hoc sql statement in SSMS quer…
1 replies
Hi All, Is there a better way to re-write below type of queries? Most developers tend to keep DIST…
5 replies
Hi All, Need some advise on the query plan analysis. There is stored proc within which a dynamic s…
19 replies
Hi All and Merry Christmas!I have what I thought was a simple requirement. I have to modify a table…
8 replies
Hey Guys, I stuck in a situation where I need to do parallel maintenance on few tables, Can someone…
8 replies
Hi, I am experimenting with various permutations and combinations to understand how the range_scan_…
1 replies
In t-sql 2012, I want to setup a stored procedure instead of having the sql direcdtly in the ssrs 2…
7 replies
Hi All, This is related query tuning. I have a query which is doing expensive sorting. Without ORDE…
19 replies
Hi All, Is there a better way to rewrite below code without using DISTINCT operator. Other thing, i…
7 replies
Viewing 15 topics - 856 through 870 (of 4,984 total)
You must be logged in to create new topics.