Certs are wonderful things, but the classes needed to pass them don't usually give you the foundation knowledge you need to understand the 'under the covers' workings of an SQL-based...

I have no idea whether this would work, but you might try copying the data file to another server and attach it using the attach_rebuild_log option.  The you could back...

Yes.  Best practice is to run ONLY SQL Server on the server.  Anything else will lend itself to contention on disk, memory, or both.   

Unless you have to, I wouldn't run IIS on a SQL Server box because they'll both try to get as much memory as they can.  Was IIS running on your...

How much memory is SQL Server actually using?  How are the disks configured and what are the placements of the filegroups?  Is IIS running on the box?  Is the NIC...

Just whipping out the old crystal ball, I'd say you have at least one duplicate id number in the table, and since primary keys have to be unique, it can't...

Sorry about the English major crack.  No offense intended. The ability to use language skillfully and accurately is a talent and a discipline that can't be too highly rated.  Half the problems...

How about ....

ALTER trigger [dbo].[testinsert] on [dbo].[customer]

FOR INSERT

AS

if not EXISTS

(SELECT c.email

FROM contactinfo c

 join inserted i on c.email = i.email)

-- tying to check the new value is exist in...

Good luck!  I haven't gone the hired gun route because I'm one of those people who REALLY likes to know where my next meal is coming from (it's not lack...

Can you get it out of excel first?  CSV or tab delimited that a BULK INSERT could handle?

If not, I don't know of any way to bypass the OLE DB provider...

Mike,

The value in your output '2006-03-06 00:00:00.000' is one datetime (yyyy-mm-dd hh:mm:ss.hhh) value, for the first date column you selected, so your output is exactly as it should look if the...

Hmmmm....  I only see one datetime column in the output you provided, and it's longer than the 8 characters you provided for in the format file.  My guess is that...

So, where would you like to go?  If you know what the target is, and you're actively working to pick of the skills necessary to make you successful in that...

I was one of the Senior Database Guys for a major financial services company and now I'm the Senior Architect for a mid-sized bank.  My degree is in experimental psychology,...

Off the top of my head, I'd say you're trying to insert a row with a group id that doesn't yet exist in the table referenced by the foreign key...