Viewing 15 posts - 36,361 through 36,375 (of 39,810 total)
Our standard is
RAID 1 (c:) - OS + SQL OS
RAID 1 (f:) - SQL Logs
RAID 5 (g:) - SQL Data + backups.
If tempdb is heavily used (not most servers),...
May 19, 2003 at 10:33 am
Is your instance installed in the default path? /mssql$instance/binn? We had issues with the installer.
we also found that the original install path needs to be there.
Steve Jones
May 19, 2003 at 10:24 am
I hate spaces in names. I understand how they work well for WORD documents, but not for databases or object names.
Steve Jones
May 19, 2003 at 10:19 am
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
Viewing 15 posts - 36,361 through 36,375 (of 39,810 total)