Same for me. Not only that but depending on exactly WHEN you run this you may well be different seconds, given that getdate() etc will be called in 4...

sweet 🙂

Try looking in here: http://technet.microsoft.com/en-gb/library/cc966413.aspx

Looks like a handy whitepaper "SQL Server 2005 Waits and Queues SQL Server Best Practices Article"

Great question - anyone got any info beyond BOL?

eg: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/568d89ed-2c96-4795-8a0c-2f3e375081da.htm

Hi Dirk

Not knowing the details, I would really want to ask why you think that is what you want to do.

Without you knowing it, you are probably in a fortunate...

Model is the "model" for all user created databases. Stick anything in it - users, procs,tables etc and they will appear in all subsequent databases you create. Presumably if...

haha, someone should submit that to the daily wtf... :hehe:

I guess its because people tend to evaluate 'true' things first, especially in IF clauses.

What we have here is a double negative, which requires more consideration and work through than

if...

As long as it's not you getting canned when it goes wrong... Let the sysadmins carry it. That way when they get binned, you can negotiate a nice little...

Tricksy tricksy.

Good question, good follow up.

Learned something new today.

ta

Is your grouping sets example not just a rework of rollup?

Is the power of this not in the way it can handle non hierarchical (ie group by col1, col2, col3...

GilaMonster (6/22/2009)

Oh, right, the database diagrams table. I believe to get rid of those you need to filter using ObjectProperty with the IsMSShipped property. I...

and the ever irritating dtproperties.

Which is fine, as long as you remember that it also includes the occasional system table.

How about the futute though? Do many of you picture yourselves as DBA's in another 10/20 years time?

Got to be honest, not sure that gets me excited!...