Viewing 15 posts - 6,736 through 6,750 (of 14,953 total)
Luke L (4/5/2010)
GSquared (4/5/2010) I'm looking forward to the next installers, which will be either flash drives or something you download. BIOSes need to be able to fire up...
- 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
April 5, 2010 at 1:24 pm
Kit G (4/5/2010)
lmu92 (4/5/2010)
Kit G (4/5/2010)
... Memories of holding my breath during reboot hoping that the operating system (Windows 3.11) would come up abound. ...
Wasn't Windows 3.11 "just"...
- 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
April 5, 2010 at 11:57 am
Paul White NZ (4/4/2010)
You can't trust the database to enforce foreign keys anyway.😛 😀 😛
Considering that that bug has already been fixed, I'm not too worried about 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
April 5, 2010 at 8:04 am
So far as I know, SQL 2005 doesn't do built-in encryption on image data types. I could be wrong, but I don't think it does.
- 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
April 5, 2010 at 7:39 am
You'll need to look up the "query", "nodes", and "value" functions in Books Online. Those are the starting point for using SQL 2005/2008 XQuery.
Those allow you to query XML,...
- 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
April 5, 2010 at 7:36 am
The main advantage to multiple databases is the ability to scale out.
If you find that there's enough traffic to overload the server, you can move the busiest databases to another...
- 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
April 5, 2010 at 6:23 am
Paul White NZ (4/2/2010)
CirquedeSQLeil (4/2/2010)
I sit here and wonder how those people at the top are nearly perfect in the QOD with so many that were wrong.Multiple registrations?
The answer is...
- 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
April 5, 2010 at 6:10 am
Try this:
SELECT Car.value('(/cars/@model)[1]', 'varchar(100)'),
Quantity.Node.query('.').value('(/quantity/@shop_location)[1]',
...
- 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
April 2, 2010 at 10:55 am
I'd do multiple databases. Makes it easier to scale the whole thing out, plus lots of other advantages.
On the need for a single place to keep procs, would 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
April 2, 2010 at 10:41 am
GilaMonster (4/2/2010)
GSquared (4/2/2010)
I'd be specific. "Transactions in table variables can't be rolled back."
I dunno, that could give the impression that failed inserts/updates don't roll back (insert 10 rows, row...
- 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
April 2, 2010 at 9:37 am
Lynn Pettis (4/2/2010)
GilaMonster (4/2/2010)
GSquared (4/2/2010)
- 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
April 2, 2010 at 9:35 am
Lynn Pettis (4/2/2010)
GSquared (4/2/2010)
- 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
April 2, 2010 at 9:33 am
GilaMonster (4/2/2010)
GSquared (4/2/2010)
- 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
April 2, 2010 at 9:22 am
You can grant the right to create procedures specifically.
Would look like this:
GRANT CREATE PROCEDURE TO bob;
- 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
April 2, 2010 at 9:19 am
Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or as part 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
April 2, 2010 at 8:54 am
Viewing 15 posts - 6,736 through 6,750 (of 14,953 total)