Sure,

you can query sys.syslogins and if there are any windows logins on the SQL Server they'll be returned from such a query.  But, this won't tell you the windows login...

If you're logged in using SQL Authentication then there is no Windows login name to retrieve.  So unfortunately there's no way to get this back.

SQL Server will always attempt to get data as quickly as possible so if it's available in the buffer cache it will get it from there.  So when you perform...

Yep,

I can confirm that this works as described.  In fact, I just created just one data file on a flash disk and removed the disk.

Data integrity is maintained because the...

Hi Manu,

You monitor blocking in various ways.  I'd start with looking at sp_who2 and sp_lock - check them out in BOL.  I'd also read up on locking and blocking in...

I'd talk to your DBAs and ask them the very same questions you're asking here.  That should typically come under their responsibility (I would say).

If you don't have rights to...

Hi,

The reason you're getting the error is simply because heavy transactional use on the tempdb database is causing the log to grow rapidly and it is either hitting the size...

You could use INSTEAD OF triggers which occur before the action rather than after.  Having said that I'm not sure that there is a "best practice" that says a trigger...

That looks like it will work.  Of course, you want to avoid cursors where possible

Hi,

Assuming that the first characters found in the address field are the house #s then you could do something like this.

--find addresses with repeating house #s

select

Hi,

Unfortunately this is the problem you get when using distinct - the generated resultset needs to be examined for duplicates in order satisfy the DISTINCT clause.  It's a bit difficult...

Hi Ram,

the process you use is the same whether you use SQL 2005 or 2000.

a) Your best bet is to restore the full database backup onto another database (and server...

Hi Winston,

I think you're confusing transaction log files with transaction log backup files.  Typically log backup files are given the extension .trn - although there is no hard and fast...

Hi El,

go to Tools > Options.  And then expand Text Editor, followed by All Languages and click on General.  There's a Line Numbers check box on the right hand pane...

Hi,

The syntax error occurs because you need to put brackets around the select statement that generates the value.  Like this,

exec ('update temp_data set month1_amount = (select '

       + @temp +...