Hey,

This should only takes a few seconds, as primarily adding a reference in the master database about file locations and database name.

Thanks,

Phillip Cox

MCITP - Database Administrator|MCTS - SQL Server 2005|MCP...

magarity kerns (3/20/2008)

---

I had this exact same situation when I started a job just a couple of years ago! There was a Dell 220 array with 7 disks all...

Ok, this changes things a bit, as you are constrained to limited disks. you can...

Hi Jason,

Sorry, ok. You have a PowerEdge 2900 with all internal storage and you can fit a maximum of 10 disks into the server. You want to chop-up...

Jason Marshall (3/20/2008)

---

Thanks for your responses, everyone.

We're constrained by the total number of physical drives we have available (10). Using RAID 1 for OS/apps and Tempdb/logs gives me six...

Jason Marshall (3/19/2008)

---

Good morning-

I am going to rearrange the HDD configuration in our Production server; currently everything (logs, data, tempdb) is on one RAID 5 array, which is suboptimal. ...

evgkushnir (3/20/2008)

---

Hi every one.

I have a problem.

I have SQL Server 2005 Standart Editon x86.

Memory: 8 GB

CPU: 8

It's a...

bimpe_d (3/7/2008)

---

thanks all,

after i executed the block of code (Phillip's) and refreshed my connection, i could open the properties of SQLSERVERAGENT, which prior to now had been greyed out(disabled).

As i...

MANJUG05 (3/14/2008)

---

HI

WE HAVE TWO DATABASES AT OUR WORK PLACE. BOTH ARE SQL 2000. ONE OF THEM IS SHOWING SUSPECT IN SYSTEM TRAY. CAN ANY OF YOU TELL ME HOW TO...

Hi,

This sounds like an awesome idea and as suggested by author, it would help lower the operational costing aspects of doing backups, thus a "green" idea. The only draw-back...

peer_mohamed2k (3/14/2008)

---

Hi,

I have 1,65,00,000 rows [16 million rows] in one table. I am using this table for SQL reports. When I use this table joining with some other tables, my...

Hi,

As long as you are only utilizing a single node in an active-passive configuration, you only require 1 license. If you ever decided to change to an active-active configuration,...

Hey,

Just adding to GSquared's points, you wouldn't want to initilize the same file everyday, as this zero outs last backup contents. I would recommend you consider using file backups...

Matt Miller (3/12/2008)

---

I know I'm showing late to the party - but is there any chance to make that a covering index? Assuming those extra fields aren't ludicrously long...

Ronnie.Doggart (3/12/2008)

---

Philip,

xref1 is varchar(80).

[font="Courier New"]

SELECT * FROM LGNCC_ENQUIRY WITH (INDEX(lgncc_enquiry_t2))

WHERE xref1 = '1001183168' AND

objecttype = 'D4'

(971 row(s) affected)

Table 'LGNCC_ENQUIRY'. Scan count 1, logical reads 3058,...