Jeffery Williams (10/22/2010)

---

Need to import a flat file that has a field count that exceeds allowable field count.

Is there a way to import this with breaks creating multiple tables, AND...

A sortable name is better. Makes it easier to look through the contents of a directory.

declare @bkdbName varchar(50)

set @bkdbName =

'myDB_LOG_BKUP__'+

replace(replace(replace(convert(varchar(19),getdate(),121),'-','_'),':','_'),' ','__')

select bkdbName = @bkdbName

Results:

bkdbName

-----------------------------------

myDB_LOG_BKUP__2010_10_21__12_19_56

There is no answer without knowing what that integer actually represents.

Many UNIX systems represent dates with integer values that are offsets in seconds or milliseconds from 1970-01-01 00:00:00. It's...

Use the DBCC SHRINKFILE command.

You can look up the syntax in SQL Server Books Online.

Yes, and if the system is architected so...

You may also want to look into the process that caused the dev and prod databases to get out of sync.

No point in fixing the problem just to see it...

And you may want to consider some of the points people mentioned on this other thread:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151816

SkyBox (10/19/2010)

---

Thanks for the great explanations everyone. I am beginning to put it all together now, but this raises more questions for my particular environment.

My call center enters sales...

The only hash functions built into SQL Server 2008 are MD2, MD4, MD5, SHA, or SHA1.

If you need another hash algorithim, you will need to create your own custom function...

If you decide you need to shrink the data files, you might find the script on the following link useful:

Shrink DB File by Increment to Target Free Space

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355

As has been...

David.Poole (10/16/2010)

---

I was on a consultancy job where we were the co-ordinator of all the clients' vendors. It was agreed with the data centre manager and the client that...

Do tables that reference table konten have indexes on their foreign key columns?

We had a database consulting company come in recently and develop a database and application exactly as specified by the VP of development.

Of course what he told them had nothing...

Only under specific conditions, which Gail pointed out NFS does not meet.

Description of support for network database files in...

David Portas (10/15/2010)

---

A primary key means exactly the same thing as...