I am sorry,

I trusted Pinal Dave on this one, without crosschecking MS:

http://blog.sqlauthority.com/2011/02/15/sql-server-lck_m_xxx-wait-type-day-15-of-28/

who wrote

"LCK_M_SCH_S - Occurs when a task is waiting to acquire a Schema Share lock."

an...

I am also delighted, thanks a lot!

here a little correction

'LOCK - Waiting to acquire a Schema Modify lock' WHERE dbo.[#results].[wait_type] = 'LCK_M_SCH_S'

... should be Share.

Hi there,

BULK INSERT works fine, see the details here: http://msdn.microsoft.com/en-us/library/ms188365.aspx

To split the strings, you can help yourself with a temporary table.

What confused me as a newbie was the file path:

"

data_file...

Thank you all for your response,

I still like paper-based media, but maybe I am also too old-fashioned.

sqlmag is good, but covers only SQL Server, the best site I found so...

I can understand your little confusion: in SQL Server Management Studio the PK is listed in the folder "Indexes" and not in "Constraints".

The reason is, that is is more than...

Thank You very much for your effort,

I am sorry, but we had to restart the server now for another reason (not me ^^),

so I can't check the parameters anymore.

But: "I'll...

Hi,

thanks for caring, at first I just wanted to rant, because it's simply annoying:

the ARE situations, databases and data out there, where freeing space quickly is more important than having...

It its really annoying, how the log shrinking is solved in SQL Server 2008.

Sometimes the is simply a need to quickly shink the log file without being able to kick...

Hi,

what exactly is not working?

Thanks a lot,

a SQL variant would be nice, but I am also happy, that I can use PowerShell for a serious task 🙂

It's

EXEC GetData 't1', 'name'

GO

... without parentheses.

Just FMI:

has anyone of you ever used global temp tables?

I definitely didn't^^

Hi,

maybe it has to do with Filtered index limitations?

https://connect.microsoft.com/SQLServer/feedback/details/341891

Maybe always set the Dateformat explicitly:

SET DATEFORMAT MDY

declare @tbl table(stdate datetime)

insert @tbl select '12-31-2011'

SET DATEFORMAT YDM

declare @date datetime

set @date = '2011-31-12'

select * from @tbl where stdate = @date

I will have a close look at it,

Thanks a lot!