Viewing 15 posts - 36,256 through 36,270 (of 39,717 total)
At PASS some of the MS guys mentioned that at around 400/sec, identities become a bottleneck. GUIDs do not as there are routines optimized for their creation. Not sure...
May 22, 2003 at 10:06 am
None I'm aware of. Are you looking for something to review T-SQL code?
Steve Jones
May 22, 2003 at 10:05 am
Likely a problem with the backup file. Can you take another?
Steve Jones
May 21, 2003 at 12:35 pm
Huge issue. DO NOT LOCK the table/row/record/whatever. The thing to do if you want it to work like this is add a flag to the table. When someone needs to...
May 21, 2003 at 12:32 pm
run backups of the dbs. Detach the dbs, you can detach msdb, but might be just as easy to restore.
Uninstall SQL. If you get errors, delete the files under program...
May 21, 2003 at 12:30 pm
Pronounce it however the person your're talking to does. Makes life simpler.
Steve Jones
May 20, 2003 at 10:42 am
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
Viewing 15 posts - 36,256 through 36,270 (of 39,717 total)