Setup on a cluster is a different thing from a standalone setup. You will need data disks, an IP address and a network name to add to the cluster during...

If I understand correctly, the Reporting Services instance will be in a different place from the subscribers and the data has to be read from the subscribers. Are you sure...

I'm sorry, I don't understand a couple of things and I hope you can clarify.

Where will be the data read by the reports? At the subscribers? At the publisher?

Why do...

I have a bit of a deja vu

Don't reinvent the wheel: use Jeff Moden's splitter function[/url].

I just found a 2008R2 and it doesn't work. Too bad.

GilaMonster (4/20/2015)

Not usually. 🙂

It's one reason why the default trace sometimes covers such a short time period....

Yes, confirmed.

No values will be in the column, since it's being added by the ALTER TABLE command. What do you mean exactly?

Service Broker gone wild? Check SB DMVs.

Unfortunately, the only supported HA technology for replication subscribers is clustering. All other techniques that change the server name (mirroring, log shipping, AlwaysOn AGs) are not available for replication subscribers....

It depends what you need to do. If you're checking that the ID from #t2 is lesst than all the IDs in #t1, you can use the ALL keyword.

SELECT ID...

Please post table defintions as CREATE TABLE scripts, some sample data as INSERT statements and the expected results based on the sample data. For more info on how to do...

Use "WITH VALUES" in your default specification:

alter table test add column2 int default(0) WITH VALUES

Has anyone seen the last comments for Friday's featured article? I'm sorry for provoking such a bad reaction, I didn't mean to do that.

Did I say something wrong? Was...