Topics
Started by
Posts
Last post
I'm using the following SQL query to return a table with 4 columns Year, Month, Quantity Sold, Stoc…
5 replies
Am creating a view as below: CREATE VIEW VW_FIN315_FEES (FORM_NM, FORM_VAR_NM, FORM_TEST_VAL, FORM_…
4 replies
Hi all, Usually, when doing large INSERT SELECTs in tables, I drop compression, all constraints and…
4 replies
Hi Experts, I want to know if there any issues with the "SLEEPING" SPIDs. In one of our QA environm…
3 replies
Hi All, I have a question on objects and lock information. Is there a way to tell if any lock has b…
3 replies
Hi All, This one is general question. I see dev team quite oftem comes to Apps DBA team saying that…
5 replies
I'm working with a Stored Procedure that hopefully will return two recordsets to a Classic ASP appl…
1 replies
Hi All, We have below query which is taking quite a long time. Is there a better way to re-write th…
6 replies
I have a query which select employees salary, I need to bring all the employees and positions where…
11 replies
I need to be able to return a recordset of server name and database name for all databases that hav…
8 replies
I have a column named TPN which is a varchar type. 90% of the data are numeric values 5-9 in lengt…
4 replies
Hi, I have three input files for my SSIS project, 1. .txt, 2. .xml, 3. .xls. I've been able to brin…
5 replies
Hello Experts Need help with a query. Greatly Appreciated! In the below example, I need to pull on…
11 replies
Post was not responded to here, so I moved it here: https://www.sqlservercentral.com/forums/topic/…
1 replies
Hi, i need to retrieve the Table 1 A B C 1 2 3 2 4 6 3 5 6 Table 2 B E 2 4 2 6…
2 replies
Viewing 15 topics - 1,366 through 1,380 (of 3,091 total)
You must be logged in to create new topics.