Jeff Moden (12/19/2011)

---

There are a couple of proper uses, IMHO...

1. Control. If a system has been reasonably well locked down for privs, views are exceptional for controlling which...

It might be useful.

FIX: Error message when you install SQL Server 2008 on a computer that is running Windows 7: "Invoke or BeginInvoke cannot be called on a control until...

Per BOL:

{ EXPIREDATE = 'date'| RETAINDAYS = days }

Specifies when the backup set for this backup can be overwritten.

It should not be any issue until you are referring columns by their order number in reports. All the Front End Languages support column mapping between record set & resultset

It’s...

Why so? What’s the harm in adding it in last position? You can...

lance.a.williams (12/18/2011)

---

Thank you for the reply. If I provided STAR schema data marts for each business domain and BI tools that connected direct to the datamart for reporting...

lance.a.williams (12/18/2011)

---

Dev (12/17/2011)

---

The main advantage with cube is they can serve as offline storage. So if you lose the connection to your data server, you would still be...

GilaMonster (12/19/2011)

---

Dev (12/19/2011)

---

GilaMonster (12/19/2011)

---

If you're going to quote someone else's work (in this case...

L' Eomot Inversé (12/18/2011)

---

Revenant (12/17/2011)

---

I have started on 2 September 1970, on an IBM 360/40 installation that was pride of the town: 128k of memory, 8 tape drives, and 8...

GilaMonster (12/19/2011)

---

If you're going to quote someone else's work (in this case Books Online), the correct...

Koen Verbeeck (12/15/2011)

---

Dev (12/15/2011)

---

I don’t think there are organizations (even the giants) which employ BI DBAs or HA DBAs. If you are a PROD DBA, you are assumed...

:w00t: Posted Thursday, November 05, 2009 9:39 PM

ns22boss (12/16/2011)

---

Hi gsquared,

My question is I am reading the excel name from the user and according to that excel, i need to generate DB Table with same number of columns...

If you opt for ‘High Safety’ mode of Mirroring, your Primary Server will perform slowly (because of low bandwidth). I don’t feel you will get any significant advantage in ‘High...

It might be a restored database (with encryption) or Master Key might have already been generated by someone outside your knowledge. You can generate it again by forcing but it...