alex.sqldba (12/8/2016)

---

Evening All,

I have an archive routine that runs every night, it inserts some rows and then performs a delete. Basic stuff.

I have had to move the archive database to...

You need to make the updates conditional. Add something like

WHERE a.load_id <> q.load_id or a.load_id is null

to both queries.

You still haven't explained why.

Lowell, that's a neat trick!

Next step would be some refinement to return the actual SQL needed, ready for cut & paste. This sort of thing (borrowing your code):

IF OBJECT_ID('tempdb..#temp', 'U')...

I think you are out of luck. There is no magic 'reduce the size of files without shrinking them' command.

First thing I'd suggest is removing this line:

INNER JOIN dbo.Drops D ON J.JobID = D.JOBID

As it is no...

padmakumark26 (12/8/2016)

---

With user which have default schema we can access object without specifying schema name right ?

Like select * from table .

But i cannot access like that it is...

I...

Maybe you can use an external SMTP provider. Have a look here[/url].

dianerstein 8713 (12/7/2016)

---

I only want 1 parameter value that can be obtained from the query where the parameter value = '16-17'. However I want to include logic that will also...

Can you use something like this?

IF NOT EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')

--Do stuff

dianerstein 8713 (12/7/2016)

---

In a t-sql 2012 column I have a column called test1 defines as (varchar(10),not null) in a table called tab. The values in this column look like '16-17'...

wendy elizabeth (12/7/2016)

---

In an existing sql server 2012 database, there are lots of columns defined as (bit,null). When the value is checked to be = 0, the results are returned...

paul 69259 (12/7/2016)

---

Thank you Thom,

That appears to be nearly there the only problem now is if a job doesn't have any additional drops it doesnt show the collection and...

You had the same idea as me, though STUFF is not doing much here other than removing an unwanted character;...