Viewing 15 posts - 1,621 through 1,635 (of 3,232 total)
Yes, you can. The keyword here is 'you' because you'll have to do it manually in SQL Server 2000. SQL Server 2005 does it all for you. ...
July 15, 2008 at 12:05 pm
You cannot tell SQL Server how to store the data within the data file itself. You can, however, use SQL Server 2005's table partitioning to store each table partition...
July 15, 2008 at 11:42 am
how much amount of knowledge i need to start my career as trainee dba
I think you're going to get a wide variety of answers to a question like this, but...
July 11, 2008 at 1:50 pm
Well then. I guess the whole point of my post was to let the world know that I have 5 kids and my younger brother has none 😀 .
July 11, 2008 at 9:53 am
Let's get back on track here. I think the question at hand is, 'Does moving the filtering columns from the JOIN to the WHERE clause have an impact on...
July 11, 2008 at 9:41 am
Well, your virtual memory represents your page file. There are a couple of things you need to know here. First off, most systems use the page file to...
July 10, 2008 at 4:08 pm
Here is a link to an article that was created to help new folks formulate posts that will get them the help they want. The information you've given so...
July 10, 2008 at 3:15 pm
Well, your right, it is an art and a science. First off, yes, disable the auto shrink. Secondly, as far as the fill factor goes, it all depends....
July 10, 2008 at 2:03 pm
-- Get Logical file names from backup header
RESTORE FILELISTONLY
FROM DISK = 'your backup file/path here'
-- use logical file info from above in restore statement
RESTORE DATABASE YourDBName
FROM DISK = 'your...
July 10, 2008 at 1:50 pm
Are we correct in thinking that the IF..ELSE..IF statement is the correct syntax for conditional posting of data?
No. Once you've normalized your tables, you won't need to worry...
July 10, 2008 at 1:47 pm
And that is what you want right?
July 10, 2008 at 1:36 pm
This sounds like a disk bottleneck to me. You've got your OS, paging file, and DB files all on one physical disk. Regarless of how you logically partition...
July 10, 2008 at 1:31 pm
OK, so based off of what you've just posted, can you tell my what is wrong with this:
DECLARE @TableA TABLE (KeyID varchar(20))
DECLARE @TableB TABLE (KeyID varchar(20))
INSERT INTO @TableA
SELECT '11111.001' UNION...
July 10, 2008 at 1:15 pm
So did you already create a database by that name on your destination server? If so, you'll need to do as Peter suggests and use WITH REPLACE. You...
July 10, 2008 at 1:08 pm
Grant, I would say that you are already a member.
Mark, that's great! How did you get Jeff's picture? Ha, he'll get a kick out of that!
July 10, 2008 at 12:53 pm
Viewing 15 posts - 1,621 through 1,635 (of 3,232 total)