GSquared

Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 14,953 total)

RE: Going Solo

Steve Jones - SSC Editor (2/21/2012)
You don't know enough independents. I can name 10 off the top of my head that are the sole wage-earner for their household, and easily...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 21, 2012 at 12:55 pm

#1449928
RE: Are the posted questions getting worse?

jcrawf02 (2/21/2012)
Not sure exactly how well this would work, but what if your virtual machine was on your phone?
http://arstechnica.com/gadgets/news/2012/02/ubuntu-for-android-canonical-brings-ubuntu-desktop-to-docked-smartphones.ars?utm_source=rss&utm_medium=rss&utm_campaign=rss
they are so close...now we just need a HUD that runs on...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 21, 2012 at 12:28 pm

#1449915
RE: Can I get three examples of ETL?

carmellabanker (2/21/2012)
...QUESTION 2 is: I've yet to grasp where the T part will come into play. Thus far I've been pulling the information that represents logical entities in one system...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 21, 2012 at 6:27 am

#1449662
RE: One thing I keep missing in SQL

SQLKnowItAll (2/20/2012)
the set {1, 1, 2} = set {1, 2}, because the repeating "1" is the same as a single "1".
Eh... Kind of? That is if the elements of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 1:14 pm

#1449387
RE: Questions when database is Read Committed Snapshot and transaction isolation levels of Read Committed or Serializable are used

Brian.cs (2/20/2012)
Ok, my poking around on this topic was due to some behavior I was seeing in our database, and thankfully we've now also found the root cause of it....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 1:09 pm

#1449383
RE: One thing I keep missing in SQL

On the point of a row, or even multiple rows, materializing "all at once", of course it doesn't actually work that way, since CPUs don't work that way (the process...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 10:51 am

#1449341
RE: One thing I keep missing in SQL

SQLKnowItAll (2/20/2012)
SQL Kiwi (2/20/2012)
SQLKnowItAll (2/20/2012)
Why is your first example not a set? A set is simply "A group or collection of things that belong together or resemble one another or...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 10:48 am

#1449339
RE: Stored Procedure Help

Are you using SQL 2008 (as per the forum you posted in), or an earlier version?
If 2008, then there's a Time datatype that you should use instead of DateTime, and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 10:40 am

#1449333
RE: Execute Stored Procedure when value in a field is updated

That's called a "trigger". Look at "create trigger" on MSDN or in Books Online. They're pretty easy, if you know how to write stored procedures.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 10:39 am

#1449332
RE: Too Tired to Work Smart

IowaTechBear (2/17/2012)
Ah, people, I think we are getting content drift going on here. :ermm:
Both religion (Apple vs Microsoft) and politics (jobs, political party references, ...) have started taking over...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 6:56 am

#1449233
RE: Creating a Trigger

Break the tables up a bit more (normalize them).
You should have a table of vendors, a table of categories, and a table of items per category. Then, if a...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 6:43 am

#1449226
RE: Upgrading Your Career

Brent, by way of possible appology, I discovered that Travis has a tendency to annoy/offend people, based on participation in other threads. I may have overdone my reactions to...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 6:40 am

#1449224
RE: Upgrading Your Career

Robert Davis (2/17/2012)
I was thinking more along the lines of someone with certifications but not a lot of experience. Someone with a lot of experience and no certifications would also...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 6:39 am

#1449222
RE: Can I get three examples of ETL?

PaulB-TheOneAndOnly (2/17/2012)
GSquared (2/17/2012)
PaulB-TheOneAndOnly (2/17/2012)
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 6:30 am

#1449218
RE: Questions when database is Read Committed Snapshot and transaction isolation levels of Read Committed or Serializable are used

Brian.cs (2/17/2012)
GSquared, so in your understanding specifying transaction isolation level of Serializable when the database is Read Committed Snapshot and the application is expecting Read Committed Snapshot would almost certainly...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

February 20, 2012 at 6:29 am

#1449217

Viewing 15 posts - 1,951 through 1,965 (of 14,953 total)