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...
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"...
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.
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.
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,...
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...
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...
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]',
...
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...
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...
April 2, 2010 at 9:37 am
Lynn Pettis (4/2/2010)
GilaMonster (4/2/2010)
GSquared (4/2/2010)
April 2, 2010 at 9:35 am
Lynn Pettis (4/2/2010)
GSquared (4/2/2010)
April 2, 2010 at 9:33 am
GilaMonster (4/2/2010)
GSquared (4/2/2010)
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;
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...
April 2, 2010 at 8:54 am
Viewing 15 posts - 6,736 through 6,750 (of 14,953 total)