sqlserverDBA2016 (10/27/2016)

---

Hi guys

is it possible to retrieve queries which ran a week ago in a sql server database.

So far i'm only able to retrieve up to one day using...

Quick solution

😎

DECLARE @TXML XML = '<profile xmlns="http://schemas.clairmail.com/2008/01/Model/extensions" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<disabledState>

...

tcronin 95651 (10/26/2016)

---

Vmware host took a dive about a week ago all servers went down. Everything came back up but now Integration Services will not start (uses same account...

homebrew01 (10/26/2016)

---

I'm considering upgrading our production server from 2005, at the same time we upgrade servers. I have not kept up on the most recent versions. No specific need to...

Good stuff, just ping back here if you run into any problems

😎

groverparkgeorge (10/26/2016)

---

I apologize if this has been covered, but I couldn't find a reference that fits.

I have been asked to support an existing web site--the original developer is out of...

Worth having a look at Koen's article, Beware the defaults! (in windowing functions)[/url]

😎

mickegohle (10/26/2016)

---

Hi folks,

So, I want to encryot some columns in cetain tables in a database.

I was thinking creating a table where I specify which tables and columns to be encrypted...

Phil Parkin (10/26/2016)

---

BWFC (10/26/2016)

---

jasona.work (10/26/2016)

---

Brandie Tarvin (10/26/2016)

---

jasona.work (10/26/2016)

---

Phil Parkin (10/26/2016)

---

HanShi (10/26/2016)

---

BLOB_EATER (10/26/2016)

---

I liked Eric's response - "get...

kesavan.rv (10/26/2016)

---

Hi Friends,

All off sudden in my PROD SQL server memory was reduced to zero(As the minimum memory was set to 0).

Is there any way to find which one...

Jeff Moden (10/25/2016)

---

TryingToLearn (10/25/2016)

---

i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to...

LinksUp (10/25/2016)

---

Since you posted in a 2008 forum, here is a simple self-join using a cte that gives you your output. If you had access to 2012 or greater you...

Almost identical to LinksUp's solution, does the same thing;-)

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(ID,Client,Level,[Change Date]) AS

( SELECT ID,Client,Level,CONVERT(DATE,[Change Date],103)

FROM (VALUES

( 1,1000,2,'01/07/2016')

...

Could...

drew.allen (10/24/2016)

---

If I understand correctly, just change your ORs to ANDs in your original query. You're getting rows where ANY column does not contain any of those values, but...