Viewing 15 posts - 2,986 through 3,000 (of 3,232 total)
As always, there is a fine balance between standards/guidelines and the overhead of having to enforce them. I found these helpfull:
http://www.sql-server-performance.com/vk_sql_best_practices.asp
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx
http://msdn.microsoft.com/practices/
March 14, 2006 at 7:55 am
Run SQLdiag.exe and look in the [System Summary] section.
March 13, 2006 at 3:12 pm
So, as data is entered into one database, it needs to be immediately available in the second database? If so, have you considered having the CREP database just reference the...
March 13, 2006 at 11:05 am
Can you give a little more info on what you are trying to do? Do you need a one-time transfer, a routine transfer, real time syncronization? What does the table structure look like between...
March 13, 2006 at 10:31 am
A table level lock is a natural event and is part of the SQL Server locking architecture. There are many articles on this site devoted to locking, so I'll just...
March 13, 2006 at 9:54 am
Changing the datatype from char to varchar will reduce the amount of space each row of data in that table will require for storage. Datatype Char reserves a set amount...
March 10, 2006 at 9:25 am
Personally, I would say no. As I said in my first post, you will get more bang for your buck regularly keeping on top of SQL Server fragmentation by rebuilding...
March 9, 2006 at 8:57 am
If you are using the Windows defrag tool, you definately do not want to run it during business hours. For one, like Brian pointed out, you will see increased I/O,...
March 9, 2006 at 8:12 am
I thought you were running this through a stored procedure?? If so, run your stored procedure outside of ColdFusion so that you can debug your code. Once your code works,...
March 8, 2006 at 4:11 pm
What you are proposing should work. Are you getting an error message back from your second example?
March 8, 2006 at 3:45 pm
This may help, but then again, it may not:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=103789
March 8, 2006 at 3:33 pm
NewTechie,
You will be better served by placing your request in it's own thread.
March 8, 2006 at 3:19 pm
Have you created the format file NewProspectJoJo.fmt in E:\WUTemp?
March 8, 2006 at 3:17 pm
When you say that you are using a defragmenter, do you mean that you have a third party tool that will defragment your MDF and LDF files? If so, I...
March 8, 2006 at 3:13 pm
Is 'NewProspectJoJo' your spreadsheet name? Does 'E:\WUTemp\NewProspectJoJo.fmt' exist? Does the SQL Server service account have access to E:\WUTemp? It sounds to me like the format file does not exist (just...
March 8, 2006 at 3:06 pm
Viewing 15 posts - 2,986 through 3,000 (of 3,232 total)