or

where d.state_desc = 'ONLINE'

🙂

Mmm, just one category then.

Categorisation can help if you must relate to many less well known people, but it's important to realise that one person will fit into many categories. Trying to fit a...

Or perhaps simpler:

select

db_name= d.name,

filename= f.name,

file_location= f.physical_name

from sys.master_filesf

join sys.databasesd on d.database_id = f.database_id

🙂

Dotted lines represent the triumph of pragmatism over purism.

I loved it when I was a contractor - I was brought in to do a job, I did that job...

Vocational training would be good - the trainees would be more sought after in the jobs market.

But... and it's a big but... the courses must be up to date...

No criticism of the article, but I would argue that the only way to verify a backup properly is to restore it fully and perform the usual checks on the...

For 'select count(*) from

' the 2008 optimiser will...

wouldn't

declare @result varchar(max);

select @result = coalesce(@result + ',' + value,value) from @codes;

select @result;

be a lot simpler?

Agreed, you just need the ability...

feersum_endjinn (10/14/2010)

---

3) At what age do you think someone should consider being a manger? How long do you think someone should work as a techie before they can consider...

Given that you are the boss, you say who does the work, so if you like you can be the person who does the work. Best of both worlds 🙂

Are the login events originating from sql server or from Windows/Active Directory?

Slightly away from your question... you could also write a stored proc that is executed at startup (exec sp_configure 'scan for startup procs', '1' and exec sys.sp_procoption '<sp name>','startup','on') that...

I imagine Ashish means it depends how many updates have been...