Topics
Started by
Posts
Last post
Hi All, I have one SP to performance tune and the MAX function is not properly working on the VARCH…
29 replies
Hi. I want to find address duplicates. ACCOUNT and ADDRESS are columns(all the addresses are format…
3 replies
Hi All - Quick question. Is there a way to have the columns returned in my query results window aut…
1 replies
I run 2 queries at the same time with include actual execution plan, and it says query A is taking …
1 replies
Hi guys I'm starting to delve into the advanced TSQL world and could use some assistance. Basicall…
5 replies
I have a table with these columns: price product 1 toy 2 toy 3 toy 4 toy 5…
3 replies
Can anyone explain why it would be more beneficial to store date and time values separately, rather…
4 replies
I have the following code that I'm trying to implement. I have a successful solution using SQL CLR…
1 replies
SELECT T1.col1 FROM Table1 T1 INNER JOIN Table2 T2 ON T2.col2 = 'somestring' WHERE T1.col2 <>…
7 replies
Hi, I have the following query: select @drawdrownPct AS largestDrawDownPct ,avg(pctAccountChange)…
5 replies
I have a query design question related to using CASE statements vs. INNER JOINs and the effect on p…
3 replies
I have the following table: drop table #trades go create table #trades ( tradeId int not null prim…
5 replies
Hi all, can this query be written to get rid of the SORT in the execution plan? First it does an I…
8 replies
Which is better approach 1. Multiple SPs for similar functionality or 2. Separate proc for each fun…
9 replies
i,can any one help me in populating time dimensions in sql from 2000 to 2030 for every 15 min.now i…
3 replies
Viewing 15 topics - 8,851 through 8,865 (of 10,635 total)
You must be logged in to create new topics.