Viewing 15 posts - 36,316 through 36,330 (of 39,771 total)
From what I understand, once the mdf is created, it is Zeroed out to ensure the state of the file. This is what takes the time.
Steve Jones
May 20, 2003 at 10:37 am
Have to test on your system and see. How many items? If it's not a large enough table, it will be scanned anyway.
Steve Jones
May 20, 2003 at 10:32 am
create procedure MySP
@var varchar(20) = null
as
if @var = null
Select * from news_items
else
Select * from news_items
where division = @var
Steve Jones
May 20, 2003 at 10:12 am
May 20, 2003 at 10:09 am
We have some apps that access SQL Server using JDBC. Use 3rd party drivers, Merant I think, not the MS driver. Works ok, only supports Standard Auth (by JDBC spec).
Steve...
May 20, 2003 at 10:01 am
I'd argue you have too many indexes and need to scale this back.
You could also horizontally parition the table into two. Even use a view to join them back and...
May 19, 2003 at 10:35 am
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
Viewing 15 posts - 36,316 through 36,330 (of 39,771 total)