GSquared

Forum Replies Created

Viewing 15 posts - 10,471 through 10,485 (of 14,953 total)

RE: Are the posted questions getting worse?

RBarryYoung (3/14/2009)
OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...
Yeah ... um ... wow ... that is a bit...
- 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

March 16, 2009 at 8:21 am

#960262
RE: Are the posted questions getting worse?

GilaMonster (3/14/2009)
GSquared (3/13/2009)
GilaMonster (3/13/2009)
Am I being too harsh here?
http://www.sqlservercentral.com/Forums/FindPost675279.aspx
Nope.
I've been caught with errors like that before, and you've called me out the same sort of way. I've never taken...
- 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

March 16, 2009 at 8:19 am

#960260
RE: T-Sql rant

dmbaker (3/16/2009)
Aaarrgh! Stop already! This thread is like a giant bag of potato chips -- I just can't stop reading it!
Or are we going for a record number of posts...
- 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

March 16, 2009 at 8:15 am

#960256
RE: T-Sql rant

foxjazz (3/14/2009)
I guess I just don't get why everyone here is so walled up and can't think outside the box.
Stored procedures in sql result only in one language type, not...
- 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

March 16, 2009 at 8:05 am

#960246
RE: T-Sql rant

foxjazz (3/14/2009)
Do any of you know a language other than English? Spanish, as a second or German?
Because using English is dominant, I struggle with German as a second. I can...
- 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

March 16, 2009 at 7:46 am

#960230
RE: T-Sql rant

Jeff Moden (3/14/2009)
RBarryYoung (3/14/2009)
OK, foxjazz, now I have a question for you:
foxjazz (3/14/2009)
Ok, yes I did it that way before. Except you have to do it in 4 distinct query...
- 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

March 16, 2009 at 7:33 am

#960215
RE: T-Sql rant

foxjazz (3/14/2009)
Instead of having you guys try and figure out some problem without the use of cursors, I have already made my point without realizing that I had.
Simply because cursors...
- 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

March 16, 2009 at 7:31 am

#960212
RE: T-Sql rant

foxjazz (3/13/2009)
Another point, why should someone that knows c# or vb and does it daily, have to learn t-sql.
Why can't t-sql accomadate that flavor of language just like the IDL...
- 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

March 16, 2009 at 7:13 am

#960185
RE: T-Sql rant

foxjazz (3/13/2009)
Ok here is what I would like to do:
run a query or view that gets a datatable (in t-sql) not c#
Then run through each record in the datatable that...
- 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

March 16, 2009 at 7:11 am

#960181
RE: T-Sql rant

foxjazz (3/13/2009)
cursors heh
Excatly my point.... So why doesn't t-sql accomodate sets?
Why would I need a cursor to do updates like ?
foreach(select * from table)
{
insert into othertable (field) value(myfield) ?...
- 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

March 16, 2009 at 7:09 am

#960180
RE: T-Sql rant

OO Querying... what would it look like:
Create Object qqMyQuery as Query;
qqMyQuery.addtable.Table1;
qqMyQuery.addtable.Table2;
qqMyQuery.addtable.Table3;
qqMyQuery.tables.addjoin(Type="Inner","Table1,Table2");
qqMyQuery.tables.joins.addcriteria(Table1.Col1,Table2.Col2);
And so on. Is something like that what you're looking for? Where you'd create objects based on definitions,...
- 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

March 13, 2009 at 2:27 pm

#959445
RE: How to remove space

I find the easiest way to do this in SQL is nesting NullIf and IsNull statements.
update dbo.MyTable
set Col5 =
isnull(nullif(Col1, ''), '') +
isnull(nullif(Col2, ''), '') +
isnull(nullif(Col3, ''), '') +
isnull(nullif(Col4,...
- 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

March 13, 2009 at 1:40 pm

#959420
RE: Delete historical data little by little and often, or a huge bulk more seldom?

I have to agree that partitioning is designed for this.
My biggest concern with the size of the deletes being done would be the transaction log. Too much at once...
- 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

March 13, 2009 at 12:40 pm

#959392
RE: t-sql dates

You can get the last date (and time) of a given month or week or whatever by using Max and Group By.
select max(Date)
from dbo.MyTable
group by datepart(year, Date), datepart(month, Date);
That'll give...
- 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

March 13, 2009 at 12:34 pm

#959389
RE: Just had an interview for a DBA in CT

Amit Lohia (3/12/2009)
Just a friendly advice (feel free to ignore it). Most of us do this for living and 6 years of experience does not mean you cannot make 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

March 13, 2009 at 12:30 pm

#959387

Viewing 15 posts - 10,471 through 10,485 (of 14,953 total)