Viewing 15 posts - 5,056 through 5,070 (of 8,416 total)
You could also use an SSIS package.
It has built-in features to do almost all of the stuff Jeff is suggesting, just by connecting a few dots.
March 19, 2010 at 9:15 am
Another contributing factor is that the read-ahead manager in SQL Server Enterprise is more aggressive than in Standard Edition, and can also issue large I/O - up to 1024KB (Standard...
March 19, 2010 at 9:09 am
GilaMonster (3/19/2010)
The Dixie Flatline (3/19/2010)
We get at most a few weeks of temperatures below freezing.What is this 'below freezing' that you mention?
Also intrigued.
edit: Thanks G2, I see. But why...
March 19, 2010 at 8:54 am
Martin Stephenson (3/19/2010)
text field but its not really used, for these purposes we can just drop it
Ok. I guessed at VARCHAR(100) in the end. I also added an...
March 19, 2010 at 8:52 am
What is the base data type for the alias type [dbo].[COMMENT]?
March 19, 2010 at 8:26 am
Steve Jones - Editor (3/19/2010)
Gotta run, getting the long stare from the horses that are looking for hay.
Be sure to say, "Hey, why the long face?"
March 19, 2010 at 8:24 am
tesker (3/19/2010)
I actually understand how/why this example works. Thanks!
Oh good! I included it because I know some people find that sort of query construction more natural.
It produces an...
March 19, 2010 at 8:21 am
gk-411903 (3/18/2010)
Is it possible to partition on a non primary key column and still switch partition?
In case you are unable to provide a test rig, please read the following, since...
March 19, 2010 at 8:18 am
SQL Dude-467553 (3/19/2010)
Thanks, I'll keep that in mind.
I was kinda hoping 2008 would address this, but I have just checked, at it is the same 🙁
March 19, 2010 at 8:12 am
Stefan_G (3/19/2010)
Hmm As far as I know it is not even possible to create a partitioned table with a partitioning column that is not included in the partitioning key.
It sure...
March 19, 2010 at 7:44 am
Several ideas. Can you post a (simplified if necessary) example table, a few rows of data, and the full-text query you are currently using? More detail on the...
March 19, 2010 at 7:20 am
sistemas_casinomnes (3/19/2010)
and how can I do to avoid the second result ?
It depends on exactly what you are using to connect to SQL Server.
The more you tell us about it,...
March 19, 2010 at 7:14 am
jcrawf02 (3/19/2010)
Plus, the word fright coming from a guy who lives in a land with names like Tauranga, Rotorua, Paihia...
Let us not forget aumata-whakatangihanga-koauau-a-Tamatea-pokai-whenua-ki-tana-tahu.
Anyone wondering how to pronounce it may...
March 19, 2010 at 7:11 am
As Peter showed, the only difference is this line:
INNER JOIN sys.database_principals AS stbl ON stbl.principal_id = ISNULL(tbl.principal_id, (OBJECTPROPERTY(tbl.object_id, 'OwnerId')))
tbl.principal_id comes from sys.objects (inherited by sys.tables). Its value is described...
March 19, 2010 at 7:06 am
pmoschkowitch (3/19/2010)
Thank you for your suggestions.We have solved the insert problem in changing the primary key into a non-clustered index.
Thank you for the feedback, but I thought you said the...
March 19, 2010 at 6:45 am
Viewing 15 posts - 5,056 through 5,070 (of 8,416 total)