Topics
Started by
Posts
Last post
Is there a way to identify if there is any dynamic sql in use in a database that may be vulnerable …
25 replies
create table t1 (key int, cnt int ) insert into t1 select 2,5 union allselect 100,20union alls…
1 replies
I need to take numerical data from a CSV file and format it as follows: Value in File - Converted V…
8 replies
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
Viewing 15 topics - 856 through 870 (of 4,984 total)
You must be logged in to create new topics.