Viewing 15 posts - 301 through 315 (of 14,953 total)
I'd have to run some tests to say definitively whether indexes would help or not, but I can say I've seen similar systems and indexes weren't needed there.
So, probably you're...
- 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
December 19, 2012 at 6:10 am
Sometimes it takes seeing it all put together in order to understand the pieces.
Glad we could help.
- 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
December 19, 2012 at 6:08 am
By the way, if anyone is still interested: http://www.smh.com.au/world/myersbriggs-test-not-all-psychologists-type-20121217-2bigg.html
Per this article:
Even Katharine Downing Myers concedes that "psychologists had no use for the indicator; they felt that Jung was a crazy...
- 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
December 18, 2012 at 5:14 pm
Evil Kraig F (12/18/2012)
GSquared (12/18/2012)
A good book runs about $8 on average these days, and also lasts about 2 hours, so I could use that in the same way.
2 hours?...
- 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
December 18, 2012 at 2:55 pm
patrickmcginnis59 (12/18/2012)
GSquared (12/18/2012)
patrickmcginnis59 (12/18/2012)
- 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
December 18, 2012 at 2:49 pm
Your modification to end-of-month looks like it won't work correctly in all cases. Try a March date in there, see what you get.
- 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
December 18, 2012 at 2:46 pm
You could try something other than SSMS.
ApexSQL Edit (http://www.apexsql.com/sql_tools_edit.aspx) might be an option. I don't know if it can run on XP and edit SQL 2012, but their salespeople...
- 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
December 18, 2012 at 1:47 pm
Like this:
SELECT GETDATE(),
DATEADD(week, DATEDIFF(week, '19050101', GETDATE()), '19050101') AS StartOfWeek,
DATEADD(month, DATEDIFF(month, '19050101', GETDATE()), '19050101') AS StartOfMonth,
DATEADD(day, -1, DATEADD(month, DATEDIFF(month, '19050101', GETDATE())+1, '19050101')) AS EndOfMonth
I picked 1 Jan 1905 for this because...
- 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
December 18, 2012 at 1:39 pm
I don't think that works.
But you should be able to connect earlier versions of SSMS to SQL 2012, if I'm not mistaken. At least enough to write and execute...
- 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
December 18, 2012 at 1:06 pm
Revenant (12/18/2012)
GSquared (12/18/2012)
. . . But the book is always better than the movie (except Blad Runner, of course), so I use movies. . . .
Hmm... 2001: A Space...
- 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
December 18, 2012 at 1:05 pm
Here's the output when I run that:
master
Version Number Not Available
tempdb
Version Number Not Available
model
Version Number Not Available
msdb
Version Number Not Available
ReportServer
Version Number Not Available
ReportServerTempDB
Version Number Not Available
ProofOfConcept
Yes
ProofOfConcept2000
Version Number Not Available
DropMe
No
DropMe2
No
As you 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
December 18, 2012 at 12:28 pm
zilla (12/18/2012)
Here is the...
- 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
December 18, 2012 at 12:21 pm
Steve Jones - SSC Editor (12/18/2012)
... but I'm not sure how appropriate all my terminators are.
Sarah Conner thinks they're all inappropriate. (Yes, this week is that boring.)
- 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
December 18, 2012 at 11:54 am
patrickmcginnis59 (12/18/2012)
- 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
December 18, 2012 at 11:40 am
GilaMonster (12/18/2012)
GSquared (12/18/2012)
Anyway. It's entertaining. For about a week. Then it gets old. Really old.
Heard the same about The Old Republic, which I'm in the...
- 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
December 18, 2012 at 11:39 am
Viewing 15 posts - 301 through 315 (of 14,953 total)