Viewing 15 posts - 10,801 through 10,815 (of 14,953 total)
Okay, if we're going with the "binary million", then it's actually 1024 squared, which would be 1048576. That's the old "binary meg", as opposed to "decimal meg".
Hard...
February 24, 2009 at 8:00 am
Something like this would do it very, very efficiently. Too bad you don't like joins. (Refusing to use Joins in SQL is kind of like refusing to use...
February 24, 2009 at 7:56 am
You could build something using the sys.foreign_key_columns system view. Not sure why you wouldn't want to use Joins.
February 24, 2009 at 7:48 am
Without having the actual table names, this is about the closest I can get on this:
select
Date,
Material_Name + '\' + Material_Type as [Material_Name\Material_Type],
Table1.Consumer,
case [Day]
when 'Day' then 'Day'
else 'N/A'
end as...
February 24, 2009 at 7:41 am
I do semi-random spot checks. I restore one or two backups a week to test them, picking different databases different times. I've never yet had one fail, but...
February 24, 2009 at 7:20 am
Test your queries, use "set statistics time on" and "set statistics io on", and see which index works best for you.
February 24, 2009 at 6:47 am
Ender's Game was good, but I didn't like the follow-ups.
On "light fantasy", it just doesn't get better than the Diskworld books.
February 23, 2009 at 2:22 pm
Looks to me like you could wrap all of that in a cursor that would step through the databases one by one.
February 23, 2009 at 12:56 pm
You could find that from the log files, if you can get a parser. Another way to get it might be a server trace.
February 23, 2009 at 12:53 pm
GilaMonster (2/23/2009)
Steve Jones - Editor (2/23/2009)
Gail, I smell a business opportunity in SA...
Not with the bandwidth the way it is. What I have is towards the top end of what's...
February 23, 2009 at 12:51 pm
Bruce W Cassidy (2/23/2009)
[font="Verdana"]Firefly/Serenity. sigh
Definitely awesome.
February 23, 2009 at 12:46 pm
GilaMonster (2/23/2009)
GSquared (2/23/2009)
I'd go with renting, if that's an option for you.
I haven't seen it in any of the local video stores. I'll check around when I have...
February 23, 2009 at 12:45 pm
GilaMonster (2/23/2009)
Bob Hovious (2/23/2009)
With BattleStar Galactica going going gone.
Is Galactica worth buying on DVD? (for a Startrek, Starwars, Babylon 5 fan)
It never showed on any of the local stations...
February 23, 2009 at 12:06 pm
Bob Hovious (2/23/2009)
The movie(s) sucked, there wasn't even any powered armor!!
I wish the sci-fi channel would do a...
February 23, 2009 at 11:57 am
GilaMonster (2/23/2009)
GSquared (2/23/2009)
February 23, 2009 at 11:51 am
Viewing 15 posts - 10,801 through 10,815 (of 14,953 total)