Viewing 15 posts - 571 through 585 (of 5,393 total)
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...
-- Gianluca Sartori
April 22, 2015 at 4:59 am
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...
-- Gianluca Sartori
April 22, 2015 at 4:22 am
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...
-- Gianluca Sartori
April 22, 2015 at 3:20 am
I have a bit of a deja vu
-- Gianluca Sartori
April 21, 2015 at 11:25 am
April 21, 2015 at 3:33 am
spaghettidba (4/20/2015)
Maybe it works in 2008, but I don't have an instance to test.
I just found a 2008R2 and it doesn't work. Too bad.
-- Gianluca Sartori
April 20, 2015 at 9:57 am
GilaMonster (4/20/2015)
Jeff Moden (4/20/2015)
GilaMonster (4/20/2015)
The default trace does log temp table creates and drops.Awesome!
Not usually. 🙂
It's one reason why the default trace sometimes covers such a short time period....
-- Gianluca Sartori
April 20, 2015 at 9:56 am
No values will be in the column, since it's being added by the ALTER TABLE command. What do you mean exactly?
-- Gianluca Sartori
April 20, 2015 at 3:07 am
Service Broker gone wild? Check SB DMVs.
-- Gianluca Sartori
April 20, 2015 at 2:21 am
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....
-- Gianluca Sartori
April 20, 2015 at 2:17 am
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...
-- Gianluca Sartori
April 20, 2015 at 2:07 am
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...
-- Gianluca Sartori
April 20, 2015 at 2:03 am
Use "WITH VALUES" in your default specification:
alter table test add column2 int default(0) WITH VALUES
-- Gianluca Sartori
April 20, 2015 at 1:58 am
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...
-- Gianluca Sartori
April 19, 2015 at 3:21 am
Viewing 15 posts - 571 through 585 (of 5,393 total)