Seeing the OPs affinity towards linked servers I would like to say that being a DBA you should always justify the use of linked servers. They are there to query...

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Divine Flame (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

You could use merge replication to ensure that the same data goes to all three servers, regardless of which one inputs the data. But...

Grant Fritchey (4/26/2012)

---

You could use merge replication to ensure that the same data goes to all three servers, regardless of which one inputs the data. But that requires changes to...

Below script should do the work for you:

IF EXISTS (SELECT 1 FROM TEMPDB..SYSOBJECTS WHERE NAME LIKE '%#TableSize%')

BEGIN

DROP TABLE #TableSize

END

GO

CREATE TABLE #TableSize

(

name sysname,

[rows] INT,

reserved VARCHAR (200),

data VARCHAR (200),

index_size VARCHAR (200),

unused...

vinu512 (4/25/2012)

---

I am not sure about either of these because both of them have performance limitations.

Can Tally Tables be used in this scenario??

I'm looking to throw away Cursors and Loops...

Thanks a lot perry, got it 🙂

Perry Whittle (4/10/2012)

---

So, if you have a public network connection with IP 192.168.1.30 and a secondary backup network with IP 10.10.10.30 and you copy backups to the backup server whose...

Hi Perry,

Right now I am looking for the possibilities of copying...

Grant Fritchey (4/5/2012)

---

That's a very large topic. I have one chapter of my performance tuning book focused on the important metrics you need to collect. I really don't want to...

GilaMonster (4/3/2012)

---

Divine Flame (4/3/2012)

---

Do we have the...

Do we have the option to get...

bala2 (4/2/2012)

---

Can any one help to create a script to find out sql server health check i.e (We want to create automated SP to find

the Sql server...

halifaxdal (4/3/2012)

---

No, I am serious. I end up creating a new one because I don't believe it either and I don't want to spend time to investigate it. I am...

halifaxdal (4/2/2012)

---

Can't believe this happened to me:

On Mar 26, I can still see the maintenance plan, I even created a screenshot for my document. The plan is scheduled to run...

Jeff Moden (3/24/2012)

---

Divine Flame (3/23/2012)

---

TheSQLGuru (3/23/2012)

---

I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad...