I just thought the easy Q & high points was an attempt to improve everyone's Monday morning 🙂

Can we do this every week?!

No problem.

As you're querying MySQL, try this:

Select create_time

From ticket_history

WHERE create_time >= @BeginningDate

and create_time < DATE_ADD(@BeginningDate, INTERVAL 1 DAY)

Thanks.

If the values in create_time contain a non-midnight time portion you won't get any matches, e.g.

create_time 07/31/2014 17:13:00 does not match 07/31/2014 00:00:00 which you'll get from the date...

Ok, that's fixed the syntax error.

What are the datatypes of the create_time field and the @BeginningDate variable, and what value of @BeginningDate are you using?

Thanks

Hi,

Think this is what you're after? If not, please give us more detail on what's not working, e.g. any errors you receive, or incorrect results.

Select create_time

From ticket_history

where create_time = @BeginningDate

Note...

Markus (7/31/2014)

Yes. I've never seen anything like this before. It does...

Hi,

Is this kind of setup possible on one server?

Yes, you can have multiple subscribers per publication

If yes then at the time of reinitialization is it going to apply the snapshot...

Mirroring is deprecated as most/all of it's features are superceded by AlwaysOn Availability Groups in SQL 2012+

It's still present in SQL 2012 & 2014. Haven't done it myself but should...

Steve Jones - SSC Editor (7/28/2014)

Koen Verbeeck (7/28/2014)

Very interesting.

I hope we've avoided some of that, though...

Koen Verbeeck (7/29/2014)

Lynn Pettis (7/28/2014)

dwain.c (7/28/2014)

Easy for you to say. I...

No problem.

It's not made clear, but it is on the MSDN page for CREATE INDEX http://msdn.microsoft.com/en-gb/library/ms188783(v=sql.105).aspx

The important lines are below, note in the filter_predicate part only AND is allowed, not...

You can't use OR in the where clause of a filtered index.

The non-filtered one is ignored as having VehReg in the index key isn't helpful to that query.

An indexed view...

No problem, and good luck!

Have you used Reporting Services Configuration Manager to point at the newly restored databases?

That should trigger the databases being automatically upgraded which it doesn't sound has happened yet.

Hi John, and welcome.

Shrinking files can indeed create fragmented indexes. I'd only recommend it if you're deleting a load of data, AND you know the newly shrunken database files won't...