Viewing 15 posts - 7,261 through 7,275 (of 7,608 total)
Make sure the statistics on all tables are up to date -- obsolete statistics could cause SQL to choose the wrong type of join.
Of course SQL sometimes chooses the wrong...
August 24, 2012 at 10:39 am
You should be fine with a single table provided you cluster the table by:
( [Time], MnemonicId ) --if I understand Mnemonic id correctly, as the original telemetry data src
Uniqueidentifiers are...
August 20, 2012 at 9:23 am
CREATE VIEW permission denied in database 'MWC2'
Looks to me like there is an explicit DENY of CREATE VIEW permissions somewhere.
DENY will override/"cancel" an equivalent GRANT.
August 20, 2012 at 9:19 am
Kenneth.Fisher (8/20/2012)
August 20, 2012 at 9:06 am
It should be, it's a temporary work db, just like tempdb :-).
August 20, 2012 at 8:47 am
You don't need to take a log backup if the db is in simple recovery model -- indeed, you can't: SQL doesn't allow a log backup to occur while the...
August 20, 2012 at 8:27 am
Since their current log drive is full, they are in a tough situation.
Without a DBA there, to me the safest thing to shrink is a temp db.
It could try to...
August 17, 2012 at 1:26 pm
mr.neil.bryan (8/17/2012)
Would shrinking this database file resolve our issue?
Possibly.
Since it is the Reporting temp db, if you have a lot of free space in it, I would go...
August 17, 2012 at 12:43 pm
GSquared (8/2/2012)
Don't assume that your opinion, unbacked by data, is going to convince people of anything. Repeatedly asserting "Erwin>Visio" without any sort of analysis at all...
August 2, 2012 at 8:45 am
Stefan Krzywicki (8/1/2012)
You still haven't defined what you consider a complete modeling tool. Or what it requires beyond the "very nice pictures" you mention.
Yes, I did. To repeat, separate...
August 1, 2012 at 1:03 pm
GSquared (8/1/2012)
ScottPletcher (8/1/2012)
Stefan Krzywicki (8/1/2012)
ScottPletcher (8/1/2012)
Stefan Krzywicki (8/1/2012)
So what does Erwin do that Visio doesn't?
I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling),...
August 1, 2012 at 12:11 pm
Stefan Krzywicki (8/1/2012)
ScottPletcher (8/1/2012)
Stefan Krzywicki (8/1/2012)
So what does Erwin do that Visio doesn't?
I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I thought...
August 1, 2012 at 9:40 am
Stefan Krzywicki (8/1/2012)
So what does Erwin do that Visio doesn't?
I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I thought it was all...
August 1, 2012 at 9:28 am
GSquared (8/1/2012)
ScottPletcher (7/31/2012)
Stefan Krzywicki (7/31/2012)
When I had the choice between Erwin & Visio, I chose Visio.
Wow. You must not be a DBA or a data modeler 🙂 .
I agree...
August 1, 2012 at 8:33 am
Stefan Krzywicki (7/31/2012)
When I had the choice between Erwin & Visio, I chose Visio.
Wow. You must not be a DBA or a data modeler 🙂 .
July 31, 2012 at 2:01 pm
Viewing 15 posts - 7,261 through 7,275 (of 7,608 total)