I missed the last few posts as I was out for a long weekend.

It looks like you got it sorted ok though.

Keep referring to this site and we'll make a...

Over the Spring Bank Holiday (Whatever happned to calling it Whitsun) I'll be out on my bike, getting muddy - probably over at Cannock Chase - but possiby somewhere more...

Gianluca Sartori (5/22/2009)

---

Hi everybody! I see that "The Thread" is now focusing on bad replies, so please let me know: was this http://www.sqlservercentral.com/Forums/FindPost721477.aspx really a bad reply? Did I...

I did some work on a dynamic pivot in a recent thread here http://www.sqlservercentral.com/Forums/Topic713483-338-1.aspx

I think you'd need to incorporate a tally table to get the missing years somehow

DECLARE @MINYR...

Again a similar method could be employed. I'm guessing you're only interested in the most recent result.

DECLARE @RESULT varchar(4000);

select @RESULT = TOP(1) Message from dbo.sysjobhistory

where step_name = 'IndexOptimize'

AND...

Hi and welcome to the forum.

Yes a cross-database union or join is possible, however you should include some kind of flag in the results so you know which DB it...

Good! 😀

I nearly suggested the OUTER JOIN, but instead I ask questions to make you think.

If you realise if yourself, the knowledge sticks better.

😉

Well what output is required if a person has no passport record, or no tax record. - Do you include them in the results - i.e. treat it the same...

In theory Simple recovery model means the transaction log should be truncated regularly - this doesn't always mean the disk space is freed up.

Try shrinking to the minimum...

FLOAT is just that FLOAT. - precise to 15 digits or something like that. You may get some oddities after calculations - such as 0.999999999999999 where you expected 1.0...

Yes the indexes will be updated as you delete the data. The way SQL server stores data in 8K pages may mean that what remains of the index is...

An empty string check is simply STRING=''

A Null check is STRING is NULL

But to check for either you can use ISNULL(STRING,'')=''

From your description something along these lines may...

I agree the hardware can hide an awful lot of bad and inefficient code. For a small business - why hire an expensive DBA, you can get a dual processor...

I don't think its possible using the Job setup wizard, however in your command area you could tweak the code, and use xp_cmdshell to output the file - you'll need...

For DB sizes, there is a sysfiles table in every database, also sp_spaceused may help

To get free disk space, take a look at xp_cmdshell in Books Online, you may be...