Topics
Started by
Posts
Last post
Hi, I have a vendor app that runs an SQL DB. Now the vendor provided all the agent jobs for this DB…
7 replies
Hello Everyone This morning I began receiving data thru on of my data pumps that contains an incorr…
3 replies
Hello I have a procedure that uses a cursor and inside the cursor i have an update statement like t…
7 replies
Hello, It seems that DELETE statements don't support aliases. Is that correct in 2k8R2? Also, the q…
5 replies
I have 2 requirements: 1. Find the growth of user databases over a period of time, say for last 3 o…
1 replies
I am using SQL 2008 server and an external vendor changed the particular warehouse name for the IMP…
17 replies
Dear members, Hello, a pleasant day to everyone. I would want to ask help about this query that I n…
4 replies
Consider the following code CREATE TABLE EMP3(EMPNO INT IDENTITY,NAME NVARCHAR(50)) INSERT INTO em…
4 replies
Hi all, I tried deleting a temp table using the below following code IF EXISTS(SELECT * FROM sys.…
2 replies
Hi, Our developer send me a query that takes long time to run. it has a query structure like this, …
8 replies
Hi, Again with same doubt about using OPENXML or nodes()... In previous tests I made with both meth…
8 replies
Hi guys, I am working on task where i am gonna clean my DB. I would like to know is there any way …
2 replies
The code below is from a SQL trace I did to find out how our ERP system generates a gross profit re…
6 replies
To keep this simple i'm going to include an example however there are actually several scripts that…
19 replies
Is it possible to have orphaned extended properties in SQL. And if so what is best practice to clea…
5 replies
Viewing 15 topics - 4,426 through 4,440 (of 10,647 total)
You must be logged in to create new topics.