Brandon Forest (1/15/2014)

---

Nadrek, suffice it to say that I have good business reasons to recover the original password. I've been a SQL DBA for 15 years and a IT...

To complete what Grant said, if you do a restore of a backup and get no errors all is ok.

Nice way to get your feet wet with getting a CLR to work.

Just a few comments:

On my W7 system, the location of sn.exe is not in the path. Thus I...

I really like this distinction between push and pull when it comes to backup processes.

I gues it's also important that you don't do both on the same machine, i.e. machines...

Just out of curiosity, what have you got in that 3TB database?

Somewhere on this forum I saw an invitation by someone to all who have huge databases and talk about...

Philip,

Although I meticulously always do

Set myObject = Nothing

at the end of vb scripts, I have never seen this error message you mentioned (on those rare occassions when I forgot).

So how...

Steve,

It is mentioned at

http://www.sqlservercentral.com/Forums/Topic793765-145-1.aspx

It uses CTE with delete. Very neat.

create table t(a varchar(1))

insert into t values('b')

insert into t values('a')

insert into t values('b')

insert into t values('a')

with

dup as

(

select...

Steve,

I like very much your comment near the end "...no matter whether they used old knowledge or acquired new proficiency on the spot." Having a job where these two are...

Some time ago two gap problems where published at

http://beyondrelational.com/puzzles/tsql/default.aspx

under puzzles 79 and 80.

I recently also read about 'Static Relational Interval Tree' at

http://www.solidq.com/sqj/Pages/Home.aspx

which at some point talks about how to deal...

Ooops, just realized this is an old discussion...

Browsing around on his home page, it looks like he lives in Arizona.

So we (in Europe?) need to give him time to wake up. :hehe:

I honestly don't understand what you are trying to achieve. Please explain yourself a little better using the sample code below. It does not produce the output you are showing....

Thumbs up for PasswordSafe.

I'm living with it for some 5 years now.

Couldn't live without it!

I would be curious to see some samples of those propietary query languages with steep learning curves.;-)

Speaking of formatting code, I have a colleague who gets very confused when he has to format his code.

The most amazing example I ran into recently was in the use...