Viewing 15 posts - 36,271 through 36,285 (of 39,717 total)
Wow, I was expecting more complaints against the article, but thanks for all the comments.
I see the "developers" argument, but with the Personal edition being available, I'm not sure it...
May 19, 2003 at 10:17 am
add a SQL task pointed to the Excel sheet and do a "drop table" with the table name. Basically in your transform, on the destination tab, select "create", then copy...
May 19, 2003 at 9:53 am
Not sure what this is, but suspect our minor mods caused an issue. We are pursuing an upgrade to Snitz 2000 or ASP.NET.
Apologies for the error.
steve
Steve Jones
May 19, 2003 at 9:51 am
Depends on the company. Interviewed with one last year and they were paying $60k. Another offered $80k+
As with any IT job, I've seen salaries all over the board, even in...
May 15, 2003 at 3:16 pm
Can't speak about why this was designed this way though I suspect it was either "easier" to get working or it isn't a substantial impact on performance. Of course, without...
May 15, 2003 at 3:14 pm
Agreed on the experienced thing, though it needs to be in each area. An experienced developer may not understand relational databases and an experienced DBA may not understand how to...
May 15, 2003 at 10:02 am
Is the data in a temp table? Do you mean to select back from the temp table? Or select a series of fields from a table based on what the...
May 15, 2003 at 9:56 am
It's kind of complicated what you are describing and a little confusing. A diagram would help, /images/networkimg.jpg. I changed a few names and for the linking tables, you don't need...
May 15, 2003 at 9:51 am
Actually, I believe you need a CAL OR a licensed "seat" on the server.
Steve Jones
May 15, 2003 at 9:31 am
Haven't seen this. Have you tried dropping and rebuilding the index? Dropping and rebuiling a clustered index on the table?
If it persists, I'd call MS before you experience data loss.
Steve...
May 15, 2003 at 9:13 am
Sorry, haven't upgraded analysis services, but we have upgraded numerous v7 servers and they work great. I'd take a full backup and then run the upgrade and you should be...
May 15, 2003 at 9:11 am
Thanks for the comments. I didn't get into the performance aspects since I haven't actually done the testing. We have genrously received a license from MS (thank!) for W2K3 here...
May 15, 2003 at 9:09 am
If you don't want to change the owner, in the database | users, select the user name, right click, properties, then select the db_owner role.
Steve Jones
May 14, 2003 at 11:41 am
This is personal, i.e. a desktop edition. It is not for lots of people to connect to and run queries. It's mainly for developers working on their machine.
You need to...
May 14, 2003 at 11:30 am
May 14, 2003 at 11:28 am
Viewing 15 posts - 36,271 through 36,285 (of 39,717 total)