Viewing 15 posts - 316 through 330 (of 391 total)
Dave,
I just setup a test. Set my collation to yours. Executed your script, recieved the same results.
Modified your script to what I had said:
CREATE TABLE tbl (x INT NOT NULL,...
June 25, 2010 at 5:49 am
David,
My next question to you after looking at your results - what is your collation and your collation sort order? Your results returned in your y column alpha-numeric.
And yes, my...
June 25, 2010 at 5:16 am
David, I am sorry but I would need to see your references on this.
When data is bcp'ed into a table, and there are no indexes of any kind, especialy clustered,...
June 24, 2010 at 7:17 pm
Nick,
What argument? 🙂
Tim (and Nick)
The data is stored in the order that it is loaded. I do not think that your issue is actually how it is stored.
When you issue...
June 23, 2010 at 10:42 am
I have found that it is sometimes helpful, especially on tables which are very large and have a lot of activity. In these cases I partition the table itself, with...
June 23, 2010 at 9:01 am
If you bulk insert the file into a table without a primary key on it, the records will be inserted in the order that they are in the file. After...
June 22, 2010 at 7:04 am
Orc,
Maybe this will help you:
Memory Settings:
http://support.microsoft.com/kb/274750
You may also get some more information from http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx
June 22, 2010 at 6:51 am
If memory serves me on Windows 2000, you can try to set the /3GB switch as well in order to pass the 3GB limitation. It would have to be on...
June 21, 2010 at 2:36 pm
Orc-91 (Sorry, just can't say that O word;-)
In order to set the AWE on, you will need to restart your SQL Server. You did say that you have the /PAE...
June 21, 2010 at 8:59 am
It was stated before - there are volumes written on how to remove duplicate records. Your case is not unique.
If you feel that these ways do not work for you,...
June 18, 2010 at 8:41 am
Kevin,
Try to drop the index and Primary Key which is involved first (preferably on a backup copy of the database) and then retry the dbcc. It appears that the errors...
June 17, 2010 at 11:19 am
Actually, I ran the code and the last SELECT statement returns 3 rows. How did you get 1 row?
Actually, the goal should be to read and think.
That being said, I...
June 11, 2010 at 9:05 am
Ambiguity is a playground of subtle bugs
I like it.
June 9, 2010 at 10:51 am
Avoiding uage of prefix sp_ improves the performance
When a stored procedure is executed using "sp_", SQL Server checks in the master first, as "sp_" is assumed to be reserved for...
June 9, 2010 at 7:08 am
vk - Excellent question. I got it wrong, then had to re-read the question. Next time I should make sure that I read the question thoroughly.
May 27, 2010 at 7:49 am
Viewing 15 posts - 316 through 330 (of 391 total)