Not too be picky but if your requirement of the other columns is not needed than what you ask can be accomplished really easy..

SELECT ServerName FROM InstanceTypes GROUP BY ServerName

I'm...

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe the number and data...

Hi Fred,

First I want to say thanks for the dataset to work with

However

You should probably understand that you will get a lot more help if you set up the...

Has it been this way for a year? I usually go back to my customers after a year with a usage report.

basically something like this

This is what you said...

Even though you invoke the maintenance plan as another user when it goes to interface with the file system it uses the SQL Server agent account.

To do this I would...

nadersam (3/29/2016)

---

GilaMonster (3/29/2016)

---

Space used + 2 bytes.

As for make everything varchar(8000), why? Is a person's first name going to be thousands of characters long? A city name? A company name?...

I can confirm I was able to failover from a 10.50.6529 version to a 10.50.6000 (sp3) version. I wouldn't recommend keeping the difference in versions but if you make...

I didn't even realize there were two sp at work here. What I normally do is use the GUI and then script it out which is what I showed...

I should have said to add those parameters to yours in the addlinkserver so combine your parameters and the user parameters and try again.

GilaMonster (4/15/2016)

---

EamonSQL (4/14/2016)

---

Is it possible to find out which updates were made against a first, second, third etc nested transactions?

For example, if select @@trancount returns 4 can I find out...

briancampbellmcad (4/21/2016)

---

Thanks in advance... I am trying to develop a stored procedure to pull Access data into SQL Server.

I created a linked server object using:

EXEC sp_addlinkedserver

@server =...

Since I don't know anything about your environment Im going to ask several questions

1. Is the cluster heartbeat on a separate nic/vlan?

2. Is there blocking occurring on prod?

3....

The quick answer is yes.

Google-Foo to the rescue.

Index Report:

http://www.sqlservergeeks.com/sql-server-engine-estimated-time-to-complete-online-index-operations/

Long Running Processes:

https://www.mssqltips.com/sqlservertip/3176/identify-completion-time-for-long-running-sql-server-processes-using-dynamic-management-objects/

SQL Cant estimate an actual rebuild completion time so get current running time.

http://dba.stackexchange.com/questions/76375/check-progress-of-alter-index-reorganize-rebuild

Google-foo CHOP!

Replication in 2008r2 is rock solid for me in my environment and we use it just for the purpose you are looking for, a read only copy for read only...

My thought is t3.code4=1 is unique and therefore the count will never be more than the base table (t1) so I agree you can remove that left join for count...