Forum Replies Created
Viewing 15 posts - 7,156 through 7,170 (of 14,953 total)
-
RE: Is it possible to specify SQL Server Instance Number
I don't believe that's something you can control directly. Could be mistaken, but I don't think so.
- 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
-
RE: COALESCE Problem
Interesting. I saw the exact same problem on this site, by another person, just a few months ago.
Different wording for the explanation, but the exact same rules.
Is this 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
-
RE: The IT Explosion
I have to agree with the earlier post that this isn't limited to IT by any means.
I've known too many burned out salespeople, accountants, managers, etc., to think it applies...
- 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
-
RE: Generating Unique Name
Run each one a million times, or least a few thousand, and see which takes less time. A lot of that will depend on environment it's running in.
- 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
-
RE: We'll go no more a' tibbling
James Goodwin (1/26/2010)
You want to search through your code to find out all the places that reference this table to check for possible problems before you make the structural change
I...
- 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
-
RE: Are the posted questions getting worse?
jcrawf02 (1/25/2010)
So since cloud computing is the answer, do you (anyone, not just Gus) agree with this statement?Clouds push complexity to the background and allow users to focus on what...
- 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
-
RE: Generating Unique Name
If you have a Numbers table, you could do this:
;with Names (Name, Number) as(select @UserName as Name, 0
union all
select @NewName + cast(Number as varchar(10)), Number
from dbo.Numbers
where Number > 0),
Name (Name)...
- 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
-
RE: How does Management Studio Know Job Owner?
Have you looked in sys.server_principals and sys.sql_logins?
- 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
-
RE: We'll go no more a' tibbling
Someone mentioned the idea of prefixing with the company name. I've seen that, and it's a pain to deal with.
At my last job, every database started with an abbreviation...
- 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
-
RE: Urgent development question
GilaMonster (1/25/2010)
Greg Edwards-268690 (1/25/2010)
Just a thought...If this is development, you may want to review the design.
Absolutely. Comma-delimited lists in a column are a violation of 1st Normal Form 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
-
RE: Are the posted questions getting worse?
GilaMonster (1/25/2010)
Think I've found the crystal ball... Doesn't seem to be showing much though.Actually, it seems to be saying the answer is cloud computing...
- 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
-
RE: We'll go no more a' tibbling
Grant Fritchey (1/25/2010)
I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning 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
-
RE: Are the posted questions getting worse?
Steve Jones - Editor (1/25/2010)
Looks like The Thread is alive and well. Good to be back and hoping everyone behaved over the last week.Well, we always "behave", it's just how...
- 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
-
RE: We'll go no more a' tibbling
I dislike prefixing database objects.
I'm with the "you can't exec a table, so why does the name need to say so?" camp.
I've replaced tables with views (for backwards compatibility), much...
- 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
-
RE: SQL Scripts - How to run and get results
CirquedeSQLeil (1/22/2010)
GSquared (1/22/2010)
There's a report you can get on schema changes. Deleting a table is a schema change.Right-click on the database in Management Studio, and select Reports, then select...
- 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
Viewing 15 posts - 7,156 through 7,170 (of 14,953 total)