bala2 (3/27/2014)

---

Hi,

Need a help in Migrating a database of 100 GB from DB2 to Sql server.

Client would extract the data from DB2 into a delimited file and then we need...

The reorg was ran with whatever fill factor the indexes had which vary per index. This is a vendor created database so I'd rather not modify them.

Also I can...

New Born DBA (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

Also, I forgot to mention in my above post, in the future you should think about putting your log and data files on separate drives. Both...

New Born DBA (3/28/2014)

---

I think we are a little bit stingy when it comes down to giving extra space to the log file. Lesson learned.

1 more question. When the log...

vigneshkumart50 (3/28/2014)

---

Hi,

select '$ '+ CONVERT(varchar,CONVERT(decimal(10,0),CONVERT(money, Amt_Value)),1) as [Amount]

from Products

How can I sum this column values and need to set a validation like the column has null values it has...

One thing that I've found that'll prevent the Logs from truncating is a hung process. Run DBCC OPENTRAN to see if there are any processes active, because if one...

This may be an irregular way of doing it, but here's my process for restoring all of our databases from backup in DR. This is assuming the Log and...

Thanks Solomon. Arg, I just noticed this went under the SQL Server 2005 section... so glad you saw it 🙂 If a Moderator see's this and doesn't mind moving...

You didn't give much to work with, but here's an example of how I'd do this given your dimTime table is similar to ones I usually use. Also I'm...

george sibbald (12/30/2013)

---

if you use truncateonly the shrinkfile will not attempt to move any pages around so no fragmentation will be caused in this case.

Therefore this is safe to do...

Issue solved, it was the firewall on the workstation. When that was disabled the Instance loaded fine.

Thanks.

tripleAxe (12/19/2013)

---

I've had this happen in the past, it turned out to be a firewall change made by the network team. I can't recall the exact details but this...

Greg Edwards-268690 (12/9/2013)

---

SQL Server runs MSSQL Service, and needs to be registered to the machine and service.

Reporting Services runs HTTP service on a machine.

Unsure from your description if these are...

Elliott Whitlow (12/12/2013)

---

Deprecated yes, unavailable NO, you can still get to the configuration. In the properties of the package there is a line labeled Configuration and an ellipsis to...

Hi everyone,

Sorry for the late reply... SSRS is working without issue, and I can connect to the Report Server via the DNS Alias (http://[DNS Alias]/ReportManager for example)...