Jeff Moden (6/30/2009)

---

That's exactly the reason why I want to know...

GilaMonster (6/29/2009)

---

Chris Harshman (6/29/2009)

---

No offense to anyone intended, but to me the title of this editorial was misleading. Disaster Recovery is a concept bigger than just having proper backup/recovery...

Be sure that the linked table you have set up in access knows there is a "primary key" /clustered index on the SQL table. If it doesn't know how...

or, global variables, a settings XML file....lots of possibilities....

(cynicism alert)

....seems awfully interesting that was the very first post from the OP....

(/cynicism alert)

Sounds to me like you are going to need to set up the assembly as unsafe. I don't believe you can access those libraries without it.

I don't know about too complicated....

drop table #formulaTableshort

drop table #formulaTable

create table #formulaTableshort(formula varchar(100))

declare @formula varchar(100)

declare @sql nvarchar(max)

declare @result decimal(9,2)

--test data

insert into #formulaTableshort

(formula)

select '3 * (2 + 4)'

insert into #formulaTableshort

(formula)

select '7...

Only as often as is required to maintain performance. Anything more is essentially using additional resources, which might be fine if you can spare them, but certainly not necessary.

Some...

jeffrey yao (6/22/2009)

---

John Rowan (6/22/2009)

---

How can you say that you were a full time data modeler for more than a year and that you think normalization is theoretical nonsense? ...

Jeff Moden (6/22/2009)

---

Brandie Tarvin (6/22/2009)

---

"Why, no, Sir. We don't be needin' no real-ational database type tool. Just gimmie Lotus 1-2-3 or that thar x-el spreadsheet and I kin give you...

remember however that you need SA privileges to execute xp_logevent, so the mechanism isn't exactly wide open to "editing the logs". Essentially - those who have the access to...

I like your questions Grant. I usually just add in one more, it's actually usually my first (fail is and it's time to call it quits).

"What is normalization and...

Actually - this sounds suspiciously like some of the stuff the new DMW could do. (where DMW = 2008's version of SqlH2).

Granted - both versions the Data Management warehouse...

The recovery model doesn't change unless a script that specifically changes it.

I remember hearing about some performance/monitoring tool doing that in the past if the monitoring was being logged to...

I wouldn't be quite so optimistic. If the inserts being done look something like

insert tableA

select * from TableB

(i.e with no specific names on the destination), altering that table could...