Viewing 15 posts - 196 through 210 (of 459 total)
As for newsequentialid() not being able to be referenced directly, here's a kluge I've been using (not my idea, but liked it's simplicity):
-- default to one value returned
create proc get_newsequentialid
...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 18, 2009 at 12:30 pm
I know it sounds silly, but if your database is for a 3rd party application, check support for it. We have a database we're migrating from 2000 to 2005...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 14, 2009 at 1:33 pm
Bob Hovious (9/11/2009)
Paul got 8000, I think.Can someone point me to a good write up on IF... ELSE issues?
Such as an introduction? Try this link.
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 11, 2009 at 8:41 am
Mohan Kumar (9/9/2009)
Eg.
tbl1 Frag 38.88 PageCount18
tbl2 Frag 11.11PageCount9
tbl3 Frag 7.01 PageCount57
tbl4...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 11, 2009 at 7:43 am
Kit G (9/10/2009)
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 10, 2009 at 9:17 am
Kit G (9/10/2009)
Jan Van der Eecken (9/9/2009)
Didn't quite get the coconut - swallow connection either, but maybe I'm just a little slow.
This particular coconut/swallow reference is from Monty Python and...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 10, 2009 at 7:11 am
Andrew Gothard (9/9/2009)
For and non-trivial system, I'd go forOLTP - Normalisation
Reporting - from datawarehouse using dimensional modelling
True, in the best of all possible worlds, all reporting would be...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 9, 2009 at 12:22 pm
Thanks. So hopefully the windows admins have set it up the server properly. 🙂
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 1, 2009 at 10:55 am
Sourav (8/24/2009)
How to check when the indexes of a particular table \ all the tables of the DB was rebuilt??
Can you suggest me a good site to "create...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
August 25, 2009 at 7:04 am
Kit G (8/11/2009)
GabyYYZ (8/11/2009)
Any of our South African members hearing some buzz...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
August 11, 2009 at 2:24 pm
Anyone here planning to watch District 9 (this week I think)? It looks like a totally interesting sci-fi.
Any of our South African members hearing some buzz about it or...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
August 11, 2009 at 1:08 pm
Here's a thought.
Given that a binary representation of a value is as unambiguous a way to represent a value as you can get, explain how this occurs:
select convert(varbinary, convert(nvarchar(3),'674')); ...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
August 10, 2009 at 10:58 am
Love cppwiz's answer. LOL, wonder if the person ever did send the email.
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
August 4, 2009 at 9:36 am
Really? Is it so hard to Google "Database Design" for this person?
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 28, 2009 at 9:33 am
GilaMonster (7/27/2009)
allen davidson (7/27/2009)
I think my reply should have been along the lines of...clustered indexes affect placement on disk
Not necessarily true either. Think about fragmented indexes, fragmented file system, striping,...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 28, 2009 at 9:27 am
Viewing 15 posts - 196 through 210 (of 459 total)