Viewing 15 posts - 19,576 through 19,590 (of 26,490 total)
Okay, the following code parses and runs (with no result set generated, as I have no test data) in my sandbox database. You will need to make the appropriate...
July 23, 2009 at 11:07 pm
Tried that on a table on my system here at home. You will need to go into the scripts and add the collation for the character fields as appropriate...
July 23, 2009 at 9:41 pm
In the Object Explorer in SSMS, right click on the table and just follow the menu items until you script the table to the clip board. From there paste...
July 23, 2009 at 9:39 pm
Your best bet is to contact Microsoft. My understanding of the license agreement is that you need to install all the components on the same server that you license...
July 23, 2009 at 9:28 pm
Okay. Now all that makes sense. Thank you.
July 23, 2009 at 9:24 pm
I think I may see a way to improve this query but I am going to need to see the DDL including the collations for the tables. Please script...
July 23, 2009 at 9:21 pm
What Jeff was complaining about was the sudden change in language in the thread. Using French left the rest of out of the loop on what was going on...
July 23, 2009 at 8:57 pm
ps (7/20/2009)
Jeff Moden (7/19/2009)
Pradeep... I've seen your posts... have you a website I could visit?
Jeff, I work for HP GCI(Global center of India, Bangalore). I dont hv a personal website...
July 23, 2009 at 7:16 pm
Need the DDL (CREATE TABLE statements) for the tables involved. I'm not sure which columns are character columns and which aren't.
July 23, 2009 at 7:13 pm
We could use the DDL for the table (including indexes), some sample data (readily consummable), and your update queries.
Did you say that partitioning the table did not help the load...
July 23, 2009 at 7:06 pm
I tried reading Delany's Dhalgren in High School. I couldn't get through the first chapter before putting it down and never picking it up again.
July 23, 2009 at 5:22 pm
I do know that the data compression I get on our HR database is not as good as on the Finance database, but that I attribute to all the BLOB...
July 23, 2009 at 4:32 pm
george sibbald (7/23/2009)
July 23, 2009 at 4:27 pm
Not something I use or have heard about.
July 23, 2009 at 4:17 pm
Elliott W (7/23/2009)
On versions other than Enterprise (and Dev) you can create indexed views but the index will NEVER be...
July 23, 2009 at 4:15 pm
Viewing 15 posts - 19,576 through 19,590 (of 26,490 total)